{"id":1316,"date":"2022-02-22T08:22:49","date_gmt":"2022-02-22T00:22:49","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=1316"},"modified":"2022-02-22T08:43:05","modified_gmt":"2022-02-22T00:43:05","slug":"%e5%9c%a8%e4%b8%80%e5%8f%b0linux%e6%9c%8d%e5%8a%a1%e5%99%a8%e4%b8%8a%e5%ae%89%e8%a3%85%e5%a4%9a%e4%b8%aamariadb%e5%ae%9e%e4%be%8b%ef%bc%88%e4%b8%80%ef%bc%89%e4%bd%bf%e7%94%a8%e5%8d%95%e7%8b%ac","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=1316","title":{"rendered":"\u5728\u4e00\u53f0Linux\u670d\u52a1\u5668\u4e0a\u5b89\u88c5\u591a\u4e2aMariaDB\u5b9e\u4f8b\uff08\u4e00\uff09\u4f7f\u7528\u5355\u72ec\u7684my.cnf\u6587\u4ef6"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<label for=\"ez-toc-cssicon-toggle-item-69def9577c8d8\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69def9577c8d8\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#1_%E7%AE%80%E4%BB%8B\" >1. \u7b80\u4ecb<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#2_%E5%AE%9E%E9%AA%8C%E7%8E%AF%E5%A2%83\" >2. \u5b9e\u9a8c\u73af\u5883<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#3_%E5%AE%9E%E9%AA%8C%E8%BF%87%E7%A8%8B\" >3. \u5b9e\u9a8c\u8fc7\u7a0b<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#31_%E5%AE%89%E8%A3%85MariaDB\" >3.1. \u5b89\u88c5MariaDB<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#32_%E5%88%9B%E5%BB%BA%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6%E5%AD%98%E6%94%BE%E8%B7%AF%E5%BE%84\" >3.2. \u521b\u5efa\u6570\u636e\u6587\u4ef6\u5b58\u653e\u8def\u5f84<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#33_%E5%88%9B%E5%BB%BA_mycnf_%E5%8F%82%E6%95%B0%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6\" >3.3. \u521b\u5efa my.cnf \u53c2\u6570\u914d\u7f6e\u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#34_%E5%88%9D%E5%A7%8B%E5%8C%96%E6%95%B0%E6%8D%AE%E5%BA%93\" >3.4. \u521d\u59cb\u5316\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#35_%E4%BF%AE%E6%94%B9%E6%96%87%E4%BB%B6%E5%B1%9E%E4%B8%BB\" >3.5. \u4fee\u6539\u6587\u4ef6\u5c5e\u4e3b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#36_%E5%90%AF%E5%8A%A8%E6%95%B0%E6%8D%AE%E5%BA%93\" >3.6. \u542f\u52a8\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#37_%E6%A3%80%E6%9F%A5mariadb%E7%9A%84%E6%9C%8D%E5%8A%A1%E7%AB%AF%E5%8F%A3\" >3.7. \u68c0\u67e5mariadb\u7684\u670d\u52a1\u7aef\u53e3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#38_%E6%9C%AC%E5%9C%B0%E7%99%BB%E5%BD%95%E6%95%B0%E6%8D%AE%E5%BA%93\" >3.8. \u672c\u5730\u767b\u5f55\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#39_%E4%BF%AE%E6%94%B9%E6%95%B0%E6%8D%AE%E5%BA%93rootlocalhost%E5%AF%86%E7%A0%81\" >3.9. \u4fee\u6539\u6570\u636e\u5e93root@localhost\u5bc6\u7801<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#39_%E5%81%9C%E6%AD%A2%E6%95%B0%E6%8D%AE%E5%BA%93\" >3.9. \u505c\u6b62\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"http:\/\/dba.qishuo.xin\/?p=1316\/#%E5%8F%82%E8%80%83\" >\u53c2\u8003<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_%E7%AE%80%E4%BB%8B\"><\/span>1. \u7b80\u4ecb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u6709\u4e24\u79cdMySQL\u90e8\u7f72\u591a\u5b9e\u4f8b\u7684\u65b9\u6cd5\uff0c\u5206\u522b\u662f\uff1a<\/p>\n<ol>\n<li>\u4f7f\u7528\u5b98\u65b9\u81ea\u5e26\u7684mysqld_multi\u6765\u914d\u7f6e\u7ba1\u7406\uff0c\u7279\u70b9\u662f\u4f7f\u7528\u540c\u4e00\u4efdMySQL\u914d\u7f6e\u6587\u4ef6\uff0c\u8fd9\u79cd\u65b9\u5f0f\u5c5e\u4e8e\u96c6\u4e2d\u5f0f\u7ba1\u7406\uff0c\u7ba1\u7406\u8d77\u6765\u8f83\u4e3a\u65b9\u4fbf\uff1b<\/li>\n<li>\u4f7f\u7528\u5355\u72ec\u7684 <code>my.cnf<\/code> \u914d\u7f6e\u6587\u4ef6\u6765\u5355\u72ec\u914d\u7f6e\u5b9e\u4f8b\uff0c\u8fd9\u79cd\u65b9\u5f0f\u903b\u8f91\u7b80\u5355\uff0c\u6570\u636e\u5e93\u4e4b\u95f4\u6ca1\u6709\u5173\u8054\u3002<\/li>\n<\/ol>\n<p><strong>\u4e24\u79cd\u65b9\u6cd5\u6700\u5927\u7684\u533a\u522b\u5728\u4e8e\uff1a\u4f7f\u7528mysqld_multi\u65b9\u5f0f\uff0c\u6240\u6709\u7684\u5b9e\u4f8b\u5171\u4f7f\u7528\u4e00\u4e2a\u53c2\u6570\u6587\u4ef6\uff0c\u4f7f\u7528\u7b2c\u4e8c\u79cd\u65b9\u6cd5\uff0c\u5219\u5404\u81ea\u5b9e\u4f8b\u4f7f\u7528\u81ea\u5df1\u7684\u53c2\u6570\u6587\u4ef6\u3002<\/strong><br \/>\n\u4ee5\u4e0b<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_%E5%AE%9E%E9%AA%8C%E7%8E%AF%E5%A2%83\"><\/span>2. \u5b9e\u9a8c\u73af\u5883<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u64cd\u4f5c\u7cfb\u7edf   \uff1aCentOS Linux release 7.8.2003 (Core)<\/p>\n<p>\u6570\u636e\u5e93\u7248\u672c\uff1a10.5.8-MariaDB-log<\/p>\n<p>\u9884\u8ba1\u5212\u5b89\u88c53\u4e2aMySQL\u5b9e\u4f8b\uff0c\u89c4\u5212\u4fe1\u606f\u4e3a\uff1a<\/p>\n<table>\n<thead>\n<tr>\n<th align=\"left\">\u5b9e\u4f8b1<\/th>\n<th align=\"left\">\u5b9e\u4f8b2<\/th>\n<th align=\"left\">\u5b9e\u4f8b3<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td align=\"left\">basedir=\/usr\/local\/mysql <\/br> datadir=\/data\/3306\/data <\/br> port=3306 <\/br> socket=\/data\/3306\/socket\/mysqld.sock <\/br> \u53c2\u6570\u6587\u4ef6\uff1a\/data\/3306\/param\/my.cnf<\/td>\n<td align=\"left\">basedir=\/usr\/local\/mysql <\/br> datadir=\/data\/3307\/data <\/br> port=3307 <\/br> socket=\/data\/3307\/socket\/mysqld.sock <\/br> \u53c2\u6570\u6587\u4ef6\uff1a\/data\/3307\/param\/my.cnf<\/td>\n<td align=\"left\">basedir=\/usr\/local\/mysql <\/br> datadir=\/data\/3308\/data <\/br> port=3308 <\/br> socket=\/data\/3308\/socket\/mysqld.sock <\/br> \u53c2\u6570\u6587\u4ef6\uff1a\/data\/3308\/param\/my.cnf<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span class=\"ez-toc-section\" id=\"3_%E5%AE%9E%E9%AA%8C%E8%BF%87%E7%A8%8B\"><\/span>3. \u5b9e\u9a8c\u8fc7\u7a0b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"31_%E5%AE%89%E8%A3%85MariaDB\"><\/span>3.1. \u5b89\u88c5MariaDB<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\uff08\u7565\uff09\u5b89\u88c5\u8fc7\u7a0b\u53c2\u89c1\uff1a<\/p>\n<h4><span class=\"ez-toc-section\" id=\"32_%E5%88%9B%E5%BB%BA%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6%E5%AD%98%E6%94%BE%E8%B7%AF%E5%BE%84\"><\/span>3.2. \u521b\u5efa\u6570\u636e\u6587\u4ef6\u5b58\u653e\u8def\u5f84<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell line-numbers\">mkdir -p \/data\/3306\/{param,data,log,socket,tmp}\nmkdir -p \/data\/3307\/{param,data,log,socket,tmp}\nmkdir -p \/data\/3308\/{param,data,log,socket,tmp}\n<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"33_%E5%88%9B%E5%BB%BA_mycnf_%E5%8F%82%E6%95%B0%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6\"><\/span>3.3. \u521b\u5efa <code>my.cnf<\/code> \u53c2\u6570\u914d\u7f6e\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5176\u4e2d\uff0c\u5404\u4e2a\u5b9e\u4f8b\u7684\u914d\u7f6e\u6587\u4ef6\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<ul>\n<li>\u5b9e\u4f8b\u4e00\uff1a<\/li>\n<\/ul>\n<pre><code class=\"language-shell line-numbers\">server-id = 174\n# \u8bbe\u7f6e3306\u7aef\u53e3\nport=3306\n# \u8bbe\u7f6emysql\u7684\u5b89\u88c5\u76ee\u5f55\nbasedir=\/usr\/local\/mysql\/\n# \u8bbe\u7f6emysql\u6570\u636e\u5e93\u7684\u6570\u636e\u7684\u5b58\u653e\u76ee\u5f55\ndatadir=\/data\/3306\/data\n# \u5141\u8bb8\u6700\u5927\u8fde\u63a5\u6570\nmax_connections=200\n# \u5141\u8bb8\u8fde\u63a5\u5931\u8d25\u7684\u6b21\u6570\u3002\nmax_connect_errors=10\n# \u670d\u52a1\u7aef\u4f7f\u7528\u7684\u5b57\u7b26\u96c6\u9ed8\u8ba4\u4e3autf8mb4\ncharacter-set-server=utf8mb4\n# \u521b\u5efa\u65b0\u8868\u65f6\u5c06\u4f7f\u7528\u7684\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce\ndefault-storage-engine=INNODB\n# \u9ed8\u8ba4\u4f7f\u7528\u201cmysql_native_password\u201d\u63d2\u4ef6\u8ba4\u8bc1\n#mysql_native_password\ndefault_authentication_plugin=mysql_native_password\n# \u5927\u5c0f\u5199\u662f\u5426\u654f\u611f\nlower_case_table_names=1\ninnodb_buffer_pool_size=128M\nsocket=\/data\/3306\/socket\/mysqld.sock\n# \u9519\u8bef\u65e5\u5fd7\nlog-error = \/data\/3306\/log\/error.log\n[mysql]\n# \u8bbe\u7f6emysql\u5ba2\u6237\u7aef\u9ed8\u8ba4\u5b57\u7b26\u96c6\ndefault-character-set=utf8mb4\n[client]\n# \u8bbe\u7f6emysql\u5ba2\u6237\u7aef\u8fde\u63a5\u670d\u52a1\u7aef\u65f6\u9ed8\u8ba4\u4f7f\u7528\u7684\u7aef\u53e3\nport=3306\n<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"34_%E5%88%9D%E5%A7%8B%E5%8C%96%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>3.4. \u521d\u59cb\u5316\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell line-numbers\">\/usr\/local\/mysql\/scripts\/mariadb-install-db --defaults-file=\/data\/3306\/param\/my.cnf\n\/usr\/local\/mysql\/scripts\/mariadb-install-db --defaults-file=\/data\/3307\/param\/my.cnf\n\/usr\/local\/mysql\/scripts\/mariadb-install-db --defaults-file=\/data\/3308\/param\/my.cnf\n<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"35_%E4%BF%AE%E6%94%B9%E6%96%87%E4%BB%B6%E5%B1%9E%E4%B8%BB\"><\/span>3.5. \u4fee\u6539\u6587\u4ef6\u5c5e\u4e3b<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell line-numbers\">chown -R mysql:mysql \/data\/3306\/\nchown -R mysql:mysql \/data\/3307\/\nchown -R mysql:mysql \/data\/3308\/\n<\/code><\/pre>\n<p><strong><span style='color:red'> \u8fd9\u4e00\u6b65\u5f88\u91cd\u8981\uff0c\u5982\u679c\u6587\u4ef6\u6743\u9650\u4e0d\u6b63\u786e\u4f1a\u9020\u6210mariadb\u670d\u52a1\u65e0\u6cd5\u542f\u52a8\uff01 <\/span><\/strong> \u4f8b\u5982\u51fa\u73b0\u5982\u4e0b\u65e0\u6cd5\u8bbf\u95ee <code>aria_log_control<\/code> \u6587\u4ef6\u7684\u9519\u8bef\uff1a<\/p>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_d9f55a492dcf2aad40b4590e9c61126a.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_d9f55a492dcf2aad40b4590e9c61126a.jpg\" alt=\"\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"36_%E5%90%AF%E5%8A%A8%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>3.6. \u542f\u52a8\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell line-numbers\">nohup \/usr\/local\/mysql\/bin\/mysqld_safe --defaults-file=\/data\/3306\/param\/my.cnf --user=mysql &amp;\nnohup \/usr\/local\/mysql\/bin\/mysqld_safe --defaults-file=\/data\/3307\/param\/my.cnf --user=mysql &amp;\nnohup \/usr\/local\/mysql\/bin\/mysqld_safe --defaults-file=\/data\/3308\/param\/my.cnf --user=mysql &amp;\n<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"37_%E6%A3%80%E6%9F%A5mariadb%E7%9A%84%E6%9C%8D%E5%8A%A1%E7%AB%AF%E5%8F%A3\"><\/span>3.7. \u68c0\u67e5mariadb\u7684\u670d\u52a1\u7aef\u53e3<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell line-numbers\">netstat -anutp | grep -E '3306|3307|3308'\n<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_5c874971d35e15ef6652c6c15b3b2782.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_5c874971d35e15ef6652c6c15b3b2782.jpg\" alt=\"\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"38_%E6%9C%AC%E5%9C%B0%E7%99%BB%E5%BD%95%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>3.8. \u672c\u5730\u767b\u5f55\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u8fde\u63a5\u65b9\u5f0f\u4e00<br \/>\n\u4f7f\u7528\u670d\u52a1\u5668IP\u5730\u5740\uff0cMySQL\u521b\u5efa\u5b8c\u6210\u540e\uff0c\u6570\u636e\u5e93\u8d26\u53f7root@localhost\u53ea\u5141\u8bb8\u672c\u5730\u8fde\u63a5\uff0c\u53c2\u6570\u201c-h\u201d\u540e\u9762\u7528\u670d\u52a1\u5668IP\u88ab\u8ba4\u4e3a\u4e86\u8fdc\u7a0b\u8fde\u63a5\u3002<\/li>\n<\/ul>\n<pre><code class=\"language-shell line-numbers\">mysql -uroot -p -h172.16.5.74 -P3306\n# \u5bc6\u7801\u4e3a\u7a7a\n<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_35d106ce4d4bc7f434d2e3964c96314c.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_35d106ce4d4bc7f434d2e3964c96314c.jpg\" alt=\"\" \/><\/a><\/p>\n<ul>\n<li>\u8fde\u63a5\u65b9\u5f0f\u4e8c<br \/>\n\u4f7f\u7528localhost\u8bbf\u95ee\u6570\u636e\u5e93\uff0c\u65e0\u6cd5\u8fde\u63a5\u3002\u4ece\u62a5\u9519\u4fe1\u606f\u4e2d\u53ef\u4ee5\u770b\u5230\uff0cMySQL\u5b9e\u4f8b\u4f7f\u7528\u7684socket\u6587\u4ef6\u662f\u9ed8\u8ba4\/etc\/my.cnf\u4e2d\u914d\u7f6e\u7684\u6587\u4ef6<\/li>\n<\/ul>\n<pre><code class=\"language-shell line-numbers\">mysql -uroot -p -hlocalhost -P3307\n<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_8a124e4ed2674d536eefaca444fe9fc6.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_8a124e4ed2674d536eefaca444fe9fc6.jpg\" alt=\"\" \/><\/a><\/p>\n<ul>\n<li>\u8fde\u63a5\u65b9\u5f0f\u4e09<br \/>\n\u4f7f\u7528127.0.0.1\u8bbf\u95ee\u6570\u636e\u5e93\uff0c\u65e0\u6cd5\u8fde\u63a5\u3002\u4ece\u62a5\u9519\u7684\u4fe1\u606f\u4e2d\u5f97\u51fa\u662f\u5bc6\u7801\u6ca1\u6709\u521d\u59cb\u5316\u3002\u8bbe\u7f6e\u4e86<code>root@localhost<\/code> \u7684\u5bc6\u7801\u540e\u5373\u53ef\u5b8c\u6210\u767b\u5f55\u3002<\/li>\n<\/ul>\n<pre><code class=\"language-shell line-numbers\">mysql -uroot -p -h127.0.0.1 -P3307\n<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_ad3b0161ea86dd789e0d682470084fbb.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_ad3b0161ea86dd789e0d682470084fbb.jpg\" alt=\"\" \/><\/a><\/p>\n<p>\u89e3\u51b3\u65b9\u6848\uff1a<\/p>\n<pre><code class=\"language-shell line-numbers\">mysql -uroot-sys-maint -p -h127.0.0.1 -P3307\n# \u5bc6\u7801\u4e3a\u7a7a\n<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_e0ca4fe30ef12a368c7a1613ec53ee08.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_e0ca4fe30ef12a368c7a1613ec53ee08.jpg\" alt=\"\" \/><\/a><\/p>\n<p>\u53c2\u8003\uff1ahttps:\/\/cloud.tencent.com\/developer\/article\/1142525<\/p>\n<ul>\n<li>\u8fde\u63a5\u65b9\u5f0f\u56db<br \/>\n\u4f7f\u7528socket\u6587\u4ef6\u8fde\u63a5\uff0c\u53ef\u4ee5\u6b63\u5e38\u8bbf\u95ee\u3002<\/li>\n<\/ul>\n<pre><code class=\"language-shell line-numbers\">mysql -S \/data\/3307\/socket\/mysqld.sock -p\n# \u5bc6\u7801\u4e3a\u7a7a\n<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_addc0285b306b941d1380f2800cc9661.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_addc0285b306b941d1380f2800cc9661.jpg\" alt=\"\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"39_%E4%BF%AE%E6%94%B9%E6%95%B0%E6%8D%AE%E5%BA%93rootlocalhost%E5%AF%86%E7%A0%81\"><\/span>3.9. \u4fee\u6539\u6570\u636e\u5e93root@localhost\u5bc6\u7801<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5982\u679c\u4e0d\u4fee\u6539\u5728\u5173\u95ed\u6570\u636e\u5e93\u5b9e\u4f8b\u65f6\u4f1a\u63d0\u793a\u4e0b\u5217\u9519\u8bef\uff1a<br \/>\n<a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_78fcc5c2e51d7395a33bb17f43517a22.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_78fcc5c2e51d7395a33bb17f43517a22.jpg\" alt=\"\" \/><\/a><\/p>\n<pre><code class=\"language-sql line-numbers\">mysql&gt; alter user root@'localhost' identified by '123456';\nQuery OK, 0 rows affected (0.00 sec)\n\nmysql&gt; flush privileges;\nQuery OK, 0 rows affected (0.00 sec)\n<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"39_%E5%81%9C%E6%AD%A2%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>3.9. \u505c\u6b62\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u4f7f\u7528mysqladmin\u6765\u5173\u95ed\u5b9e\u4f8b<\/p>\n<pre><code class=\"language-shell line-numbers\">mysqladmin -h127.0.0.1 -uroot -p -P3307 shutdown\n# \u8f93\u5165\u4e0a\u4e00\u6b65\u8bbe\u7f6e\u7684\u5bc6\u7801\n<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_e7a1fdfc1847f4f63ed3f194080e629c.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/02\/wp_editor_md_e7a1fdfc1847f4f63ed3f194080e629c.jpg\" alt=\"\" \/><\/a><br \/>\n\u7ecf\u8fc7\u4e00\u6bb5\u65f6\u95f4\u540e\uff0cmariadb\u7684\u670d\u52a1\u88ab\u5173\u95ed\u3002<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%E5%8F%82%E8%80%83\"><\/span>\u53c2\u8003<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u5728\u4e00\u53f0Linux\u670d\u52a1\u5668\u4e0a\u5b89\u88c5\u591a\u4e2aMySQL\u5b9e\u4f8b\uff08\u4e8c\uff09--\u4f7f\u7528\u5355\u72ec\u7684MySQL\u914d\u7f6e\u6587\u4ef6\uff1ahttps:\/\/www.cnblogs.com\/lijiaman\/p\/12588095.html<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>1. \u7b80\u4ecb \u6709\u4e24\u79cdMySQL\u90e8\u7f72\u591a\u5b9e\u4f8b\u7684\u65b9\u6cd5\uff0c\u5206\u522b&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,32],"tags":[12,74],"class_list":["post-1316","post","type-post","status-publish","format-standard","hentry","category-mariadbmysql","category-mariadb","tag-mariadb","tag-74"],"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/1316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1316"}],"version-history":[{"count":11,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/1316\/revisions"}],"predecessor-version":[{"id":1327,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/1316\/revisions\/1327"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1316"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}