{"id":1168,"date":"2024-08-24T11:15:09","date_gmt":"2024-08-24T03:15:09","guid":{"rendered":"http:\/\/www.max-shu.com\/blog\/?p=1168"},"modified":"2024-08-24T11:15:10","modified_gmt":"2024-08-24T03:15:10","slug":"%e4%bb%8emariadb-5-x%e5%8d%87%e7%ba%a7%e5%88%b010-x","status":"publish","type":"post","link":"http:\/\/www.max-shu.com\/blog\/?p=1168","title":{"rendered":"\u4eceMariaDB 5.x\u5347\u7ea7\u523010.x"},"content":{"rendered":"\n<p><strong>\u5728CentOS7.x\u4e0a\u5347\u7ea7MariaDB 5.x\u523010.X\uff1a<\/strong><\/p>\n\n\n\n<p><strong>\u5907\u4efd\uff1a<\/strong><\/p>\n\n\n\n<p># mysqldump -u root -p &#8211;all-databases &gt; alldb.sql<\/p>\n\n\n\n<p># cp \/etc\/my.cnf \/etc\/my.cnf.bak.20240126<\/p>\n\n\n\n<p><strong>\u505c\u6b62\uff1a<\/strong><\/p>\n\n\n\n<p># systemctl stop mariadb<\/p>\n\n\n\n<p># yum remove mariadb mariadb-server<\/p>\n\n\n\n<p><strong>\u6dfb\u52a0MariaDB\u5b98\u65b9\u6e90\uff1a<\/strong><\/p>\n\n\n\n<p># vi \/etc\/yum.repos.d\/MariaDB.repo<\/p>\n\n\n\n<p>[mariadb]<\/p>\n\n\n\n<p>name = MariaDB<\/p>\n\n\n\n<p>baseurl = <a href=\"http:\/\/yum.mariadb.org\/10.11.6\/centos74-amd64\">http:\/\/yum.mariadb.org\/10.11.6\/centos74-amd64<\/a><\/p>\n\n\n\n<p>gpgkey=<a href=\"https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\">https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB<\/a><\/p>\n\n\n\n<p>gpgcheck=1<\/p>\n\n\n\n<p><strong>\u5b89\u88c5\u65b0\u7248\u672c\uff1a<\/strong><\/p>\n\n\n\n<p># yum clean all<\/p>\n\n\n\n<p># yum makecache<\/p>\n\n\n\n<p># yum install mariadb mariadb-server<\/p>\n\n\n\n<p># vi \/etc\/my.cnf<\/p>\n\n\n\n<p>\u6ce8\u91ca\u6389\u6240\u6709\u4ee5innodb\u5f00\u5934\u7684\u914d\u7f6e\u9879\uff0c\u56e0\u4e3a\u5f15\u64ce\u6362\u6210\u4e86XtraDB\uff0c\u4e0d\u518d\u652f\u6301innodb\u4e86\u3002<\/p>\n\n\n\n<p><strong>\u542f\u52a8\u65b0\u7248\u672c\uff1a<\/strong><\/p>\n\n\n\n<p># mkdir \/var\/lib\/mysql<\/p>\n\n\n\n<p># chmod 777 \/var\/lib\/mysql<\/p>\n\n\n\n<p># systemctl start mariadb<\/p>\n\n\n\n<p># systemctl status mariadb.service<\/p>\n\n\n\n<p># systemctl enable mariadb<\/p>\n\n\n\n<p><strong>\u5347\u7ea7\u6570\u636e\u5e93\u8868\uff1a<\/strong><\/p>\n\n\n\n<p># mysql_upgrade -uroot -p<\/p>\n\n\n\n<p><strong>\u767b\u5165\u67e5\u770b\u6570\u636e\uff1a<\/strong><\/p>\n\n\n\n<p># mysql -uroot -p<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728CentOS7.x\u4e0a\u5347\u7ea7MariaDB 5.x\u523010.X\uff1a \u5907\u4efd\uff1a # mysqldump -u root  &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[63],"tags":[128,9,366],"class_list":["post-1168","post","type-post","status-publish","format-standard","hentry","category-63","tag-centos","tag-linux","tag-mariadb"],"views":717,"_links":{"self":[{"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1168"}],"version-history":[{"count":1,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1168\/revisions"}],"predecessor-version":[{"id":1169,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1168\/revisions\/1169"}],"wp:attachment":[{"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1168"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}