{"id":368,"date":"2022-07-05T11:13:08","date_gmt":"2022-07-05T03:13:08","guid":{"rendered":"https:\/\/www.anger.ltd\/?p=368"},"modified":"2022-07-05T11:13:08","modified_gmt":"2022-07-05T03:13:08","slug":"mysql-login-path-%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/www.anger.ltd\/index.php\/2022\/07\/05\/mysql-login-path-%e9%85%8d%e7%bd%ae\/","title":{"rendered":"MySQL login-path \u914d\u7f6e"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">\u4ec0\u4e48\u662flogin-path<\/h4>\n\n\n\n<p>login-path\u662fMySQL5.6\u5f00\u59cb\u652f\u6301\u7684\u65b0\u7279\u6027\u3002\u901a\u8fc7\u501f\u52a9mysql_config_editor\u5de5\u5177\u5c06\u767b\u9646MySQL\u670d\u52a1\u7684\u8ba4\u8bc1\u4fe1\u606f\u52a0\u5bc6\u4fdd\u5b58\u5728.mylogin.cnf\u6587\u4ef6\uff08\u9ed8\u8ba4\u4f4d\u4e8e\u7528\u6237\u4e3b\u76ee\u5f55\uff09 \u3002\u4e4b\u540e\uff0cMySQL\u5ba2\u6237\u7aef\u5de5\u5177\u53ef\u901a\u8fc7\u8bfb\u53d6\u8be5\u52a0\u5bc6\u6587\u4ef6\u8fde\u63a5MySQL\uff0c\u907f\u514d\u91cd\u590d\u8f93\u5165\u767b\u5f55\u4fe1\u606f\uff0c\u907f\u514d\u654f\u611f\u4fe1\u606f\u66b4\u9732\u3002<\/p>\n\n\n\n<p>mysql \u7684 client \u5de5\u5177\u90fd\u80fd\u4f7f\u7528 login-path\uff0c\u5982 mysql\u3001mysqldump\u3001mysqladmin\u3001mysqlbinlog\u3001mysql_upgrade\u3001mysqld_safe\u3001mysqld_multi\u3001mysqldumpslow \u7b49\u90fd\u53ef\u4ee5\u4f7f\u7528\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u914d\u7f6e login-path<\/h4>\n\n\n\n<p>mysql_config_editor\u4f7f\u7528\u5e2e\u52a9\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql_config_editor set --help<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"842\" height=\"253\" src=\"https:\/\/www.anger.ltd\/wp-content\/uploads\/2022\/07\/image.png\" alt=\"\" class=\"wp-image-369\" srcset=\"https:\/\/www.anger.ltd\/wp-content\/uploads\/2022\/07\/image.png 842w, https:\/\/www.anger.ltd\/wp-content\/uploads\/2022\/07\/image-300x90.png 300w, https:\/\/www.anger.ltd\/wp-content\/uploads\/2022\/07\/image-768x231.png 768w\" sizes=\"auto, (max-width: 842px) 100vw, 842px\" \/><figcaption>\u914d\u7f6e\u65b9\u5f0f\uff1a<\/figcaption><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql_config_editor set --login-path=lpname --user=rootuser  --host=127.0.0.1 --port=3306 --password<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>-h,\u2013host=name \u6dfb\u52a0host\u5230\u767b\u9646\u6587\u4ef6\u4e2d<\/li><li>-G,\u2013login-path=name \u5728\u767b\u5f55\u6587\u4ef6\u4e2d\u4e3alogin path\u6dfb\u52a0\u540d\u5b57\uff08\u9ed8\u8ba4\u4e3aclient\uff09<\/li><li>-p,\u2013password \u5728\u767b\u9646\u6587\u4ef6\u4e2d\u6dfb\u52a0\u5bc6\u7801\uff08\u8be5\u5bc6\u7801\u4f1a\u88abmysql_config_editor\u81ea\u52a8\u52a0\u5bc6\uff09<\/li><li>-u,\u2013user \u6dfb\u52a0\u7528\u6237\u540d\u5230\u767b\u9646\u6587\u4ef6\u4e2d<\/li><li>-S,\u2013socket=name \u6dfb\u52a0sock\u6587\u4ef6\u8def\u5f84\u5230\u767b\u9646\u6587\u4ef6\u4e2d<\/li><li>-P,\u2013port=name \u6dfb\u52a0\u767b\u9646\u7aef\u53e3\u5230\u767b\u9646\u6587\u4ef6\u4e2d<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u663e\u793a\u914d\u7f6e<\/h4>\n\n\n\n<p>\u663e\u793a\u6267\u884c\u7684login-path\u914d\u7f6e<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql_config_editor print --login-path=lpname<\/code><\/pre>\n\n\n\n<p>\u663e\u793a\u6240\u6709\u7684login-path\u4fe1\u606f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql_config_editor print --all<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u5220\u9664\u914d\u7f6e<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql_config_editor remove --login-path=lpname<\/code><\/pre>\n\n\n\n<p>\u53ef\u5220\u9664\u9879<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>-h,\u2013host=name \u6dfb\u52a0host\u5230\u767b\u9646\u6587\u4ef6\u4e2d<\/li><li>-G,\u2013login-path=name \u5728\u767b\u5f55\u6587\u4ef6\u4e2d\u4e3alogin path\u6dfb\u52a0\u540d\u5b57\uff08\u9ed8\u8ba4\u4e3aclient\uff09<\/li><li>-p,\u2013password \u5728\u767b\u9646\u6587\u4ef6\u4e2d\u6dfb\u52a0\u5bc6\u7801\uff08\u8be5\u5bc6\u7801\u4f1a\u88abmysql_config_editor\u81ea\u52a8\u52a0\u5bc6\uff09<\/li><li>-u,\u2013user \u6dfb\u52a0\u7528\u6237\u540d\u5230\u767b\u9646\u6587\u4ef6\u4e2d<\/li><li>-S,\u2013socket=name \u6dfb\u52a0sock\u6587\u4ef6\u8def\u5f84\u5230\u767b\u9646\u6587\u4ef6\u4e2d<\/li><li>-P,\u2013port=name \u6dfb\u52a0\u767b\u9646\u7aef\u53e3\u5230\u767b\u9646\u6587\u4ef6\u4e2d<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u91cd\u7f6e\u914d\u7f6e<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql_config_editor reset --login-path=lpname<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u4f7f\u7528login-path\u767b\u5f55<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql --login-path=lpname<\/code><\/pre>\n\n\n\n<p>\u82e5\u8981\u767b\u5f55\u5176\u4ed6\u4e3b\u673a\u3001\u5176\u4ed6\u7aef\u53e3\uff0c\u6216\u8005\u6dfb\u52a0\u5176\u4ed6\u989d\u5916\u53c2\u6570\uff0c\u76f4\u63a5\u5728\u4e0a\u8ff0\u547d\u4ee4\u540e\u6dfb\u52a0\u5373\u53ef<\/p>\n\n\n\n<p>\u767b\u5f55host1:poet1\u4e0a\u7684MySQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql --login-path=lpname  -h host1 -P port1<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"262\u767b\u5f55host1poet1\u4e0a\u7684mysql\u4e2d\u7684test_db\u5e93\">\u767b\u5f55host1:poet1\u4e0a\u7684MySQL\u4e2d\u7684test_db\u5e93<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql --login-path=lpname  -h host1 -P port1 test_db<\/code><\/pre>\n\n\n\n<p>\u5b98\u65b9\u53c2\u8003\u6587\u6863\uff1a<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/mysql-config-editor.html\">\u94fe\u63a5<\/a>  \u539f\u6587\u94fe\u63a5\uff1a<a href=\"https:\/\/www.cnblogs.com\/David-domain\/p\/11176474.html\">\u94fe\u63a5<\/a> \u6ce8\uff1a\u672c\u6587\u4e3a\u8f6c\u8f7d\u6587\u6863\uff0c\u5982\u6709\u4fb5\u6743\u8bf7\u8054\u7cfb\u6211\u5220\u9664<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ec0\u4e48\u662flogin-path login-path\u662fMySQL5.6\u5f00\u59cb\u652f\u6301\u7684\u65b0\u7279\u6027\u3002\u901a\u8fc7\u501f\u52a9mysql_config_editor\u5de5\u5177\u5c06\u767b\u9646MySQL\u670d\u52a1\u7684\u8ba4\u8bc1\u4fe1\u606f\u52a0\u5bc6\u4fdd\u5b58\u5728.mylogin.cnf\u6587\u4ef6\uff08\u9ed8\u8ba4\u4f4d &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-368","post","type-post","status-publish","format-standard","hentry","category-3"],"_links":{"self":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts\/368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/comments?post=368"}],"version-history":[{"count":3,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts\/368\/revisions"}],"predecessor-version":[{"id":372,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts\/368\/revisions\/372"}],"wp:attachment":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/media?parent=368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/categories?post=368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/tags?post=368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}