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

Default MySQL privileges

Discussion in 'Plesk for Linux - 8.x and Older' started by DoobyWho, Sep 2, 2005.

  1. DoobyWho

    DoobyWho Guest

    0
     
    I have to manually run

    update user set Create_tmp_table_priv = 'N', Lock_tables_priv = 'N' WHERE user = USERNAMEHERE;

    for each new mysql user created in Plesk. Is there a way to set the default mysql user priv?

    I don't want my users to be able to see other databases than their own.
     
  2. hardweb

    hardweb Guest

    0
     
    Did you upgrade to Mysql 4.0.x and you didn't fix the privilege tables?
     
  3. DoobyWho

    DoobyWho Guest

    0
     
    No - I ran the script. However - the privileges are still set so that they can view others databases upon creation.
     
  4. LiquidSolid

    LiquidSolid Guest

    0
     
    Hi guys,

    What is that what I read about fixing the privilege tables?

    Not to long ago I started with Plesk 7.5.3 and I didn't fix these tables. Could you let me know what the fix is and where to apply it? I gather that the fix solves the issue with clients looking at tables which doesn't belong to them?

    I'm using mysql 4.1.11 and PSA 7.5.4

    Thanks!
     
  5. DoobyWho

    DoobyWho Guest

    0
     
  6. LiquidSolid

    LiquidSolid Guest

    0
     
    Thanks!

    I just ran the script and it seems that everything was already fixed.
     
Loading...