Applicable to:
- Plesk 12.5 for Linux
- Plesk 12.5 for Windows
- Plesk Onyx for Linux
- Plesk Onyx for Windows
Question
How to manage multiple databases with a single user via phpMyAdmin or MyLittleAdmin in Plesk?
Answer
Click on a section to expand
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.
-
Go to Domains > example.com > Databases > User Management and click Add Database User.
-
Create a user with access to Any database:
-
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?
-
Browse to
https://<Plesk-server-host-name-or-IP>:8443/phpmyadmin
and access using the user created on step 3:
-
Go to Domains > example.com > Databases > User Management and click Add Database User.
-
Create a user with access to Any database:
-
Via Domains > example.com > Databases > Add Database create a sample empty_database without a user:
-
Click myLittleAdmin button near the database created on step 4:
Comments
0 comments
Please sign in to leave a comment.