My root user is enabled and I checked to see that the password is the same as my user login (and the same as it's always been) -- but every time I try to run it, whether it be through Terminal or through Sequel Pro, I always get the same: Access denied for user 'root'@'localhost' (using password: YES). MYSQL says #1045 - Access denied for user 'root'@'localhost' (using password: NO) I have tried OLD_PASSWORD technique which won't work. I have almost wasted 2 days on this. Can someone really suggest how to come out of this and make phpMyAdmin work. Following are the edits i have done in config.inc.php file. Its just the mysql security model; its a little different from most. Search the 'net for 'mysql login localhost' and you can see many many better explanations than I can make;-) HTH Tim Clarke On 09/02/10 18:25, k_murli_krishna via mysql-l wrote: > Posted by k_murli_krishna > > on Feb 9 at 1:27 PM > > 1) We have installed MySQL 5.0 on WIndows 2003 server > 2) Service is running and in automatic mode. Even I am able to restart > the service. > 3) When I try at command prompt: > mysql -h localhost > mysql -u root -p > I am getting both 'Access denied for user 'root'@'localhost' (using > password: NO)' & Access denied for user 'root'@'localhost' (using > password: YES). > 4) I am sure about password of root. How can I overcome this problem? Try 127.0.0.1 instead of localhost Mark Posted by tim.clarke on Feb 9 at 1:37 PM Mark this reply as helpfulMark as helpful Its just the mysql security model; its a little different from most. Search the 'net for 'mysql login localhost' and you can see many many better explanations than I can make;-) HTH Tim Clarke On 09/02/10 18:25, k_murli_krishna via mysql-l wrote: > Posted by k_murli_krishna > > on Feb 9 at 1:27 PM > > 1) We have installed MySQL 5.0 on WIndows 2003 server > 2) Service is running and in automatic mode. Even I am able to restart > the service. > 3) When I try at command prompt: > mysql -h localhost > mysql -u root -p > I am getting both 'Access denied for user 'root'@'localhost' (using > password: NO)' & Access denied for user 'root'@'localhost' (using > password: YES). > 4) I am sure about password of root. How can I overcome this problem? On 9 February 2010 23:55, k_murli_krishna via mysql-l wrote: > Posted by k_murli_krishna > on Feb 9 at 1:27 PM > 1) We have installed MySQL 5.0 on WIndows 2003 server > 2) Service is running and in automatic mode. Even I am able to restart the > service. > 3) When I try at command prompt: > mysql -h localhost > mysql -u root -p > I am getting both 'Access denied for user 'root'@'localhost' (using > password: NO)' & Access denied for user 'root'@'localhost' (using > password: YES). > 4) I am sure about password of root. ![]() How can I overcome this problem? Hi Koneru Murli Krishna, if its a newly created Mysql Instance then it wont be having any password, if its a newly created MysqlInstance then you can try the below from the command line. Mac os x file formats 2017. Mysqladmin -u root password; eg: mysqladmin -u root password '123'; then try logging into mysql instance with this password, mysql -u root -p 123 if you are trying to login this mysql instance from remote machine then you need to give Grant privilege on remote as well as localhost, then flush privileges.
0 Комментарии
Оставить ответ. |