Managing MySQL 5.0 Databases

Viewing MySQL Databases
To view the list of MySQL databases, click Databases >> MySQL 5.0 menu item on your space page. MySQL 5.0 page will open.

Adding MySQL Database
To add a new MySQL database, click Create Database button. SQL Database Properties page will open.

Type the name of your database in the Database name box. Choose users to access your database and click Save button.

Backing up MySQL Database
To backup mySQL 5  database, open mySQL 5 page. Choose database that you wish to backup and click on the database name. SQL Database Properties page will open. Click Backup button. Backup SQL Database page will open.

In the Backup File Name box, type the name of the file where backup data will be stored. Check Zip Backup box if you want to zip backup file. Choose the backup destination and click Backup button.

Adding MySQL Database User
To add a new MySQL database user, open MySQL 5.0 page and click Create User button. SQL User Properties page will open.

Type the name and password of the database user in the User name and Password boxes. Choose databases which the new user can access and click Save button.

Deleting MySQL Database
To delete MySQL database, open MySQL 5.0 page. Choose database that you wish to delete and click on the database name. SQL Database Properties page will open. Finally, click Delete button.

Deleting MySQL Database User
To delete MySQL database user, open MySQL 5.0 page. Choose database user that you wish to delete and click on the user name. SQL User Properties page will open. Finally, click Delete button.