[Solved] Remote MYSQL connection not working in cPanel account
Remote MYSQL database not connecting from a cPanel based interface even after whitelisting your remote IP from “remote MYSQL” ?
It must be due to faulty MYSQL CNF file (my.cnf).
Here are the quick steps to fix this :
- Open my.cnf file in terminal using following command :
sudo nano /etc/my.cnf
- Locate the bind address (bind_address) in the file and change it to 0.0.0.0
Save the file and restart mysql service.
In case you problem is still not resolved, you need to check if the database user has the IP listed against it by following steps :
- Type mysql and run the following command
select User,Host from mysql.user;
This will list all the users and the remote IPs allocated against them.