Support Center > Knowledgebase > Web Host Manager > Database Information
-
You can set the maximum number of total databases that user can create with packages, as well as when creating accounts without packages.
If you...
-
Rune either of the following commands:
/path/to/bin/mysqldump -u $mysqlusername -p$mysqlpassword $mysqldatabasename > backup.sql
mysqldump -u...
-
You will need to add the IP address from which you wish to connect to the databse in the Remote MySQL section of the cPanel interface.
-
You will need to use the Databases section and add a database under PostgreSQL Databases or MySQL Databases. Just fill in the name of the database...
-
You will need to import data from the command line into MySQL. The way you will do this depends on the type and format of the data you wish to...
-
Using a remote MySQL setup, will be functionally the same a using a local setup. Since you are configuring all your customer connections to occur...
-
Make sure root pass is in /root/.my.cnf.
This is usually the first root pass the box was given once cpanel is installed. If it still does...
-
The API version you see in phpinfo is the builtin mysql api included in php. If the buildapache application used the ibraries and headers of mysql...
-
* To begin, visit http://www.mysql.com/doc/en/Gone_away.html
Most likely, you will need to restart mysqld with the -O max_allowed_packet=#...
-
Port 3306 can be used for remote MySQL connections. You will need to configure access in the Remote MySQL section of your cPanel interface.