Symptoms
- Plesk Obsidian running on a Linux-based operating system
- Several database users are created and they are correctly configured to have access to all databases for the domain
For one specific database user, only one specific database is opened each time when accessing any of the different databases he has permissions to access via Plesk > Domains > example.com > Databases > press on phpMyAdmin for any of the databases
Cause
The config_data column of the pma__userconfig table within the database named phpmyadmin for the affected user contains "Server/hide_db" and "Server/only_db":"db_name" among other configurations, which are responsible for this behavior:
MariaDB [phpmyadmin]> select * from pma__userconfig where username="admin";
+----------+---------------------+-----------------------------------------------------------+
| username | timevalue | config_data |
+----------+---------------------+-----------------------------------------------------------+
| admin | 2023-10-20 12:22:56 | {…,"Server/hide_db":"","Server/only_db":"wp_example",…} |
+----------+---------------------+-----------------------------------------------------------+Resolution
In order to resolve the issue, you would need to update the config_data for the affected database user within the phpmyadmin database by following these steps:
1. Log into the server via SSH as the root user
2. Make a database backup for the phpmyadmin database:
# plesk db dump phpmyadmin > /root/plesk_phpmyadmin_dump.sql
3. Enter MariaDB:
# plesk db
4. Switch to the phpmyadmin database:
use phpmyadmin;
5. Check the current config_data for the selected database user name (admin in the example below) by executing the following command:
select * from pma__userconfig where username="admin";
The output would be similar to the following:
+----------+---------------------+-----------------------------------------------------------+
| username | timevalue | config_data |
+----------+---------------------+-----------------------------------------------------------+
| admin | 2023-10-20 12:22:56 | {…,"Server/hide_db":"","Server/only_db":"wp_example",…} |
+----------+---------------------+-----------------------------------------------------------+6. Remove the Server/hide_db" and "Server/only_db":"db_name from theconfig_data options for the affected user and leave all others by using a command that is similar to the following:
update pma__userconfig set config_data='"Console/Mode":"collapse"' where username='admin';
7. Exit MariaDB
exit
