Creating Plesk and PhpMyAdmin - Giving a user access to a single database

ro:Crearea Plesk și PhpMyAdmin - Acordarea accesului unui utilizator la o singură bază de date ru:Создание Plesk и PhpMyAdmin - Предоставление пользователю доступа к одной базе данных pl:Tworzenie Plesk i PhpMyAdmin - Nadawanie użytkownikowi dostępu do jednej bazy danych ja:PleskとPhpMyAdminの作成 - ユーザーに1つのデータベースへのアクセス権を与える zh:创建Plesk和PhpMyAdmin - 给予用户访问单个数据库的权限 de:Erstellen von Plesk und PhpMyAdmin - Einem Benutzer Zugriff auf eine einzelne Datenbank geben nl:Plesk en PhpMyAdmin maken - Een gebruiker toegang geven tot een enkele database it:Creare Plesk e PhpMyAdmin - Dare accesso a un utente a un singolo database pt:Criar Plesk e PhpMyAdmin - Dar a um utilizador acesso a uma única base de dados es:Creación de Plesk y PhpMyAdmin - Dar acceso a un usuario a una única base de datos fr:Création de Plesk et PhpMyAdmin - Donner l'accès à une seule base de donnée à un utilisateur
This article has been created by an automatic translation software. You can view the article source here.

Introduction

You have several databases on your shared hosting and you wish to give the management of a given database to one of your service providers.
This is possible by manually installing "PhpMyAdmin" in a subdomain created for this purpose.
We invite you to follow this tutorial which will show you step by step how to set this up.

Prerequisites

Create a sub-domain, example "phpmyadmin.DOMAIN.COM". (The "DOMAIN.COM" is your domain name).
Create a user for the database that your provider will have to administer.
You must download "PhpMyAdmin" on the official website.
Here is the url of the site: https://www.phpmyadmin.net/

==Creation of the sub-domain == =

On your management interface Plesk in the "Websites & Domains" section you have a button at the top to add a subdomain.
You will need to fill in the "Subdomain name".

"phpmyadmin" 

In the "Document Root" field, please enter the full subdomain.

"phpmyadmin.domain.com" 

You have the possibility to have a "Let's Encrypt" certificate for the subdomain, for this you have to agree "Secure the domain with Let's Encrypt".
Do not check "Enable Git support".
All you have to do is click on "OK" and your subdomain will be created.

==Creation of the user for the database == =

You have to click on the "Databases" button on the top right, then on "User management" and then on "Add a database user".
You will have to choose a user name, a password and select the database.
Do not check "Use this user's credentials by default to access phpMyAdmin".
450px

==Install PhpMyAdmin on your hosting in the subdomain == =

Go to your subdomain control panel and click on "File Manager".
In "File Manager" the subdomain must be selected and then click on the "Send" button, you will be able to import the compressed folder "PhpMyAdmin".
Once the folder is on your hosting, you must now extract the files by clicking on "Extract files" and check "Replace existing files".
You must move all the files in the "PhpMyAdmin" folder to the root of your subdomain.
Select all the files in the "PhpMyAdmin" folder, click on "Move", then select your subdomain, check "Replace existing files" and click on "OK".
Now delete the empty "PhpMyAdmin" folder.
Important you must rename your index.html file to index.html.old

=== Access PhpMyAdmin via a web browser == =

If you get a warning message saying "Your connection is not private" this means that you have not installed and/or configured a certificate for the subdomain.
Here is the url to access "PhpMyAdmin" : https://phpmyadmin.domaine.com/phpmyadmin (to be adapted)