Knowledgebase

how do I configure a mysql database for remote connection?  Print this Article

  1. Determine the IP address that you will use to connect to the database.
  2. Add this IP address to the Host field in the Remote MySQL section of cPanel (Home >> Databases >> Remote MySQL).

Was this answer helpful?

Also Read

how can I backup a mysql database?
Run one of the following commands:   /path/to/bin/mysqldump -u $mysqlusername...
how do I import a mysql database?
Login to cPanel. Locate and click on the "phpMyAdmin" icon under the "Databases" category....
how do I add a user to a mysql database?
Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...
why the mysql version shows a different version in phpinfo than installed on the server?
The API version you see in phpinfo is the built-in MySQL API that is included in PHP. If the...
can users be assigned privileges to a certain number of mysql databases and a different number of postgresql databases?
No. However, packages allow you to set the maximum number of databases an user can create...