#1045 - Access denied for user 'root'@'localhost' (using password: NO) I looked on this site and tried the following with no luck. PhpMyAdmin tried to connect to the MySQL server, and the server rejected the connection.
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. Note that registered members see fewer ads, and ContentLink is completely disabled once you log in. Are you new to LinuxQuestions.org? Visit the following links: If you have any problems with the registration process or your account login, please. If you need to reset your password,.
Having a problem logging in? Please visit to clear all LQ-related cookies. Introduction to Linux - A Hands on Guide This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration.
This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own. To receive this Complete Guide absolutely free.
Hi, I was setting up mysql server on my box running Fedora Core 13. Please see the version below - ' mysql Ver 14.14 Distrib 5.1.51, for redhat-linux-gnu (i386) using readline 5.1 ' I ran /usr/bin/mysqlsecureinstallation for some configurations Gave root password, restarted mysqld service and did this - $ mysql -u root -p It allowed me to log in. Then I imported a test.sql db.
![Denied Denied](/uploads/1/2/5/4/125440849/825211367.png)
![root root](https://i.ytimg.com/vi/oz6BTvpn3qY/maxresdefault.jpg)
Rebooted the box. Now when I tried to login to mysql - I get the following error even after keying in the correct password. 1045: Access denied for user 'root'@'localhost' (using password: YES) I have not installed phpmyadmin yet.
I went through MySql forums, didn't find any valuable post which could solve this. Some said to re-install Mysql, I did so, it worked perfectly until box was rebooted. Same error promts when I login next time. It would be a great if anyone in this forum can support me here.
It has become a blocker for my development work as well. @SilverBack I am not able to get the mysql promt in both ways -as 'normal' or 'su -' @Flyte I did visit that link earlier, it couldn't change mysql password. Or if it would have changed it is not allowing me in with new password.
When I remove /var/lib/mysql directory and re-install mysql. I am able to login to mysql, change DB and say grant all privileges on DB. to user@localhost identified by pswd; I get encounter new error - 'ERROR 1133 (42000): Can't find any matching row in the user table' When I exit out of mysql and try logging in it doesn't allow. (Error 1045). Are you sure that sql import did not affect this all? Can you see what that sql script contains?
No, I do not think so that sql import has caused any issue. When I re-installed Fedora for third time, I tried with empty.sql file $ echo ' blank.sql $ mysql -u root -p and logged out of mysql I was unable to login for the next time. But, again as per you said, let me go through main DB.sql file and grep for 'user'. If this returns something unexpected. I think we are close to results then.