Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
I am trying to get my head round mysql. I found a grat tuorial on the internet but accidentally messed up one of the commands and now cannot get into mysql as root.
I need to scrub the settings I have entered thus far and start from scratch again.
Can anyone tell me where the file is with the passwords/user settings in please?
I am trying to get my head round mysql. I found a grat tuorial on the internet but accidentally messed up one of the commands and now cannot get into mysql as root.
I need to scrub the settings I have entered thus far and start from scratch again.
Can anyone tell me where the file is with the passwords/user settings in please?
The username and password are stored within the db or tables, etc.
Have you simply tried to su to root on your machine and just running mysql, without specifying the password?
su -
<password>
mysql
mysql>
Should throw you right into the tables where you can update the password there.
su
<password>
mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
mysqladmin -u root password xxxxx
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
(as root)
mysql -p
xxxx
mysql>
however, I cannot enter the "mysqladmin blah" command from within mysql
hence wanting to know where the appropriate settings are kept so I can start from the beginning again with ALL settings
apologies if I haven't understood something fundamental here
like I said, trying to get the old head round mysql, started yesterday afternoon, screwed it up within 5 minutes
doh!
have just managed to get knoda working, this allows for creation and manipulation of databases
and also managed to get a database created using openoffice
seriously steep learning curve!
(bearing in mind I've used access about three times and that is my total exeperience with databases)
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.