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 option while creating the site and specify the number of databases that you can create.
Web sites comprise data entities that can be organized in databases enabling you to retrieve and process the data with ease. Often, the volume of data can get overwhelming, and you will be challenged with the need to distribute your data efficiently.
Multiple databases enable you to organize your site's data more effectively and efficiently.
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.
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