Managing MySQL 5.0 Databases

  Print
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 Server 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.

Did you find this article useful?   0 out of 0 people found this article useful.

Related Articles

Login

 
Forgot password?
Register now

Language