{"id":267,"date":"2011-03-09T01:55:27","date_gmt":"2011-03-09T01:55:27","guid":{"rendered":"http:\/\/support.cybersecure.com\/?p=267"},"modified":"2011-03-21T06:01:27","modified_gmt":"2011-03-21T06:01:27","slug":"mysqldump-got-error-1044-access-denied-for-user-xxxx","status":"publish","type":"post","link":"http:\/\/support.cybersecure.com\/?p=267","title":{"rendered":"mysqldump: Got error: 1044: Access denied for user XXXX"},"content":{"rendered":"<h2>Error:<\/h2>\n<p><span style=\"color: #ff0000;\">mysqldump: Got error: 1044: Access denied for user &#8216;mysqlusername&#8217;@&#8217;%&#8217; to database &#8216;mysql&#8217; when using LOCK TABLES<\/span><\/p>\n<h2>Cause:<\/h2>\n<p>The CyberSecure Advanced software agent calls MySQL\u2019s mysqldump program to take backups.<\/p>\n<p>The message above suggests that the mysql user &#8220;mysqlusername&#8221; does not have sufficient rights to take the backup using LOCK TABLES.<\/p>\n<h2>Resolution:<\/h2>\n<p>Grant Lock privileges to the user for the databases in concern.<\/p>\n<p>Also go through following URLs which shows how to grant LOCK TABLE privileges to the user for the database in concern.<\/p>\n<p><a href=\"http:\/\/forums.mysql.com\/read.php?10,108835,192963#msg-192963\">http:\/\/forums.mysql.com\/read.php?10,108835,192963#msg-192963<\/a><\/p>\n<p><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/access-denied.html\">http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/access-denied.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error: mysqldump: Got error: 1044: Access denied for user &#8216;mysqlusername&#8217;@&#8217;%&#8217; to database &#8216;mysql&#8217; when using LOCK TABLES Cause: The CyberSecure Advanced software agent calls MySQL\u2019s mysqldump program to take backups. The message above suggests that the mysql user &#8220;mysqlusername&#8221; does &hellip; <a href=\"http:\/\/support.cybersecure.com\/?p=267\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[42],"tags":[],"_links":{"self":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/267"}],"collection":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=267"}],"version-history":[{"count":5,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/267\/revisions"}],"predecessor-version":[{"id":389,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/267\/revisions\/389"}],"wp:attachment":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=267"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}