MySQL is one of the most popular Open Source SQL database management systems with more than six million installations. MySQL is popular for web applications and acts as the database component of the Linux/Mac/Windows-Apache-MySQL-PHP/Perl/Python platforms, and for open-source bug tracking tools like Bugzilla. Its popularity as a web application is closely tied to the popularity of PHP, which is often combined with MySQL.
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 SQL Server 2005 database, open SQL Server 2005 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.