1. Please take a little time for this simple survey! Thank you for participating!
    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...