• We value your experience with Plesk during 2025
    Plesk strives to perform even better in 2026. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2025.
    Please take this short survey:

    https://survey.webpros.com/

New DB users lack SHOW DATABASES privilege

J

jujuthing

Guest
Hi,
Whenever I add a new DB user via the plesk panel, the new user does not have the required privelege to show databases.
I have to login to the server and manually fix the problem:
mysql> use mysql;
mysql> update user set Show_db_priv = 'Y' where user like 'bla%';
mysql> alter table user modify Show_db_priv enum('N','Y') default 'Y';
mysql> flush privileges;
mysql> exit;
Is there any way i can fix this so that the new user automatically has the required show database privelege?
cheers,
simon
 
Back
Top