Access denied

Problem:

Below error encounterred when connecting to remote server in PHP code.

Access denied for user 'root'@'192.168.233.163' (using password: YES)

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.