Big problem changed root password for mysql can't login pls comment
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.
Big problem changed root password for mysql can't login pls comment
I changed mysql root password and somehow now I can't login, i also deleted anonymous accounts how to deal with that, I tried restarting the server.. no luck so far
I used:
mysqladmin -u root password "my_new_password" <--- seems I should have used ' ' not " "...
I tried rpm -e all mysql stuff and reinstalled it and again it asks for that strange password I set ... I can't use it.
I ran into exactly the same problem the first time I tried to install MySQL. I uninstalled it several times (I did not use RPM to install it, I installed from a binary package, so I just stopped it and physically went and deleted all its files and directories) and installed it again until I got it working as regards the root password.
What I would suggest is uninstall it (if you can - you say rpm -e doesn't work? I HATE RPM) then install it again.
When it is done installing, set your "root" MySQL password by doing:
[root@StefanLinux rylan]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> set password for root@localhost=password('yourpasshere');
and afterward log into MySQL with
[root@StefanLinux rylan]# mysql -u root -p
Password: <type your password here>
If I remember right, the method you posted that you tried to use is the very same one that locked me out a few times as well.
you hate rpm but use RedHat same here but I consider it more useful, but ontopic I can't do anything I don't have access to "root@StefanLinux rylan]# mysql -u root mysql"
Yeah I like RedHat distros but not their package system...
The fact that I was root (in my shell) doesn't affect the fix I suggested. The MySQL root user and the Linux shell root user are IMO two different things. You can still be a normal, non-root Linux user but have access to MySQL's root-level. (I think!)
Yeah I like RedHat distros but not their package system...
The fact that I was root (in my shell) doesn't affect the fix I suggested. The MySQL root user and the Linux shell root user are IMO two different things. You can still be a normal, non-root Linux user but have access to MySQL's root-level. (I think!)
Well, the only workable fix I can then think off (if you can't get your installed MySQL to uninstall or otherwise remove it) is to re-install, but to make sure that in Anaconda you do NOT select to install MySQL, Apache, or PHP. Then, once the system is up, install from the source and binary tarballs for Aparche and PHP, and MySQL.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.