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.
Ucartz services for this topic
- Managed cPanel VPS: cPanel included; we handle updates, security and monitoring.
- cPanel server management: hardening, migrations and 24/7 monitoring, with no long-term contract.
- cPanel, Plesk and LiteSpeed licences: for VPS and dedicated servers, with installation help on demand.
