{"id":18555,"date":"2024-11-19T20:00:05","date_gmt":"2024-11-19T12:00:05","guid":{"rendered":"https:\/\/fwq.ai\/blog\/?p=18555"},"modified":"2024-11-19T20:00:05","modified_gmt":"2024-11-19T12:00:05","slug":"mysql5-7%e5%88%9d%e6%ac%a1%e5%ae%89%e8%a3%85%e7%9a%84%e6%b3%a8%e6%84%8f%e4%ba%8b%e9%a1%b9","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/18555\/","title":{"rendered":"Mysql5.7\u521d\u6b21\u5b89\u88c5\u7684\u6ce8\u610f\u4e8b\u9879"},"content":{"rendered":"<p>\u7b2c\u4e00\u6b21\u5b89\u88c5mysql5.7\u65f6\uff0c\u9700\u8981\u6ce8\u610f\u7684\u51e0\u4e2a\u5730\u65b9\uff0c\u505a\u4e2a\u7b14\u8bb0\uff1a<\/p>\n<p>&nbsp;<\/p>\n<p><strong>tips 01 \uff1a<\/strong>\u5982\u5728\u4f7f\u7528YUM\u5b89\u88c5\u7684\u8fc7\u7a0b\u4e2d\uff0c\u63d0\u793a\u7c7b\u4f3c\u4e8e\u4ee5\u4e0b\u7684\u9519\u8bef\uff0c\u90a3\u4e48\u8bf7\u79fb\u6b65\u5230\uff1aMySQL\u7684\u5b89\u88c5\u4e0e\u914d\u7f6e<br \/>\n\u8fd9\u91cc\u91c7\u7528\u4e8c\u8fdb\u5236\u5305\uff0c\u76f4\u63a5\u4e0b\u8f7d\u3001\u89e3\u538b\u4f7f\u7528\u3002<\/p>\n<pre>2:postfix-2.10.1-6.el7.x86_64 \u6709\u7f3a\u5c11\u7684\u9700\u6c42 libmysqlclient.so.18()(64bit)\r\n2:postfix-2.10.1-6.el7.x86_64 \u6709\u7f3a\u5c11\u7684\u9700\u6c42 libmysqlclient.so.18(libmysqlclient_18)(64bit)<\/pre>\n<h1>1\u3001\u4e0b\u8f7dmysql.repo<\/h1>\n<p>\u5982\u679c\u672c\u4eba\u4f7f\u7528yum\u76f4\u63a5\u5b89\u88c5\uff0c\u5982\u679c\u672c\u673a\u8fd8\u6ca1\u6709mysql 5.7 \u7684\u4ed3\u5e93\u6587\u4ef6<\/p>\n<h3>2\u3001\u5b89\u88c5\u51b2\u7a81<\/h3>\n<p>\u5728centos 7 \u7684\u7cfb\u7edf\u4e2d\uff0c\u9ed8\u8ba4\u5b89\u88c5mariadb\uff0c\u5982\u679c\u786e\u5b9a\u8981\u5b89\u88c5 mysql \uff0c\u5fc5\u9700\u5f3a\u5236\u5378\u8f7d\uff1a<\/p>\n<pre>rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64<\/pre>\n<h3>3\u3001\u68c0\u67e5\u76ee\u5f55<\/h3>\n<p>\u5728 \/etc\/my.cnf \u6587\u4ef6\uff0c\u67094\u4e2a\u8def\u5f84<\/p>\n<pre>datadir=\/var\/lib\/mysql\r\nsocket=\/var\/lib\/mysql\/mysql.sock\r\nlog-error=\/var\/log\/mysqld.log\r\npid-file=\/var\/run\/mysqld\/mysqld.pid<\/pre>\n<p>\u68c0\u67e5\u8fd94\u4e2a\u76ee\u5f55\u662f\u5426\u5b58\u5728\uff0c\u672a\u5b58\u5728\u8bf7\u624b\u52a8\u521b\u5efa\uff0c\u5e76\u8d4b\u7ed9\u7528\u6237mysql\u7684\u8bfb\u5199\u6743\u9650\u3002<\/p>\n<h3>4\u3001\u521d\u6b21\u767b\u5f55<\/h3>\n<p>mysql 5.7 \u521d\u6b21\u767b\u5f55\u7684\u5bc6\u7801\uff0c\u5728\u5b89\u88c5\u65f6\u5df2\u7ecf\u9ed8\u8ba4\u4e86\u4e00\u4e2a\u968f\u673a\u5bc6\u7801\uff0c\u8fd9\u4e2a\u968f\u673a\u5728\u591a\u6b21\u5c1d\u8bd5\u767b\u5f55\u540e\uff0c\u4f1a\u5c06\u8fd9\u4e2a\u968f\u673a\u5bc6\u7801\u5199\u5165mysql \u7684\u65e5\u5fd7\u4e2d\u3002\u8bf7\u4f7f\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u83b7\u53d6\uff1a<\/p>\n<pre># grep 'temporary password' \/var\/log\/mysqld.log<\/pre>\n<h3>5\u3001\u66f4\u6539\u5bc6\u7801<\/h3>\n<p>\u521d\u6b21\u767b\u5f55\u6210\u529f\u540e\uff0c\u65e0\u6cd5\u8fdb\u884c\u64cd\u4f5c\u7684\uff0c\u9700\u8981\u66f4\u6539\u5bc6\u7801\u624d\u53ef\u4ee5\u8fdb\u884c\u64cd\u4f5c\uff0c\u66f4\u6539\u5bc6\u7801\u7684\u64cd\u4f5c\uff1a<\/p>\n<pre>set password=PASSWORD('123456'); \/\/\u5982\u679c\u66f4\u6539\u5931\u8d25\uff0c\u8bf7\u53c2\u8003\u4e0b\u9762\u7684<\/pre>\n<p><strong>Tips 1\uff1a<\/strong>\u5982\u679c\u4f7f\u7528\u4e34\u65f6\u5bc6\u7801\u65e0\u6cd5\u767b\u5f55\uff0c\u90a3\u80af\u5b9a\u662f\u4e34\u65f6\u5bc6\u7801\u8fc7\u671f\uff0c\u8bf7\u4f7f\u7528\u4e0b\u9762\u7684\u65b9\u6cd5\u66f4\u6539\u5bc6\u7801\uff1a<\/p>\n<ol>\n<li class=\"p1\"><span class=\"s1\">\u4fee\u6539 \/etc\/my.cnf\uff0c\u5728 [mysqld] \u5c0f\u8282\u4e0b\u6dfb\u52a0\u4e00\u884c\uff1askip-grant-tables=1 ,<\/span>\u8fd9\u4e00\u884c\u914d\u7f6e\u8ba9 mysqld \u542f\u52a8\u65f6\u4e0d\u5bf9\u5bc6\u7801\u8fdb\u884c\u9a8c\u8bc1<\/li>\n<li class=\"p1\">\u91cd\u542f mysqld \u670d\u52a1\uff1asystemctl restart mysqld<\/li>\n<li class=\"p1\">\u4f7f\u7528 root \u7528\u6237\u767b\u5f55\u5230 mysql\uff1amysql -u root<\/li>\n<li class=\"p1\">\u5207\u6362\u5230mysql\u6570\u636e\u5e93\uff0c\u66f4\u65b0 user \u8868\uff1a<\/li>\n<li class=\"p1\"><span class=\"s1\">update user set authentication_string = password(\u2018root\u2019), password_expired = \u2018N\u2019, password_last_changed = now() where user = \u2018root&#8217;;\u00a0<\/span>\u5728\u4e4b\u524d\u7684\u7248\u672c\u4e2d\uff0c\u5bc6\u7801\u5b57\u6bb5\u7684\u5b57\u6bb5\u540d\u662f password\uff0c5.7\u7248\u672c\u6539\u4e3a\u4e86 authentication_string<\/li>\n<li class=\"p1\">\u9000\u51fa mysql\uff0c\u7f16\u8f91 \/etc\/my.cnf \u6587\u4ef6\uff0c\u5220\u9664\u00a0skip-grant-tables=1 \u7684\u5185\u5bb9<\/li>\n<li class=\"p1\">\u91cd\u542f mysqld \u670d\u52a1\uff0c\u518d\u7528\u65b0\u5bc6\u7801\u767b\u5f55\u5373\u53ef<\/li>\n<\/ol>\n<h3>6\u3001\u8bbe\u7f6e\u5bc6\u7801\u5b89\u5168\u7ea7\u522b<\/h3>\n<p>mysql 5.X \u5f00\u59cb\u5bf9\u5bc6\u7801\u7ea7\u522b\u8fdb\u884c\u4e86\u9650\u5236\uff0c\u6700\u9ad8\u7684\u5f3a\u5ea6\u5fc5\u9700\u8981\u5927\u5c0f\u5b57\u6bcd\u3001\u6570\u5b57\u7b49\u3002\u4f46\u6709\u7684\u65f6\u5019\uff0c\u6211\u4eec\u9700\u8981\u5bc6\u7801\u7b80\u5355\u4e9b\uff0c\u53ef\u4ee5\u5148\u4fee\u6539\u5bc6\u7801\u5b8c\u5168\u7ea7\u522b\uff0c\u66f4\u6539\u5b8c\u6210\u540e\uff0c\u518d\u4fee\u6539\u5bc6\u7801\uff0c\u8bbe\u7f6e\u5982\u4e0b\uff1a<\/p>\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">mysql&gt;\u00a0SHOW\u00a0VARIABLES\u00a0LIKE\u00a0<\/code><code class=\"bash string\">'validate_password%'<\/code><code class=\"bash plain\">;<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">+--------------------------------------+--------+<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">|\u00a0Variable_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0Value\u00a0\u00a0|<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">+--------------------------------------+--------+<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">|\u00a0validate_password_dictionary_file\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">|\u00a0validate_password_length\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a08\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">|\u00a0validate_password_mixed_case_count\u00a0\u00a0\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash plain\">|\u00a0validate_password_number_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"bash plain\">|\u00a0validate_password_policy\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0MEDIUM\u00a0|<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"bash plain\">|\u00a0validate_password_special_char_count\u00a0|\u00a01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"bash plain\">+--------------------------------------+--------+<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><\/div>\n<div class=\"line number11 index10 alt2\"><\/div>\n<\/div>\n<p>\u901a\u8fc7\u00a0 SET GLOBAL\u00a0 validate_password_policy=\u2019LOW&#8217;;\u00a0 \u547d\u4ee4\uff0c\u964d\u4f4e\u5b89\u5168\u7b49\u7ea7\u540e\uff0c\u5c31\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\uff0c\u9650\u5236\u662f\u5fc5\u987b8\u4e2a\u5b57\u7b26\u4ee5\u4e0a\uff0c\u5f53\u7136\u4e5f\u53ef\u4ee5\u8bbe\u7f6e\u5b83\u7684\u5bc6\u7801\u957f\u5ea6\u3002<\/p>\n<p>\u5173\u4e8e\u5b89\u5168\u7b49\u7ea7\u66f4\u8be6\u7ec6\u7684\u4ecb\u7ecd\u5982\u4e0b<\/p>\n<ul>\n<li>LOW \u653f\u7b56\u53ea\u6d4b\u8bd5\u5bc6\u7801\u957f\u5ea6\u3002 \u5bc6\u7801\u5fc5\u987b\u81f3\u5c11\u67098\u4e2a\u5b57\u7b26\u957f\u3002<\/li>\n<li>MEDIUM \u653f\u7b56\u7684\u6761\u4ef6 \u5bc6\u7801\u5fc5\u987b\u5305\u542b\u81f3\u5c111\u6570\u5b57\u5b57\u7b26,1 \u5927\u5199\u548c\u5c0f\u5199\u5b57\u7b26,\u548c1\u7279\u522b (nonalphanumeric)\u5b57\u7b26\u3002<\/li>\n<li>STRONG \u653f\u7b56\u7684\u60c5\u51b5 \u5bc6\u7801\u5b50\u5b57\u7b26\u4e32\u957f\u5ea6\u4e3a4\u7684\u6216\u66f4\u957f\u65f6\u95f4\u4e0d\u80fd\u5339\u914d \u5355\u8bcd\u5728\u5b57\u5178\u6587\u4ef6\u4e2d,\u5982\u679c\u4e00\u4e2a\u4eba\u88ab\u6307\u5b9a\u3002<\/li>\n<\/ul>\n<h3>7\u3001\u5bc6\u7801\u8fc7\u671f<\/h3>\n<p>\u81eaMySQL 5.7\u5f00\u59cb\uff0c\u5bc6\u7801\u5b58\u5728\u6709\u6548\u671f\u7684\u6982\u5ff5\uff0c\u4e3a\u4e86\u89e3\u51b3\u5bc6\u7801\u5931\u6548\u7684\u95ee\u9898\uff0c \u6700\u540e\u5728\u914d\u7f6e\u6587\u4ef6\u7684[mysqld]\u5b57\u6bb5\u4e0b\uff0c\u589e\u52a0\u4ee5\u4e0b\u5b57\u6bb5<\/p>\n<pre>[mysqld]\r\ndefault_password_lifetime=0<\/pre>\n<p>\u4e5f\u53ef\u4ee5\u901a\u8fc7\u547d\u4ee4\u884c\u8fdb\u884c\u8bbe\u7f6e<\/p>\n<pre>ALTER USER 'script'@'localhost' PASSWORD EXPIRE NEVER<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u7b2c\u4e00\u6b21\u5b89\u88c5mysql5.7\u65f6\uff0c\u9700\u8981\u6ce8\u610f\u7684\u51e0\u4e2a\u5730\u65b9\uff0c\u505a\u4e2a\u7b14\u8bb0\uff1a &nbsp; tips 01 \uff1a\u5982\u5728\u4f7f\u7528YUM\u5b89\u88c5\u7684\u8fc7\u7a0b\u4e2d\uff0c\u63d0\u793a\u7c7b\u4f3c\u4e8e\u4ee5\u4e0b\u7684\u9519\u8bef\uff0c\u90a3\u4e48\u8bf7\u79fb\u6b65\u5230\uff1aMySQL\u7684\u5b89\u88c5\u4e0e\u914d\u7f6e \u8fd9\u91cc\u91c7\u7528\u4e8c\u8fdb\u5236\u5305\uff0c\u76f4\u63a5\u4e0b\u8f7d\u3001\u89e3\u538b\u4f7f\u7528\u3002 2:postfix-2.10.1-6.el7.x86_64 \u6709\u7f3a\u5c11\u7684\u9700\u6c42 libmysqlclient.so.18()(64bit) 2:postfix-2.10.1-6.el7.x86_64 \u6709\u7f3a\u5c11\u7684\u9700\u6c42 libmysqlclient.so.18(libmysqlclient_18)(64bit) 1\u3001\u4e0b\u8f7dmysql.repo \u5982\u679c\u672c\u4eba\u4f7f\u7528yum\u76f4\u63a5\u5b89\u88c5\uff0c\u5982\u679c\u672c\u673a\u8fd8\u6ca1\u6709mysql 5.7 \u7684\u4ed3\u5e93\u6587\u4ef6 2\u3001\u5b89\u88c5\u51b2\u7a81 \u5728centos 7 \u7684\u7cfb\u7edf\u4e2d\uff0c\u9ed8\u8ba4\u5b89\u88c5mariadb\uff0c\u5982\u679c\u786e\u5b9a\u8981\u5b89\u88c5 mysql \uff0c\u5fc5\u9700\u5f3a\u5236\u5378\u8f7d\uff1a rpm -e &#8211;nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64 3\u3001\u68c0\u67e5\u76ee\u5f55 \u5728 \/etc\/my.cnf \u6587\u4ef6\uff0c\u67094\u4e2a\u8def\u5f84 datadir=\/var\/lib\/mysql socket=\/var\/lib\/mysql\/mysql.sock log-error=\/var\/log\/mysqld.log pid-file=\/var\/run\/mysqld\/mysqld.pid \u68c0\u67e5\u8fd94\u4e2a\u76ee\u5f55\u662f\u5426\u5b58\u5728\uff0c\u672a\u5b58\u5728\u8bf7\u624b\u52a8\u521b\u5efa\uff0c\u5e76\u8d4b\u7ed9\u7528\u6237mysql\u7684\u8bfb\u5199\u6743\u9650\u3002 4\u3001\u521d\u6b21\u767b\u5f55 mysql 5.7 \u521d\u6b21\u767b\u5f55\u7684\u5bc6\u7801\uff0c\u5728\u5b89\u88c5\u65f6\u5df2\u7ecf\u9ed8\u8ba4\u4e86\u4e00\u4e2a\u968f\u673a\u5bc6\u7801\uff0c\u8fd9\u4e2a\u968f\u673a\u5728\u591a\u6b21\u5c1d\u8bd5\u767b\u5f55\u540e\uff0c\u4f1a\u5c06\u8fd9\u4e2a\u968f\u673a\u5bc6\u7801\u5199\u5165mysql \u7684\u65e5\u5fd7\u4e2d\u3002\u8bf7\u4f7f\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u83b7\u53d6\uff1a # grep &#8216;temporary password&#8217; \/var\/log\/mysqld.log 5\u3001\u66f4\u6539\u5bc6\u7801 \u521d\u6b21\u767b\u5f55\u6210\u529f\u540e\uff0c\u65e0\u6cd5\u8fdb\u884c\u64cd\u4f5c\u7684\uff0c\u9700\u8981\u66f4\u6539\u5bc6\u7801\u624d\u53ef\u4ee5\u8fdb\u884c\u64cd\u4f5c\uff0c\u66f4\u6539\u5bc6\u7801\u7684\u64cd\u4f5c\uff1a set password=PASSWORD(&#8216;123456&#8217;); \/\/\u5982\u679c\u66f4\u6539\u5931\u8d25\uff0c\u8bf7\u53c2\u8003\u4e0b\u9762\u7684 Tips 1\uff1a\u5982\u679c\u4f7f\u7528\u4e34\u65f6\u5bc6\u7801\u65e0\u6cd5\u767b\u5f55\uff0c\u90a3\u80af\u5b9a\u662f\u4e34\u65f6\u5bc6\u7801\u8fc7\u671f\uff0c\u8bf7\u4f7f\u7528\u4e0b\u9762\u7684\u65b9\u6cd5\u66f4\u6539\u5bc6\u7801\uff1a \u4fee\u6539 \/etc\/my.cnf\uff0c\u5728 [mysqld] [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-18555","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/18555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=18555"}],"version-history":[{"count":1,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/18555\/revisions"}],"predecessor-version":[{"id":18556,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/18555\/revisions\/18556"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=18555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=18555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=18555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}