Koozali.org: home of the SME Server

Obsolete Releases => SME Server 8.x => Topic started by: LANMonkey on December 11, 2014, 11:17:54 PM

Title: [SOLVED] error 1044: Access denied for ... root ... when using LOCK TABLES
Post by: LANMonkey on December 11, 2014, 11:17:54 PM: 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?
Title: Re: error 1044: Access denied for ... root ... when using LOCK TABLES
Post by: Stefano on December 12, 2014, 09:04:56 AM: did you change root's password in mysql?

in any case, bugzilla is right there, use it, thank you
Title: Re: error 1044: Access denied for ... root ... when using LOCK TABLES
Post by: guest22 on December 12, 2014, 09:14:16 AM: Quote from: LANMonkey on December 11, 2014, 11:17:54 PM
<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.
Title: Re: error 1044: Access denied for ... root ... when using LOCK TABLES
Post by: LANMonkey on December 12, 2014, 06:32:09 PM: I've confronted this problem before here:

http://forums.contribs.org/index.php/topic,50081.msg254138.html#msg254138
Title: Re: [SOLVED] error 1044: Access denied for ... root ... when using LOCK TABLES
Post by: guest22 on December 12, 2014, 06:34:23 PM: Still, nothing in bugzilla...
Title: Re: [SOLVED] error 1044: Access denied for ... root ... when using LOCK TABLES
Post by: LANMonkey on December 12, 2014, 06:38:45 PM: 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.