1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

New DB users lack SHOW DATABASES privilege

Discussion in 'Plesk for Linux - 8.x and Older' started by jujuthing, Mar 17, 2005.

  1. jujuthing

    jujuthing Guest

    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?