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

标签：