• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

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