Blog

23 Aug
2018
ColorHosting BaseZap

Enable and Use Remote MySQL Connections in cPanel

Wondering if you can connect your website’s Database on your Local Computer? Yes, absolutely you can.¬†There are a few programs you can use to connect remotely to your database. You can utilize HTML editors like Adobe Dreamweaver for a fee, or there are free Open Source programs you can use like MySQL Workbench or Heidi […]

25 May
2018
ColorHosting BaseZap

[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¬† […]