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.