This is solution to whom need to add privileges “Lock Table” that needed by Joomla 3.x where the database server was shared by multiple users.
- logon to the terminal using ‘root‘ account.
- access ‘mysql‘ database
- set column db.Lock_tables_priv = ‘Y‘
this will give different result compare to set column user.Lock_tables_priv = ‘Y’ as this is global privileges.
tested on mysql 5.4.