{"id":3116,"date":"2023-08-10T18:00:26","date_gmt":"2023-08-10T09:00:26","guid":{"rendered":"https:\/\/www.cr-l.jp\/biz\/?p=3116"},"modified":"2024-06-04T15:09:46","modified_gmt":"2024-06-04T06:09:46","slug":"mysqldump-couldnt-execute-flush-tables-with-read-lock-access-denied-for-user-admin-using-password-yes-1045","status":"publish","type":"post","link":"https:\/\/www.cr-l.jp\/biz\/?p=3116","title":{"rendered":"mysqldump: Couldn’t execute ‘FLUSH TABLES WITH READ LOCK’: Access denied for user ‘admin’@’%’ (using password: YES) (1045)"},"content":{"rendered":"
\n\"\"\n<\/div><\/div><\/div><\/div>
<\/svg><\/div>

\nDB\u3092\u30aa\u30f3\u30d7\u30ec\u306b\u623b\u3059!AWS RDS(mariadb) \u304b\u3089 \u30c0\u30f3\u30d7\u3092\u53d6\u308b\u305e\u3002
\n<\/code><\/p>\n
\r\nmysqldump -u admin -p -h xxxxxxxxxx.ap-northeast-1.rds.amazonaws.com -x xxxxxdatabase  > dump.sql \r\n<\/code><\/pre>\n
<\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n
<\/svg><\/div>
mysqldump: Couldn’t execute ‘FLUSH TABLES WITH READ LOCK’: Access denied for user ‘admin’@’%’ (using password: YES) (1045)
<\/div><\/div><\/div><\/div><\/div>
\n<\/svg>\n<\/div><\/div>
\n\"\"\n<\/div><\/div><\/div><\/div><\/div><\/div>\n
\n<\/svg>\n<\/div><\/div>
\n\"\"\n<\/div><\/div><\/div><\/div>
<\/svg><\/div>

\n\u3042\u308c?
\n<\/p>\n

$mysqldump --version
<\/code><\/pre>\n
<\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n
<\/svg><\/div>
mysqldump Ver 10.14 Distrib 5.5.68-MariaDB, for Linux (x86_64)<\/div><\/div><\/div><\/div><\/div>
\n\"\"\n<\/div><\/div><\/div><\/div><\/div><\/div>\n
\n\"\"\n<\/div><\/div><\/div><\/div>
<\/svg><\/div>
\u30d0\u30fc\u30b8\u30e7\u30f3\u554f\u984c\u306a\u3055\u305d\u3046\u3002\u30ed\u30c3\u30af\u3067\u304d\u306a\u3044\u306e\u304b\u306a?\u3000\u691c\u7d22\u691c\u7d22
\nAmazon RDS for MariaDB \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3000\u30b3\u30d4\u30fc<\/a><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n
<\/svg><\/div>

\n\u6b21\u306e\u4f8b\u3067\u306f\u3001\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3067 mysqldump \u3092\u5b9f\u884c\u3057\u3001\u30c0\u30f3\u30d7\u3092\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u8fbc\u307f\u307e\u3059\u3002
\nLinux\u3001macOS\u3001Unix \u306e\u5834\u5408:<\/p>\n
\r\nmysqldump -h source_MySQL_DB_instance_endpoint \\\r\n    -u user \\\r\n    -p password \\\r\n    --port=3306 \\\r\n    --single-transaction \\\r\n    --routines \\\r\n    --triggers \\\r\n    --databases  database database2 > path\/rds-dump.sql\r\n<\/code><\/pre>\n
<\/div><\/div><\/div><\/div><\/div>
\n\"\"\n<\/div><\/div><\/div><\/div><\/div><\/div>\n
\n<\/svg>\n<\/div><\/div>
\n\"\"\n<\/div><\/div><\/div><\/div>
<\/svg><\/div>
\u3053\u308c\u3060\u3002–single-transaction \u3086\u3048\u306b\u3000-x (–lock-all-tables) \u306fNG\u306d\u3002\u7d20\u76f4\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u306b\u5f93\u3046\u3068\u3002<\/p>\n

mysqldump -h xxxxxxxxxx.ap-northeast-1.rds.amazonaws.com \\
    -u admin \\
    -p \\
    --port=3306 \\
    --single-transaction \\
    --routines \\
    --triggers \\
    --databases xxxxxdatabase > dump.sql
<\/code><\/pre>\n
<\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n
\n<\/svg>\n<\/div><\/div>
\n\"\"\n<\/div><\/div><\/div><\/div>
<\/svg><\/div>

\n\u901a\u3063\u305f!<\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":1135,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,81],"tags":[20],"class_list":["post-3116","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-philosophy","category-blog","tag-20"],"_links":{"self":[{"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=\/wp\/v2\/posts\/3116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3116"}],"version-history":[{"count":2,"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=\/wp\/v2\/posts\/3116\/revisions"}],"predecessor-version":[{"id":3118,"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=\/wp\/v2\/posts\/3116\/revisions\/3118"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=\/wp\/v2\/media\/1135"}],"wp:attachment":[{"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cr-l.jp\/biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}