MySQL Databases

View a list of your MySQL users and the databases they are associated with.You can use the MySQL Databases section of the hosting Control Panel to manage your MySQL databases, users, and their privileges via four tabs - Databases, MySQL users, Privileges, and Database Converter. Each of these tabs allows you to perform different actions:

The Databases tab allows you to:

Create a new database.
Access phpMyAdmin.
Import a MySQL dump into a database.
Export a MySQL dump from a database.
Delete a database.

The MySQL users tab gives you the ability to:

Add a MySQL user.
Change the password for a MySQL user.
Enable remote connections for a MySQL user.
Delete a MySQL user.

Assign Privilegesto your MySQL users:

Associate a MySQL user with a database (or change the assigned privileges).

Using the Database Converter tab, you can:
- Convert a MySQL 5 database to MySQL 8.
- Search for applications using your MySQL 5 database.

Databases

The Databases section shows a list of your databases and the MySQL users associated with them. It also allows you to apply the following changes:

Create a database

Select the MySQL version from the menu on the top. Two versions are available: MySQL5 and MySQL8.
Scroll down to Databases, and click on Create new database.
Enter the database name. The full name will be prefixed with your account username, e.g. if you enter dbuser, the created username will be username_dbuser.
Select a collation. By default, the utf8mb4_general_ci collation is selected for MySQL 5 databases and utf8mb4_0900_ai_ci for MySQL 8 databases.
Choose the MySQL username to associate with the new database. You can create new, use existing, or add none (this means that only the Control Panel username will have permissions).
Choose the password, and type it in the Password and Confirm Password fields.

As you type your new password, a strength indicator below the field updates in real time. It shows one of four strength levels. You’ll also see tips and requirements in a red tooltip just below the indicator to help you create a stronger password.
You can check the article on Choosing a password or the one on using the Random password generator for more details on setting up a good password.
Click on Create.

Access phpMyAdmin

The phpMyAdmin program is available on the server, and you can use it to manage your databases. You can log in through the phpMyAdmin section of the hosting Control Panel or by using the phpMyAdmin link from the MySQL Databases section.

Detailed information on using the phpMyAdmin program is available in the Using phpMyAdmin section of our online documentation.

Note: There are separate phpMyAdmin programs for MySQL 5 and MySQL 8, so you cannot manage MySQL 5 databases if you are logged in the phpMyAdmin program for MySQL 8.

Import a MySQL dump into a database

There are two ways of importing MySQL dumps through the hosting Control Panel:

Using the Import Wizard

To import a database through the Import Wizard, please follow the steps:

Select the MySQL version from the menu at the top.
Click on the Gear icon next to the database.
Choose Import.
Choose to upload the MySQL dump file or click on or select uploaded file, navigate to the file, and click Use selection.
Select the encoding.
Click on Import.

Using phpMyAdmin

To import a database through phpMyAdmin, please follow the steps:

Log into phpMyAdmin.
Check the Importing a database using phpMyAdmin article.

Export a MySQL dump from a database

Here are the three easiest ways to export the SQL dump/schema file of a database:

via the MySQL databases section of the hosting Control Panel
through phpMyAdmin
via the Backup section of the hosting Control Panel

Exporting a database via the MySQL Databases section of the hosting Control Panel

If you wish to export your database via the MySQL Databases section of the hosting Control Panel, follow these steps:

Select the MySQL version from the menu at the top.
Click on the Gear icon next to the database.
Click on the Export button.
Your backup archive will show up in the /private directory once completed.

You can check the status of the export operation in the Activity Logs section, reachable by the button in the upper-right.

Exporting a database through phpMyAdmin

You can find step-by-step instructions on how to export a database through phpMyAdmin in our Exporting a database using phpMyAdmin article.

Exporting a database via the Backup section of the hosting Control Panel

You can use the Backup section of the hosting Control Panel to create a backup of all your MySQL databases. Detailed information on using the Backup section is available in our Backup article.

Delete a database

To delete a database, please follow these steps:

Select the MySQL version from the menu at the top.
Click on the Gear icon next to the database.
Click on the Delete button.

MySQL users

The MySQL Users section shows a list of your MySQL users and the databases they are associated with. It also allows you to apply the following changes:

Add a MySQL user

To create a MySQL user, please follow these steps:

Select the MySQL version from the menu on the top.
Scroll down to MySQL users, and click on Create new MySQL User.
Enter the username.
Enter the password in the Password and Confirm Password fields.

As you type your new password, a strength indicator below the field updates in real time. It shows one of four strength levels. You’ll also see tips and requirements in a red tooltip just below the indicator to help you create a stronger password.
You can check the article on Choosing a password or the one on using the Random password generator for more details on setting up a good password.

Change the password for a MySQL user

To change the password of a MySQL user, please follow these steps:

Select the MySQL version from the menu on the top.
Scroll down to MySQL users.
Click on the Gear icon next to the user.
Click on Change Password.

As you type your new password, a strength indicator below the field updates in real time. It shows one of four strength levels. You’ll also see tips and requirements in a red tooltip just below the indicator to help you create a stronger password.
You can check the article on Choosing a password or the one on using the Random password generator for more details on setting up a good password.

Enable remote connections for a MySQL user

By default, all created MySQL users are allowed to access the MySQL server locally through a script that runs on the server. In case you need to access your database using an application installed on your computer (e.g. NaviCat, MySQL Front, MySQL Control Center, or Query Browser), you need to allow remote connections for the respective MySQL user.

On our servers, remote access is enabled per MySQL user, so when you enable remote connections for a MySQL user, this MySQL user will be able to connect remotely to all databases it is associated with.

To enable remote connections for a MySQL user, follow these steps:

Select the MySQL version from the menu on the top.
Scroll down to MySQL Users.
Use the toggle next to the user in the Remote Connections column.

The MySQL connection details are listed in the MySQL Connection Settings table.

Note: If you are using views in your MySQL databases, enabling/disabling remote connections for your master MySQL user may lead to problems with them, due to the change of the type of access. Therefore, in case you have MySQL views in any of your databases, it is strongly recommended that you use a separate MySQL user for remote connections.

Delete a MySQL user

To delete a MySQL user, please follow these steps:

Select the MySQL version from the menu on the top.
Scroll down to MySQL users.
Click on the Gear icon next to the user.
Click on Delete.

Privileges

Here, you can control what priviliges are assigned to your MySQL users.

Grant database privileges to a MySQL user

To allow a MySQL user access to a database, please follow these steps:

Select the MySQL version from the menu at the top.
Click on the Gear icon next to the database.
Choose Privileges.
The database name will be filled by default.
Select the username in the MySQL User field.
Choose the privileges you wish to grant, or click on Select All.
Click Save.

Database Converter

The Database converter tab on the MySQL Databases page of the hosting Control Panel allows you to convert your existing MySQL 5 databases to MySQL 8. The converter automatically takes care of creating the same MySQL 8 database, usernames, and assigned privileges, making it easy to upgrade your applications to use MySQL 8.

Convert a MySQL 5 database to MySQL 8

To convert a MySQL 5 database to MySQL 8, please follow the steps:

Choose Database Converter from the menu at the top.
Select the database to convert through Source database name (MySQL 5).
In the MySQL tab, select Synchronize password next to your database user.
Click on Convert.

You can use the Search button in the Database name search tab to find configuration files containing your database. This will help you to easily update them with the new details.


	Online Manual » Control Panel 3 » MySQL Databases MySQL Databases View a list of your MySQL users and the databases they are associated with.You can use the MySQL Databases section of the hosting Control Panel to manage your MySQL databases, users, and their privileges via four tabs - Databases, MySQL users, Privileges, and Database Converter. Each of these tabs allows you to perform different actions: The Databases tab allows you to: Create a new database. Access phpMyAdmin. Import a MySQL dump into a database. Export a MySQL dump from a database. Delete a database. The MySQL users tab gives you the ability to: Add a MySQL user. Change the password for a MySQL user. Enable remote connections for a MySQL user. Delete a MySQL user. Assign Privilegesto your MySQL users: Associate a MySQL user with a database (or change the assigned privileges). Using the Database Converter tab, you can: Convert a MySQL 5 database to MySQL 8. Search for applications using your MySQL 5 database. Databases The Databases section shows a list of your databases and the MySQL users associated with them. It also allows you to apply the following changes: Create a database Select the MySQL version from the menu on the top. Two versions are available: MySQL5 and MySQL8. Scroll down to Databases, and click on Create new database. Enter the database name. The full name will be prefixed with your account username, e.g. if you enter dbuser, the created username will be username_dbuser. Select a collation. By default, the utf8mb4_general_ci collation is selected for MySQL 5 databases and utf8mb4_0900_ai_ci for MySQL 8 databases. Choose the MySQL username to associate with the new database. You can create new, use existing, or add none (this means that only the Control Panel username will have permissions). Choose the password, and type it in the Password and Confirm Password fields. As you type your new password, a strength indicator below the field updates in real time. It shows one of four strength levels. You’ll also see tips and requirements in a red tooltip just below the indicator to help you create a stronger password. You can check the article on Choosing a password or the one on using the Random password generator for more details on setting up a good password. Click on Create. Access phpMyAdmin The phpMyAdmin program is available on the server, and you can use it to manage your databases. You can log in through the phpMyAdmin section of the hosting Control Panel or by using the phpMyAdmin link from the MySQL Databases section. Detailed information on using the phpMyAdmin program is available in the Using phpMyAdmin section of our online documentation. Note: There are separate phpMyAdmin programs for MySQL 5 and MySQL 8, so you cannot manage MySQL 5 databases if you are logged in the phpMyAdmin program for MySQL 8. Import a MySQL dump into a database There are two ways of importing MySQL dumps through the hosting Control Panel: Using the Import Wizard To import a database through the Import Wizard, please follow the steps: Select the MySQL version from the menu at the top. Click on the Gear icon next to the database. Choose Import. Choose to upload the MySQL dump file or click on or select uploaded file, navigate to the file, and click Use selection. Select the encoding. Click on Import. Using phpMyAdmin To import a database through phpMyAdmin, please follow the steps: Log into phpMyAdmin. Check the Importing a database using phpMyAdmin article. Export a MySQL dump from a database Here are the three easiest ways to export the SQL dump/schema file of a database: via the MySQL databases section of the hosting Control Panel through phpMyAdmin via the Backup section of the hosting Control Panel Exporting a database via the MySQL Databases section of the hosting Control Panel If you wish to export your database via the MySQL Databases section of the hosting Control Panel, follow these steps: Select the MySQL version from the menu at the top. Click on the Gear icon next to the database. Click on the Export button. Your backup archive will show up in the /private directory once completed. You can check the status of the export operation in the Activity Logs section, reachable by the button in the upper-right. Exporting a database through phpMyAdmin You can find step-by-step instructions on how to export a database through phpMyAdmin in our Exporting a database using phpMyAdmin article. Exporting a database via the Backup section of the hosting Control Panel You can use the Backup section of the hosting Control Panel to create a backup of all your MySQL databases. Detailed information on using the Backup section is available in our Backup article. Delete a database To delete a database, please follow these steps: Select the MySQL version from the menu at the top. Click on the Gear icon next to the database. Click on the Delete button. MySQL users The MySQL Users section shows a list of your MySQL users and the databases they are associated with. It also allows you to apply the following changes: Add a MySQL user To create a MySQL user, please follow these steps: Select the MySQL version from the menu on the top. Scroll down to MySQL users, and click on Create new MySQL User. Enter the username. Enter the password in the Password and Confirm Password fields. As you type your new password, a strength indicator below the field updates in real time. It shows one of four strength levels. You’ll also see tips and requirements in a red tooltip just below the indicator to help you create a stronger password. You can check the article on Choosing a password or the one on using the Random password generator for more details on setting up a good password. Change the password for a MySQL user To change the password of a MySQL user, please follow these steps: Select the MySQL version from the menu on the top. Scroll down to MySQL users. Click on the Gear icon next to the user. Click on Change Password. As you type your new password, a strength indicator below the field updates in real time. It shows one of four strength levels. You’ll also see tips and requirements in a red tooltip just below the indicator to help you create a stronger password. You can check the article on Choosing a password or the one on using the Random password generator for more details on setting up a good password. Enable remote connections for a MySQL user By default, all created MySQL users are allowed to access the MySQL server locally through a script that runs on the server. In case you need to access your database using an application installed on your computer (e.g. NaviCat, MySQL Front, MySQL Control Center, or Query Browser), you need to allow remote connections for the respective MySQL user. On our servers, remote access is enabled per MySQL user, so when you enable remote connections for a MySQL user, this MySQL user will be able to connect remotely to all databases it is associated with. To enable remote connections for a MySQL user, follow these steps: Select the MySQL version from the menu on the top. Scroll down to MySQL Users. Use the toggle next to the user in the Remote Connections column. The MySQL connection details are listed in the MySQL Connection Settings table. Note: If you are using views in your MySQL databases, enabling/disabling remote connections for your master MySQL user may lead to problems with them, due to the change of the type of access. Therefore, in case you have MySQL views in any of your databases, it is strongly recommended that you use a separate MySQL user for remote connections. Delete a MySQL user To delete a MySQL user, please follow these steps: Select the MySQL version from the menu on the top. Scroll down to MySQL users. Click on the Gear icon next to the user. Click on Delete. Privileges Here, you can control what priviliges are assigned to your MySQL users. Grant database privileges to a MySQL user To allow a MySQL user access to a database, please follow these steps: Select the MySQL version from the menu at the top. Click on the Gear icon next to the database. Choose Privileges. The database name will be filled by default. Select the username in the MySQL User field. Choose the privileges you wish to grant, or click on Select All. Click Save. Database Converter The Database converter tab on the MySQL Databases page of the hosting Control Panel allows you to convert your existing MySQL 5 databases to MySQL 8. The converter automatically takes care of creating the same MySQL 8 database, usernames, and assigned privileges, making it easy to upgrade your applications to use MySQL 8. Convert a MySQL 5 database to MySQL 8 To convert a MySQL 5 database to MySQL 8, please follow the steps: Choose Database Converter from the menu at the top. Select the database to convert through Source database name (MySQL 5). In the MySQL tab, select Synchronize password next to your database user. Click on Convert. You can use the Search button in the Database name search tab to find configuration files containing your database. This will help you to easily update them with the new details.