{"id":20477,"date":"2021-02-12T23:38:38","date_gmt":"2021-02-12T15:38:38","guid":{"rendered":"http:\/\/www.idc.net\/help\/20477\/"},"modified":"2022-04-29T14:34:14","modified_gmt":"2022-04-29T06:34:14","slug":"ubuntu%e4%b8%8b%e5%ae%89%e8%a3%85mariadb%e5%85%b7%e4%bd%93%e6%ad%a5%e9%aa%a4","status":"publish","type":"post","link":"https:\/\/idc.net\/help\/20477\/","title":{"rendered":"Ubuntu\u4e0b\u5b89\u88c5MariaDB\u5177\u4f53\u6b65\u9aa4"},"content":{"rendered":"
\n

MariaDB\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u662f MySQL \u7684\u4e00\u4e2a\u5206\u652f\uff0c\u4e3b\u8981\u7531\u5f00\u6e90\u793e\u533a\u5728\u7ef4\u62a4\uff0c\u91c7\u7528GPL\u6388\u6743\u8bb8\u53ef MariaDB\u7684\u76ee\u7684\u662f\u5b8c\u5168\u517c\u5bb9MySQL\uff0c\u5305\u62ecAPI\u548c\u547d\u4ee4\u884c\uff0c\u4f7f\u4e4b\u80fd\u8f7b\u677e\u6210\u4e3aMySQL\u7684\u4ee3\u66ff\u54c1\uff0c\u4e0b\u9762\u4e3a\u5927\u5bb6\u5206\u4eab\u4e00\u4e0bUbuntu\u4e0b\u5b89\u88c5MariaDB\u5177\u4f53\u6b65\u9aa4\u3002<\/p>\n

<\/p>\n

\u5b89\u88c5MariaDB<\/span><\/h3>\n
wuxiangping@linuxcool:~$ sudo apt update\r\nwuxiangping@linuxcool:~$ sudo apt install mariadb-server\r\n<\/code><\/pre>\n
\u5b89\u88c5\u5b8c\u6210\u540e\uff0cMariaDB\u670d\u52a1\u5c06\u81ea\u52a8\u542f\u52a8\u3002<\/p>\n
\u9a8c\u8bc1\u6570\u636e\u5e93\u670d\u52a1\u5668\u8fd0\u884c\u72b6\u6001<\/span><\/h3>\n
wuxiangping@linuxcool:~$ sudo systemctl status mariadb.service\r\n<\/code><\/pre>\n
  \u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB\u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB   <\/p>\n
\u67e5\u770b\u6570\u636e\u5e93\u7248\u672c\u53f7<\/span><\/h3>\n
wuxiangping@linuxcool:~$ mysql --version\r\nmysql  Ver 15.1 Distrib 10.1.44-MariaDB, for<\/span> debian-linux-gnu (x86_64) using readline 5.2\r\n<\/code><\/pre>\n
  \u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB\u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB   <\/p>\n
MariaDB\u5b89\u5168\u914d\u7f6e\uff0c\u521d\u59cb\u5316\u6570\u636e<\/span><\/h3>\n
MariaDB\u670d\u52a1\u5668\u8f6f\u4ef6\u5305\u81ea\u5e26\u4e00\u4e2a\u540d\u4e3amysql_secure_installation\u7684\u811a\u672c\uff0c\u53ef\u4ee5\u8f7b\u677e\u63d0\u9ad8\u6570\u636e\u5e93\u670d\u52a1\u5668\u7684\u5b89\u5168\u6027\u3002<\/p>\n
wuxiangping@linuxcool:~$ sudo mysql_secure_installation\r\n\r\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB\r\n     SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!\r\n\r\nIn order to log<\/span> into MariaDB to secure it, we'll need the current password for the root user.  If you'<\/span>ve just installed MariaDB, and\r\nyou haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none): OK, successfully used password, moving on... Setting the root password ensures that nobody can log into the MariaDB root user without the proper authorisation. You already have a root password set, so you can safely answer '<\/span>n'. Change the root password? [Y\/n] y New password: Re-enter new password: Password updated successfully! Reloading privilege tables.. ... Success! By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB without having to have a user account created for them.  This is intended only for testing, and to make the installation go a bit smoother.  You should remove them before moving into a production environment. Remove anonymous users? [Y\/n] y ... Success! Normally, root should only be allowed to connect from '<\/span>localhost'.  This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? [Y\/n] y ... Success! By default, MariaDB comes with a database named '<\/span>test<\/span>' that anyone can access.  This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? [Y\/n] y - Dropping test database... ... Success! - Removing privileges on test database... ... Success! Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? [Y\/n] y ... Success! Cleaning up... All done!  If you'<\/span>ve completed all of the above steps, your MariaDB\r\ninstallation should now be secure.\r\n\r\nThanks for<\/span> using MariaDB!\r\n<\/code><\/pre>\n
  \u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB\u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB   <\/p>\n
\u672c\u5730root\u7528\u6237\u767b\u5f55<\/span><\/h3>\n
shell\u4e0eMariaDB\u4ea4\u4e92\u64cd\u4f5c\uff0c\u8fd0\u884c\u65f6\u4f1a\u63d0\u793a\u8f93\u5165\u7cfb\u7edf\u7528\u6237\u540d\u7684\u5bc6\u7801<\/p>\n
wuxiangping@linuxcool:~$ sudo mysql\r\n[sudo] wuxiangping \u7684\u5bc6\u7801\uff1a\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 49\r\nServer version: 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04\r\n\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;'<\/span> or '\\h'<\/span> for<\/span> help<\/span>. Type '\\c'<\/span> to clear the current input statement.\r\n\r\nMariaDB [(none)]>\r\n<\/code><\/pre>\n
\u6388\u6743MariaDB\u6307\u5b9a\u4e3b\u673a\u8fdc\u7a0b\u8bbf\u95ee<\/span><\/h3>\n
\u9ed8\u8ba4\u76d1\u542c\u7aef\u53e3\u662f127.0.0.1\uff0c\u9700\u8981\u4fee\u6539\u4e3a\u4e3b\u673aIP<\/p>\n
wuxiangping@linuxcool:~$ sudo vim \/etc\/mysql\/mariadb.conf.d\/50-server.cnf\r\nbind<\/span>-address=192.168.3.22\r\n<\/code><\/pre>\n
  \u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB\u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB   <\/p>\n
MariaDB [(none)]> use mysql;\r\nReading table information for<\/span> completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\nMariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'<\/span>@'192.168.3.8'<\/span> IDENTIFIED BY 'password'<\/span> WITH GRANT OPTION;\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nMariaDB [mysql]> flush privileges;\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nMariaDB [mysql]> select host, user from user;\r\n<\/code><\/pre>\n
  \u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB\u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB   <\/p>\n
\u91cd\u542fmariadb\u670d\u52a1<\/p>\n
wuxiangping@linuxcool:~$ sudo systemctl restart mariadb.service\r\n<\/code><\/pre>\n
\u8fdc\u7a0b\u4e3b\u673a\u8fde\u63a5\u6d4b\u8bd5<\/span><\/h3>\n
  \u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB\u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB
\n  \u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB\u5728Ubuntu\u4e0a\u5b89\u88c5MariaDB   <\/p>\n","protected":false},"excerpt":{"rendered":"
MariaDB\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u662f MySQL \u7684\u4e00\u4e2a\u5206\u652f\uff0c\u4e3b\u8981\u7531\u5f00\u6e90\u793e\u533a\u5728\u7ef4\u62a4\uff0c\u91c7\u7528GPL\u6388\u6743\u8bb8\u53ef MariaD […]<\/p>\n","protected":false},"author":1,"featured_media":20478,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34,28],"tags":[],"class_list":["post-20477","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","category-ubuntu"],"_links":{"self":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts\/20477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/comments?post=20477"}],"version-history":[{"count":0,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts\/20477\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/media\/20478"}],"wp:attachment":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/media?parent=20477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/categories?post=20477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/tags?post=20477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}