Connect remotely to MySQL databases created on centos Server

Add local ip in whm in remote Additional mysql access hosts

Mysql should be running 

port 3306 should be open

From Server-wide changes login to Back-end

cd /etc/

vi my.cnf

add server ip

#bind-address=IP address(Local IP)   // do not forget make previous ip as comment

bind-address=Server IP where Database is stored

Service mysql restart

From Cpanel

• When Cpanel using X3 theme, login to Cpanel and click the Remote MySQL , under Databases.
• Type in the connecting IP address i.e your local IP address, and click the Add Host, Now restart mysql and try to connect.

• When using X, login Theme to Cpanel and click the MySQL Databases, under Databases.
• Scroll to the bottom and type in the connecting IP address where it says "Host (% wildcard is allowed):", and click the Add Host, Now restart mysql and try to connect.