Lock_Tables_Priv enable Lock Tables in MySQL

[dstanley]

Does anyone know how to enable this?

 

[hardweb]

What version of Mysql do you have and where do you get this?

 

[dstanley]

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.

 

[hardweb]

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;