1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Lock_Tables_Priv enable Lock Tables in MySQL

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

  1. dstanley

    dstanley Guest

    0
     
    Does anyone know how to enable this?
     
  2. hardweb

    hardweb Guest

    0
     
    What version of Mysql do you have and where do you get this?
     
  3. dstanley

    dstanley Guest

    0
     
    I'm running 4.0 at the moment.

    the CMS requires database access to lock the tables it depends on. This is used to guarantee the integrity of the data, especially various counters used.

    So i just need to know how to grant this access.
     
  4. hardweb

    hardweb Guest

    0
     
    You must manually alter the user preferences in the user table in mysql database. You can do this only on shell, you basicaly have to give a query like:

    UPDATE user set Lock_tables_priv='Y' where User='your_username';

    then:

    Flush privileges;
     
Loading...