About Multiple MySQL Databases

Your hosting services make it possible to use multiple MySQL databases with your site.

Note: To use multiple MySQL databases, your service provider must enable the MySQL service while creating the site and specify the number of databases that you can create.

Creating Multiple Databases

Your service provider determines the number of databases that can be created for your site. As of now, the control panel supports only one user per database.

Note: The control panel does not implicitly create databases when a site is created, even if the site is enabled to support the MySQL database service.

• The disk space consumed by a database counts toward a site's total disk quota. If a database consumes disk space in excess of the site's disk quota, you will receive an error stating that the disk is full.  
• The databases are backed up when you back up the site.

Administering Databases

MySQL databases are administered by the database administrator designated by your service provider. Database administrators cannot create or delete databases. You cannot change the name of the database administrator though you can change the password.

Note: To perform operations on a database as the Site Administrator, you must be assigned the role of the Database Administrator by your service provider, and log in using this information. You cannot perform operations on a database using your site user name or password.

As a Site Administrator, you can:

• Create MySQL databases
• Delete MySQL databases