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 the 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 your problem is still not resolved, you need to check if the database user has the IP listed against it by the 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.

 

 

Was this answer helpful? 0 Users Found This Useful (0 Votes)