Adding, Remove, Manage, and Backup MySQL Databases Using DotNetPanel

Adding, Remove, Manage, and Backup MySQL Databases Using DotNetPanel

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.

mysql.png

Adding MySQL Database 

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

mysql_db.png

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.

mysql_backup.png

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.

mysql_user.png

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.

Add Feedback