{"id":1315,"date":"2022-03-04T20:25:39","date_gmt":"2022-03-04T12:25:39","guid":{"rendered":"http:\/\/www.eait.co\/?p=1315"},"modified":"2022-03-04T20:25:39","modified_gmt":"2022-03-04T12:25:39","slug":"linux-mysql5-5-%e5%ae%89%e8%a3%85","status":"publish","type":"post","link":"https:\/\/notes.coremix.net\/?p=1315","title":{"rendered":"Linux mysql5.5 \u5b89\u88c5"},"content":{"rendered":"

 <\/p>\n

MySQL\u5b89\u88c5\u914d\u7f6e<\/p>\n

    \n
  1. \u5b98\u7f51\u4e0b\u8f7d\u5730\u5740<\/strong><\/li>\n<\/ol>\n

    https:\/\/dev.mysql.com\/downloads\/file\/?id=471503<\/a><\/p>\n

    mysql-5.7.19-1.el7.x86_64.rpm-bundle<\/p>\n

    2.<\/strong>\u68c0\u6d4b\u672c\u5730\u662f\u5426\u6709mysql\u5df2\u5b58\u5728\u7684\u5305<\/strong><\/p>\n

    rpm -qa | grep mysql<\/p>\n

     <\/p>\n

    3.<\/strong>\u68c0\u6d4b\u672c\u5730\u662f\u5426\u6709mariadb\u5df2\u5b58\u5728\u7684\u5305<\/strong><\/p>\n

    rpm -qa | grep mariadb<\/p>\n

     <\/p>\n

    4.<\/strong>\u5982\u679c\u5b58\u5728\uff0c\u5219\u4f7f\u7528yum\u547d\u4ee4\u5378\u8f7d<\/strong><\/p>\n

    mariadb-libs-5.5.56-2.el7.x86_64<\/p>\n

    yum -y remove mariadb-libs-5.5.56-2.el7.x86_64<\/p>\n

    rpm -e –nodeps mariadb-libs-5.5.56-2.el7.x86_64<\/p>\n

     <\/p>\n

    5.<\/strong>\u521b\u5efa\u4e00\u4e2a\u6587\u4ef6\u5939\uff0c\u4e0a\u4f20jar\u5305\u5230\/opt\/software\/mysql<\/strong><\/p>\n

    mkdir \/opt\/software\/mysql<\/p>\n

     <\/p>\n

    6.<\/strong>\u89e3\u538bmysql jar\u5305<\/strong><\/p>\n

    tar -xvf mysql-5.7.19-1.el7.x86_64.rpm-bundle.tar -C \/opt\/module\/mysql<\/p>\n

     <\/p>\n

    7.<\/strong>\u5b89\u88c5mysql\u7684 server\u3001client\u3001common\u3001libs\u3001lib-compat<\/strong><\/p>\n

    rpm -ivh –nodeps mysql-community-server-5.7.19-1.el7.x86_64.rpm<\/p>\n

    rpm -ivh –nodeps mysql-community-client-5.7.19-1.el7.x86_64.rpm<\/p>\n

    rpm -ivh mysql-community-common-5.7.19-1.el7.x86_64.rpm<\/p>\n

    rpm -ivh mysql-community-libs-5.7.19-1.el7.x86_64.rpm<\/p>\n

    rpm -ivh mysql-community-libs-compat-5.7.19-1.el7.x86_64.rpm<\/p>\n

     <\/p>\n

    8.<\/strong>\u67e5\u770bmysql\u7684\u670d\u52a1\u662f\u5426\u542f\u52a8<\/strong><\/p>\n

    systemctl status mysqld<\/p>\n

    Active: inactive (dead)<\/p>\n

     <\/p>\n

    9.<\/strong>\u542f\u52a8mysql\u7684\u670d\u52a1<\/strong><\/p>\n

    systemctl start mysqld<\/p>\n

     <\/p>\n

    10.<\/strong>\u518d\u6b21\u68c0\u67e5mysql\u7684\u670d\u52a1\u662f\u5426\u542f\u52a8<\/strong><\/p>\n

    systemctl status mysqld<\/p>\n

    Active: active (running) since Thu 2019-03-21 07:23:08 EDT; 2s ago<\/p>\n

     <\/p>\n

    11.<\/strong>\u67e5\u770b\u9ed8\u8ba4\u751f\u6210\u7684\u5bc6\u7801<\/strong><\/p>\n

    cat \/var\/log\/mysqld.log | grep password<\/p>\n

    2019-03-21T11:23:01.643479Z 1 [Note] A temporary password is generated for root@localhost: iwkJGgd:j6jO<\/p>\n

     <\/p>\n

    12.<\/strong>\u767b\u5f55mysql\u670d\u52a1<\/strong><\/p>\n

    mysql -uroot -p\u2019\u7136\u540e\u7c98\u8d34\u4e0a\u5bc6\u7801\u2019<\/p>\n

     <\/p>\n

    13.<\/strong>\u4fee\u6539mysql\u5bc6\u7801\u89c4\u5219<\/strong><\/p>\n\n\n\n\n\n
    0 or LOW<\/td>\n\u957f\u5ea6<\/td>\n<\/tr>\n
    1 or MEDIUM<\/td>\n\u957f\u5ea6\u3001\u5927\u5c0f\u5199\u3001\u6570\u5b57\u3001\u7279\u6b8a\u5b57\u7b26<\/td>\n<\/tr>\n
    2 or STRONG<\/td>\n\u957f\u5ea6\u3001\u5927\u5c0f\u5199\u3001\u6570\u5b57\u3001\u7279\u6b8a\u5b57\u7b26\u3001\u8bcd\u5178<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

     <\/p>\n

    \u6ce8\uff1a\u4ee5\u4e0b\u4fee\u6539\u662f\u4e34\u65f6\u4fee\u6539<\/strong><\/p>\n

      \n
    1. \u5bc6\u7801\u5f3a\u5ea6\u68c0\u67e5\u7b49\u7ea7\uff0c0\/LOW\u30011\/MEDIUM\u30012\/STRONG<\/strong><\/li>\n<\/ol>\n

      mysql> set global validate_password_policy=0;<\/p>\n

      Query OK, 0 rows affected (0.05 sec)<\/p>\n

       <\/p>\n

      b.<\/strong>\u5bc6\u7801\u81f3\u5c11\u8981\u5305\u542b\u7684\u5c0f\u5199\u5b57\u6bcd\u4e2a\u6570\u548c\u5927\u5199\u5b57\u6bcd\u4e2a\u6570<\/strong><\/p>\n

      mysql> set global validate_password_mixed_case_count=0;<\/p>\n

      Query OK, 0 rows affected (0.00 sec)<\/p>\n

       <\/p>\n

      c.<\/strong>\u5bc6\u7801\u81f3\u5c11\u8981\u5305\u542b\u7684\u6570\u5b57\u4e2a\u6570<\/strong><\/p>\n

      mysql> set global validate_password_number_count=3;<\/p>\n

      Query OK, 0 rows affected (0.00 sec)<\/p>\n

       <\/p>\n

      d.<\/strong>\u5bc6\u7801\u81f3\u5c11\u8981\u5305\u542b\u7684\u7279\u6b8a\u5b57\u7b26\u6570<\/strong><\/p>\n

      mysql> set global validate_password_special_char_count=0;<\/p>\n

      Query OK, 0 rows affected (0.00 sec)<\/p>\n

       <\/p>\n

      e.<\/strong>\u5bc6\u7801\u6700\u5c0f\u957f\u5ea6\uff0c\u53c2\u6570\u9ed8\u8ba4\u4e3a8\uff0c<\/strong><\/p>\n

      \u5b83\u6709\u6700\u5c0f\u503c\u7684\u9650\u5236\uff0c\u6700\u5c0f\u503c\u4e3a\uff1avalidate_password_number_count + \u5bc6\u7801\u81f3\u5c11\u8981\u5305\u542b\u7684\u6570\u5b57\u4e2a\u6570validate_password_special_char_count +\u7279\u6b8a\u5b57\u7b26<\/p>\n

      (2 * validate_password_mixed_case_count)\u81f3\u5c11\u8981\u5305\u542b\u7684\u5c0f\u5199\u5b57\u6bcd\u4e2a\u6570\u548c\u5927\u5199\u5b57\u6bcd\u4e2a\u6570<\/p>\n

      mysql> set global validate_password_length=3;<\/p>\n

      Query OK, 0 rows affected (0.00 sec)<\/p>\n

        \n
      1. \u4fee\u6539\u5bc6\u7801\uff1a<\/strong><\/li>\n<\/ol>\n

        mysql> set password for root@localhost = password(‘000000’);<\/p>\n

        \uff08\u8df3\u8fc7\u8fd9\u53e5\uff0c\u56e0\u4e3a\u5bb9\u6613\u51fa\u9519\uff09GRANT ALL PRIVILEGES ON *.* TO ‘root’@’localhost’ IDENTIFIED BY ‘000000’ WITH GRANT OPTION;<\/p>\n

        2.<\/strong>\u67e5\u8be2\u5f53\u524duser\u8868\u5185root\u7684\u767b\u5f55\u6743\u9650\uff1a<\/strong><\/p>\n

        mysql> \u00a0 select host,user from mysql.user;<\/p>\n

        3.<\/strong>\u4fee\u6539\u6743\u9650\u4e3a\u6240\u6709%\uff1a<\/strong><\/p>\n

        mysql> update mysql.user set host = ‘%’ where user = ‘root’;<\/p>\n

        4.<\/strong>\u5237\u65b0\u7f13\u5b58\uff1a<\/strong><\/p>\n

        mysql> flush privileges;<\/p>\n

         <\/p>\n

         <\/p>\n

         <\/p>\n","protected":false},"excerpt":{"rendered":"

          MySQL\u5b89\u88c5\u914d\u7f6e \u5b98\u7f51\u4e0b\u8f7d\u5730\u5740 https:\/\/dev.mysql.com\/downloads […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1315","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/posts\/1315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1315"}],"version-history":[{"count":1,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/posts\/1315\/revisions"}],"predecessor-version":[{"id":1316,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/posts\/1315\/revisions\/1316"}],"wp:attachment":[{"href":"https:\/\/notes.coremix.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}