How to manage multiple databases with the same user via phpMyAdmin in Plesk?

Note: In phpMyAdmin is not possible to access all databases via Plesk Interface even though the user has permissions to access to all databases. To have access to all databases, it is required to log into phpMyAdmin manually.

1. Log in to Plesk GUI

2. Go to Domains > example.com > Databases > User Management and click Add Database User.

3. Create a user with access to Any database:

   

4. Configure access to phpMyAdmin without login to Plesk as described in the following article:

   How to access phpMyAdmin shipped in Plesk without login to Plesk URL itself?

5. Browse to https://<Plesk-server-host-name-or-IP>:8443/phpmyadmin and access using the user created on step 3:

   

1. Log in to Plesk GUI

2. Go to Domains > example.com > Databases > User Management and click Add Database User.

3. Create a user with access to Any database:

   

4. Via Domains > example.com > Databases > Add Database create a sample empty_database without a user:

   

5. Click myLittleAdmin button near the database created on step 4: