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:

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

  1. Select the MySQL5 and MySQL8 tab based on the MySQL version of the database.
  2. In the top-right corner of the Databases section, click on Create new database.
  3. 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.
  4. 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.
  5. 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).
  6. 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.
  7. 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 Log into MySQL 5/8 link in the phpMyAdmin section 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:

  1. Select the MySQL 5 or MySQL 8 tab based on the MySQL version of your database.
  2. Click on the Gear icon next to the database.
  3. Choose Import.
  4. Choose to upload the MySQL dump file, or click on or select uploaded file to select a file from your account.
  5. Select the encoding for the database from the Encoding drop-down menu.
  6. Click on Import.

Using phpMyAdmin

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

  1. Log into phpMyAdmin.
  2. 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:

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:

  1. Select the MySQL 5 or MySQL 8 tab based on the MySQL version of your database.
  2. Click on the Gear icon next to the database.
  3. Click on the Export button.
  4. 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 Activity Logs button in the upper-right corner of the hosting Control Panel.

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:

  1. Select the MySQL 5 or MySQL 8 tab based on the MySQL version of your database.
  2. Click on the Gear icon next to the database.
  3. 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:

  1. Select the MySQL 5 or MySQL 8 tab based on the MySQL version of your database.
  2. Scroll down to MySQL users, and click on Create new MySQL User.
  3. Enter the username.
  4. 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.
  5. If you plan to use this username to access databases remotely (from third-party servers or applications), enable remote connections for the user.
  6. You can select a database that the MySQL user will be associated with via the Database name field.

Change the password for a MySQL user

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

  1. Select the MySQL 5 or MySQL 8 tab based on the MySQL version of your database.
  2. Scroll down to MySQL users.
  3. Click on the Gear icon next to the user.
  4. 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. 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:

  1. Select the MySQL 5 or MySQL 8 tab based on the MySQL version of your database.
  2. Scroll down to MySQL Users.
  3. Use the toggle switch 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:

  1. Select the MySQL 5 or MySQL 8 tab based on the MySQL version of your database.
  2. Scroll down to MySQL users.
  3. Click on the Gear icon next to the user.
  4. Click on Delete.

Privileges

Here, you can control what privileges 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:

  1. Select the MySQL 5 or MySQL 8 tab based on the MySQL version of your database.
  2. Click on the Gear icon next to the database.
  3. Choose Privileges.
  4. The database name will be filled by default.
  5. Select the username in the MySQL User field.
  6. Choose the privileges you wish to grant/revoke, or click on Select All.
  7. 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:

  1. Select the Database Converter tab.
  2. Select the database to convert through Source database name (MySQL 5).
  3. In the MySQL tab, select Synchronize password next to your database user.
  4. 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.