I've just installed Joomla! 3.3 but sometimes, when I want to change a parameter, it shows the next error:
1044 Access denied for user ''@'localhost' to database '*' SQL=LOCK TABLES
How can I solve this?
Joomla Stack Exchange is a question and answer site for Joomla! administrators, users, developers and designers. It only takes a minute to sign up.Sign up to join this community
I had the same issue, turned out to be incorrect user privileges in the MySQL database.
You can manage your database users via your web hosting account, cpanel, or phpmyadmin etc.
Manage your database, select user, grant all privileges.
Wiki docs are here
Hope this helps.
First of all, check if the user you are using has the necessary permissions.
To quote the MySQL manual:
You must have the LOCK TABLES privilege, and the SELECT privilege for each object to be locked.
If you have access to a MySQL console, you can check it with:
SHOW GRANTS; SHOW GRANTS FOR CURRENT_USER; SHOW GRANTS FOR CURRENT_USER();
Or you can query the
mysql.user and check for the column