Topic: [SOLVED] error 1044: Access denied for ... root ... when using LOCK TABLES

[LANMonkey]

I have two symptoms that I suspect are related to mysql.

First, when I try to do a backup, I am getting the following error in the Messages log:

<Date, host> esmith::event[3611]: mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES

And also, I can't find my filters in webmail.  The connection here is just something I think I heard.

I don't see anything in the bugs or posted elsewhere.  Anyone have any idea what is going on?

[Stefano]

did you change root's password in mysql?

in any case, bugzilla is right there, use it, thank you

[guest22]

<Date, host> esmith::event[3611]: mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES

Google on "'information_schema' when using LOCK TABLES" and it will give you an idea on what to log into bugzilla.

[LANMonkey]

I've confronted this problem before here:

http://forums.contribs.org/index.php/topic,50081.msg254138.html#msg254138

[guest22]

Still, nothing in bugzilla...

[LANMonkey]

The thread where this fix exists concerns installing a more advanced version of MySQL then is shipped with SME 8.  My version of MySQL is 5.5.33.  I don't think it qualifies as a bug.  I have already requested that SME start using a more advanced version of MySQL.