mysqldump: Got error: 1044: Access denied for user when using LOCK TABLES

  • Every time I run a back up I get the following error message

    mysqldump: Got error: 1044: Access denied for user ‘wp_3156815451’@’localhost’ to database ‘wordpress_3156815451’ when using LOCK TABLES

    One solution I found was to grant the user the required rights using this code –
    mysql> GRANT SELECT,LOCK TABLES ON information_schema.* TO ‘admin’@’localhost’;

    I’ve never worked with databases before so could someone tell me where I should add this code?

    Thanks.

    https://www.ads-software.com/extend/plugins/backupwordpress/

Viewing 2 replies - 1 through 2 (of 2 total)

  • Maryl,

    It is safe to ignore this error as it will be falling back to using PHP to backup your database. A future version of this plugin will stop this message showing.

    Thread Starter MaryI

    (@maryi)

    Thanks stubbs123, you just saved me some time!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘mysqldump: Got error: 1044: Access denied for user when using LOCK TABLES’ is closed to new replies.