- SSH into the server.
- mysql -u root -p
- enter password
- SHOW GRANTS FOR 'username'@'localhost';
- GRANT ALL PRIVILEGES ON . TO 'username'@'ip_address' IDENTIFIED BY 'password';
- FLUSH PRIVILEGES;
- Try to connect database using mysql client
How to connect to remote database using ip address
Manish Chaudhary - Mar 20 '23 - 
