Allowing remote MySQL connections is often done to enable a program on your personal computer to access a database on the server.
1. go to your cPanel and Under Databases, select remote MySQL icon
2. Add the Remote IP
Use the following configuration settings for connecting to your database:
Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (the password you entered for that database user)
MySQL Connection Port = 3306
TCP or UDP, either is fine.
You can domains IP here
