MySQL

Each virtual machine has its own MySQL server.

During the server activation process you will assign a password for the MySQL account with full privileges. This password is not sent by email.

If you have chosen not to install the phpMyAdmin application, you can only manage the databases and their users through the console (terminal). Otherwise, this application can be used to manage the databases and their users.

phpMyAdmin

This is an application external to the Control Panel, which allows the administration of databases and MySQL users from a graphic interface.

For security reasons, this application is protected with a double password. Only users with phpMyAdmin enabled will be able to access it.

You can enable this access when creating new users or by editing the profile of existing users by checking the box ‘Enable phpMyAdmin’.

Enabling account for phpMyAdmin.

First password

When the phpMyAdmin application is accessed, the first authentication is displayed with a pop-up window. In this first form you have to insert the user credentials and password of a user who has phpMyAdmin enabled (Warning: this is not the credentials of a MySQL account with database access).

Request for account credentials enabled for phpMyAdmin.

Second password

Once the first authentication is successful, the phpMyAdmin application interface is displayed, which will request a MySQL account. By default there is a MySQL account whose name is included in the email sent when the server is created and whose password you will have assigned during the server activation process.

Access to phpMyAdmin with MySQL account.

It is good practice to create a different MySQL user for each database, and thus grant permissions on only one and not on all the databases you have created.

Both databases and MySQL users and their passwords can be created and managed from phpMyAdmin.

By default, only the MySQL account that is created with the server activation (whose password has been assigned by you) has the necessary privileges to create new databases, new accounts and grant permissions to each of them.

If you have any doubts or need further assistance, you can look up the official guidelines for the use of phpMyAdmin by following this link.