Access denied

Solution:

Run below command under root  

Command 1

GRANT ALL PRIVILEGES ON *.* TO ‘USERNAME‘@‘IP‘ IDENTIFIED BY ‘PASSWORD‘;

　　

where IP is the IP you want to allow to access and USERNAME is the user you use to connect

If you want to allow access from any IP just put  %  instead of your IP

 

Command 2

FLUSH PRIVILEGES;

　　

This command is to make setting take effect.

Access denied

标签：

查看更多关于Access denied的详细内容...