The MySQL Databases interface in your cPanel control panel lets you create, manage, and delete MySQL® databases and database users.
Please note that phpMyAdmin should not be used to create databases and database users as it does not map databases, causing problems with backups.
Accessing the MySQL Databases interface
Login to your cPanel control panel using your web browser. Go to 'http://www.yourdomain.com/cpanel/' (without the quotation marks). So if your domain name is 'example.com' you should go to 'http://www.example.com/cpanel/' to login to your control panel. The MySQL Databases interface is in the "Databases" tab, simply click on the name or the icon to enter.
Creating a database
- In the "Create New Database" section, write the name for the database in the "New Database" text box.
- Click "Create Database", a new page will open.
- Click "Go Back" and your new database will appear in the "Current Databases" table.
Adding a MySQL user
- In the "MySQL Users" section, write the username of the user in the "Username" text box.
- Enter password and password confirmation. We suggest using the Password Generator.
- Click "Create User" button, a new page will open.
- Click "Go Back" to return to the previous page.
Adding a user to a database
- In the "Add User To Database" section, select the user and database from the menus.
- Click "Add", a new page will open.
- Select checkboxes that indicate the privileges you'd like to grant to the MySQL user.
- Click "Make Changes".
- Click "Go Back" to return to the previous page.
Checking a database for errors
- In the "Modify Databases" section, select the database in the "Check Database" dropdown menu.
- Click "Check Database", a new page will open.
- Click "Go Back" to return to the previous page.
Repairing a database
- In the "Modify Databases" section, select the database in the "Repair Database" dropdown menu.
- Click "Repair Database", a new page will open.
- Click "Go Back" to return to the previous page.
Renaming a database
- In the "Current Databases" section, click "Rename" next to the database you'd like to rename.
- Write the new database name in the "New name" text box.
- Click "Proceed".
Deleting a database
- In the "Current Databases" section, click "Delete" next to the database you'd like to delete, a new page will open.
- Click "Delete Database" to permanently delete it.
- Click "Go Back" to return to the previous page.
If you need more assistance with this subject, please contact Virgo Hosting Support by opening a support ticket. We'll be happy to help.
In order to contact our support department, please follow these steps;
In order to contact our support department, please follow these steps;
- Sign in to your client portal from the following URL: https://clientportal.virgohosting.com
- Click "Support" link in the menu to access the "Support Tickets" interface. If you're accessing the client portal from a mobile device, the menu may be accessible by clicking the "MENU" icon depending on your screen resolution.
- Click "Submit New Ticket" button.
- Choose the help desk you'd like to send your support ticket to from the "Help Desk" dropdown menu.
- Enter the support ticket subject and your message in the appropriate text boxes.
- Click "Submit" button. Our support staff will reply to your ticket as soon as possible