Are you able to get a screenshot of this error? I haven’t seen this before but wonder if it is related to another issue we’re already working on.
Thanks in advance for helping by reporting and hopefully getting us a screenshot!
Kat
Kat,
Thanks for the quick response. I’ve got a screenshot but I don’t see a way to attach it. Here is the full text of the error(s).
Mysqldump: mysqldump: Got error: 1044: “Access denied for user ‘xxxxxxxx_xxxxxxx’@’localhost’ to database ‘yyyyyyyy_yyyyyyyyyyyyy'” when using LOCK TABLES
IMysqldump: Connection to mysql failed with message: SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
I checked and my php version is
PHP Version 5.4.45
Thanks for your help!
Chris
Oh and,
After looking at that mysql error I checked my php version and it’s PHP Version 5.4.45. Then I checked a few of my other sites and found that the plugin has this error on two sites but not on the other five.
My WP is version 4.4.2
I have pretty similar plugins across the sites.
I have several different themes across the sites but the two that show the error have different themes.
Thanks for your help.
🙂
Can you see if upgrading to 3.6 fixes your issue?
Thanks so much!
Kat
Kat,
I tried the 3.6 version but still the same issue.
These errors in the WP backend:
Mysqldump: mysqldump: Got error: 1044: “Access denied for user ‘xxxxxx_ttttttt’@’localhost’ to database ‘eeeeeee_kkkkkkkk'” when using LOCK TABLES
IMysqldump: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user ‘xxxxxx_ttttttt’@’localhost’ to database ‘eeeeeee_kkkkkkkk’
No errors pertaning to this in the error logs.
Thanks
Okay – I’ve been digging on this one a bit over the last couple weeks and it looks like some servers/hosts block use of the commands unless someone is signed in. Why that would suddenly kick in when it should have been an issue before, I don’t know. I am listing this as an issue in Github for tracking and will update you what we found out. 🙁
Kat
I just want to mention one thing that has worked for at least one other user – identifying the table and/or database in question and running a “repair” on that via phpmyadmin.
If you are able to try that, let me know if it helps at all, okay?
Kat
Also – talk with your host and ask about re-installing MySQLDump since that’s the command that is showing the error.
Our plugin uses two different database backup options – MySQLDump and then, if that fails, PDO: mysql
What should happen if you have an error with MySQLdump is that the plugin will fall back to using the PDO: mysql instead.
If trying to fix the error with MySQLDump doesn’t work, talk with your host about installing the PDO:mysql module so the plugin can access that as a backup.
Kat
Kat,
Thanks for working on this 🙂
I went back to my websites that have your plugin installed, tested each by running an on-demand backup and no errors.
Not sure what changed but it’s working correctly now. 🙂
Thanks
Chris
