{"id":19583,"date":"2017-06-04T06:01:32","date_gmt":"2017-06-03T22:01:32","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2017\/06\/04\/%e5%ae%89%e8%a3%9d-mariadb-sql-sever-10-x\/"},"modified":"2021-03-18T17:25:03","modified_gmt":"2021-03-18T09:25:03","slug":"%e5%ae%89%e8%a3%9d-mariadb-sql-sever-10-x","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2017\/06\/04\/%e5%ae%89%e8%a3%9d-mariadb-sql-sever-10-x\/","title":{"rendered":"\u5b89\u88dd MariaDB SQL Sever 10.x"},"content":{"rendered":"

\u5728 CentOS 7.x \u4f7f\u7528\u5167\u5efa\u7684\u5957\u4ef6\u5eab\u5b89\u88dd\u7684 MariaDB SQL Server \u7248\u672c\u662f 5.x
# \/usr\/bin\/mysql -u root -p<\/span>
Enter password:<\/span>
Welcome to the MariaDB monitor.\u00a0 Commands end with ; or g.<\/span>
Your MariaDB connection id is 16<\/span>
Server version: 5.5.52<\/span>-MariaDB MariaDB Server<\/span><\/p>\n

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.<\/span><\/p>\n

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.<\/span><\/p>\n

MariaDB [(none)]><\/span> quit<\/span>
Bye<\/span><\/p>\n

\u5b89\u88dd 10.x \u7248\u672c
1. \u4f7f\u7528 MariaDB \u7db2\u7ad9\u4e0a\u7684\u8a2d\u5b9a\u7db2\u9801
MariaDB – Setting up MariaDB Repositories – MariaDB<\/a>
\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

[@more@]2. \u79fb\u9664\u820a\u7248\u5957\u4ef6
# systemctl disable mariadb.service<\/span>
Removed symlink \/etc\/systemd\/system\/multi-user.target.wants\/mariadb.service.<\/span>
# systemctl stop mariadb.service<\/span>
# yum remove mariadb mariadb-server mariadb-libs<\/span><\/p>\n

3. \u5efa\u7acb mariadb.repo
# vim \/etc\/yum.repos.d\/mariadb.repo<\/span>
# MariaDB 10.1 CentOS repository list – created 2017-03-12 06:10 UTC<\/span>
# http:\/\/downloads.mariadb.org\/mariadb\/repositories\/<\/span>
[mariadb]<\/span>
name = MariaDB<\/span>
baseurl = http:\/\/yum.mariadb.org\/10.1\/centos7-amd64<\/span>
gpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB<\/span>
gpgcheck=1<\/span><\/p>\n

4. \u66f4\u65b0\u5957\u4ef6\u5eab
# yum update<\/span><\/p>\n

5. \u9032\u884c\u5b89\u88dd
# yum install MariaDB-server MariaDB-client<\/span><\/p>\n

6. \u555f\u52d5 MariaDB SQL Server
# systemctl enable mariadb.service<\/span>
# systemctl start mariadb.service<\/span><\/p>\n

7. \u7248\u672c
# \/usr\/bin\/mysql -u root -p<\/span>
Enter password:<\/span>
Welcome to the MariaDB monitor.\u00a0 Commands end with ; or g.<\/span>
Your MariaDB connection id is 2<\/span>
Server version: 10.1.21<\/span>-MariaDB MariaDB Server<\/span><\/p>\n

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.<\/span><\/p>\n

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.<\/span><\/p>\n

MariaDB [(none)]><\/span> quit<\/span>
Bye<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u5728 CentOS 7.x \u4f7f\u7528\u5167\u5efa\u7684\u5957\u4ef6\u5eab\u5b89\u88dd\u7684 MariaDB SQL Server \u7248\u672c\u662f 5.x# \/u … <\/p>\n

\u95b1\u8b80\u5168\u6587\u3008\u5b89\u88dd MariaDB SQL Sever 10.x\u3009<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[117,116],"tags":[],"class_list":["post-19583","post","type-post","status-publish","format-standard","hentry","category-c-78462","category-c-78461"],"meta_key":{"_pingme":["1"],"_encloseme":["1"],"lt_post_id":["688416"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19583"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/comments?post=19583"}],"version-history":[{"count":1,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19583\/revisions"}],"predecessor-version":[{"id":21090,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19583\/revisions\/21090"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=19583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=19583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=19583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}