开发者

How to resolve error "Access is denied for root@localhost error" in phpMyAdmin and SqlYog (Windows 7)

开发者 https://www.devze.com 2023-03-24 14:15 出处:网络
I have installed xampp and sqlyog, but when I try to open xampp phpMyAdmin gives me this error: 1045 - Access denied for user \'root\'@\'localhost\' (using password: NO)

I have installed xampp and sqlyog, but when I try to open xampp phpMyAdmin gives me this error:

1045 - Access denied for user 'root'@'localhost' (using password: NO) Connection for controluser as defined in your configuration failed.

When I try open SqlYog, it also shows an 开发者_开发问答error:

Error No :2003 Can't connect to MySql Server on localhost(10061)

How do I resolve errors?


The error no 2003 is described in Webyog FAQ here, please go through this: http://www.webyog.com/faq/content/23/15/en/error-no-2003-can_t-connect.html

And, error 1045 is the the most common authentication error : http://webyog.com/faq/content/23/18/en/error-no-1045-connection-denied.html (if this is the problem then first check that the user is allowed to connect from remote hosts. User should be defined as 'user'@'%' and not 'user'@'localhost')


Given that SqlYog seems to be a commercial software, I haven't used it. But looking at their site I found this in their FAQ - http://www.webyog.com/faq/category/16/how-does-sqlyog-connect-to-mysql.html . Hope it helps.

0

精彩评论

暂无评论...
验证码 换一张
取 消