{"id":793,"date":"2018-05-10T11:17:17","date_gmt":"2018-05-10T02:17:17","guid":{"rendered":"https:\/\/fsck.jp\/?p=793"},"modified":"2018-07-04T14:27:43","modified_gmt":"2018-07-04T05:27:43","slug":"ubuntu-18-04-mariadb","status":"publish","type":"post","link":"https:\/\/fsck.jp\/?p=793","title":{"rendered":"Ubuntu 18.04 + MariaDB"},"content":{"rendered":"<p>Ubuntu \u6a19\u6e96\u30d1\u30c3\u30b1\u30fc\u30b8\u306e MariaDB \u3092\u4f7f\u3046\u306b\u3042\u305f\u3063\u3066\u30cf\u30de\u308a\u305d\u3046\u306a\u7b87\u6240\u3092\u8a18\u8ff0\u3057\u3066\u307f\u308b\u3002<\/p>\n<h3>DB root \u30e6\u30fc\u30b6\u3067\u306e\u63a5\u7d9a\u306b\u5931\u6557\u3059\u308b<\/h3>\n<p>MariaDB\/MySQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3044\u59cb\u3081\u308b\u3068\u304d\u306f\u3001\u307e\u305a mysql_secure_installation \u30b3\u30de\u30f3\u30c9\u3067\u72b6\u614b\u3092\u521d\u671f\u5316\u3057\u3066 root \u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b\u306e\u304c\u4e00\u822c\u7684\u3060\u308d\u3046\u3002\u305d\u3057\u3066\u3001\u8a2d\u5b9a\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u4f7f\u3063\u3066 DB root \u63a5\u7d9a\u3057\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u7b49\u306b\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3084 DB \u4e00\u822c\u30e6\u30fc\u30b6\u3092\u4f5c\u6210\u3059\u308b\u3002\u3053\u306e\u624b\u9806\u3092\u5b9f\u884c\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u3001DB \u306b root \u30ed\u30b0\u30a4\u30f3\u3067\u304d\u306a\u3044 (\u30d1\u30b9\u30ef\u30fc\u30c9\u8a8d\u8a3c\u304c\u901a\u3089\u306a\u3044) \u3068\u3044\u3046\u4e8b\u8c61\u306b\u3076\u3061\u5f53\u305f\u308b\u3002<\/p>\n<pre>\r\nuser@bionic$ sudo mysql_secure_installation (\u521d\u671f\u5316\u3057\u3066root\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a)\r\nSet root password? [Y\/n]y\r\nNew password: testpass01\r\nRe-enter new password: testpass01\r\nRemove anonymous users? [Y\/n]y\r\nDisallow root login remotely? [Y\/n]y\r\nRemove test database and access to it? [Y\/n]y\r\nReload privilege tables now? [Y\/n]y\r\n\r\nuser@bionic$ mysql -u root -p\r\nEnter password: testpass01\r\nERROR 1698 (28000): Access denied for user 'root'@'localhost' \u2190\u8a8d\u8a3c\u30a8\u30e9\u30fc\uff01\r\n<\/pre>\n<p>\u4e0a\u8a18\u52d5\u4f5c\u306e\u539f\u56e0\u306f\u3001\u521d\u671f\u72b6\u614b\u306e DB root \u30e6\u30fc\u30b6\u8a8d\u8a3c\u306b unix_socket \u8a8d\u8a3c\u30d7\u30e9\u30b0\u30a4\u30f3\u304c\u4f7f\u308f\u308c\u3066\u3044\u308b\u3053\u3068\u3067\u3042\u308b\u3002\u3053\u306e\u72b6\u614b\u3067\u306f\u3001DB root \u3068\u3057\u3066\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306b OS \u306e root \u6a29\u9650\u306b\u306a\u3089\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044 (sudo \u307e\u305f\u306f su \u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3046)\u3002OS root \u306b\u306a\u3063\u3066\u3044\u308c\u3070\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u306a\u3057\u3067 DB root \u3068\u3057\u3066\u63a5\u7d9a\u53ef\u80fd\u3067\u3042\u308b\u3002<\/p>\n<pre>\r\nuser@bionic:~$ sudo mysql\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 35\r\nServer version: 10.1.29-MariaDB-6 Ubuntu 18.04\r\n\r\nCopyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]&gt;<\/pre>\n<p>DB root \u3067\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u3068\u3001\u8a8d\u8a3c\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u72b6\u614b\u3082\u78ba\u8a8d\u3067\u304d\u308b\u3002<\/p>\n<pre>MariaDB [(none)]&gt; SELECT user,host,plugin from mysql.user;\r\n+------+-----------+-------------+\r\n| user | host      | plugin      |\r\n+------+-----------+-------------+\r\n| root | localhost | unix_socket |\u3000\u2190 unix_socket \u8a8d\u8a3c\u30d7\u30e9\u30b0\u30a4\u30f3\u304c\u4f7f\u308f\u308c\u3066\u3044\u308b\r\n+------+-----------+-------------+\r\n1 row in set (0.00 sec)<\/pre>\n<p>\u3055\u3066\u3001\u3053\u306e\u8a8d\u8a3c\u65b9\u5f0f\u3092\u305d\u306e\u307e\u307e\u4f7f\u3046\u304b\uff1f\u305d\u308c\u3068\u3082\u6614\u306a\u304c\u3089\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u8a8d\u8a3c\u306b\u623b\u3059\u304b\uff1f<\/p>\n<h3>\u521d\u671f\u72b6\u614b\u306e\u8a8d\u8a3c\u8a2d\u5b9a\u3067\u305d\u306e\u307e\u307e\u5229\u7528\u3059\u308b<\/h3>\n<p>\u521d\u671f\u8a2d\u5b9a\u306b\u4e57\u3063\u304b\u3063\u3066\u3044\u304f\u306a\u3089\u3001DB \u306e root \u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u306a\u3044\u3002<\/p>\n<p>\u307e\u305f\u4e00\u822c\u30e6\u30fc\u30b6\u3067\u3082\u540c\u4e00\u306e\u4ed5\u7d44\u307f\u3092\u4f7f\u3046\u5834\u5408\u306f\u3001UNIX \u30e6\u30fc\u30b6\u3068 DB \u30e6\u30fc\u30b6\u3092\u540c\u540d\u3067\u4f5c\u6210\u3059\u308c\u3070\u3088\u3044\u3002<\/p>\n<p>(\u305f\u3060\u3057\u3001\u3053\u306e\u8a8d\u8a3c\u65b9\u5f0f\u3067\u306f\u5916\u90e8\u30db\u30b9\u30c8\u304b\u3089 TCP\/3306 \u7d4c\u7531\u3067\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u306a\u3044\u3053\u3068\u306b\u306a\u308b\u3002\u5fc5\u305a\u30ed\u30fc\u30ab\u30eb\u306e UNIX \u30c9\u30e1\u30a4\u30f3\u30bd\u30b1\u30c3\u30c8\u7d4c\u7531\u3067\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044)<\/p>\n<p>\u4ee5\u4e0b\u306f\u30d6\u30ed\u30b0\u30a8\u30f3\u30b8\u30f3 WordPress \u3092\u300cwordpress\u300d\u3068\u3044\u3046\u30e6\u30fc\u30b6\u540d\u3067\u5229\u7528\u3059\u308b\u5834\u5408\u306e\u4f8b\u3002OS \u306e wordpress \u30e6\u30fc\u30b6\u3092\u4f5c\u308a\u3001DB \u306e wordpress \u30e6\u30fc\u30b6\u3082\u4f5c\u6210\u3059\u308b\u3002<\/p>\n<pre>user@bionic:~$ sudo useradd -m -s \/bin\/bash wordpress\r\nuser@bionic:~$ sudo mysql\r\nMariaDB [(none)]&gt; CREATE USER wordpress@localhost IDENTIFIED VIA unix_socket;<\/pre>\n<p>wordpress \u30e6\u30fc\u30b6\u3067\u63a5\u7d9a\u3067\u304d\u308b\u304b\u3069\u3046\u304b\u78ba\u8a8d\u3059\u308b\u3002<\/p>\n<pre>user@bionic:~$ sudo -i -u wordpress\r\nwordpress@bionic:~$ mysql -u wordpress\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 57\r\nServer version: 10.1.29-MariaDB-6 Ubuntu 18.04\r\n\r\nCopyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]&gt; \\q\r\nBye<\/pre>\n<p>\u3053\u306e\u3084\u308a\u65b9\u3067\u306f\u3001WordPress \u306e\u30d5\u30a1\u30a4\u30eb\u7fa4\u3092\u5b9f\u884c\u3059\u308b PHP \u306e\u5b9f\u884c\u30e6\u30fc\u30b6\u304c wordpress \u30e6\u30fc\u30b6\u3067\u3042\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002\u4f8b\u3048\u3070 PHP \u5b9f\u884c\u74b0\u5883\u306b php-fpm \u3092\u4f7f\u3063\u3066\u3044\u308b\u5834\u5408\u306f\u3001\/etc\/php\/7.2\/fpm\/pool.d\/www.conf\u3092\u7de8\u96c6\u3057\u3066 php-fpm \u5b9f\u884c\u30e6\u30fc\u30b6\u3092 wordpress \u306b\u5909\u66f4\u3059\u308b\u3002<\/p>\n<p>\/etc\/php\/7.2\/fpm\/pool.d\/www.conf \u629c\u7c8b<\/p>\n<pre>\r\nuser = wordpress\r\ngroup = wordpress<\/pre>\n<p>wordpress\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210<\/p>\n<pre>\r\nuser@bionic:~$ sudo mysql\r\nMariaDB [(none)]&gt; CREATE DATABASE wordpress;\r\nMariaDB [(none)]&gt; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,INDEX,ALTER ON wordpress.* TO wordpress@localhost;<\/pre>\n<p>wordpress \u5074\u306e\u8a2d\u5b9a (wp-config.php) \u3067\u306f\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u7a7a\u306b\u3057\u3066\u304a\u304f\u3002<\/p>\n<pre>\r\ndefine('DB_NAME', 'wordpress');\r\ndefine('DB_USER', 'wordpress');\r\ndefine('DB_PASSWORD', '');\r\ndefine('DB_HOST', 'localhost');<\/pre>\n<h3>\u5f93\u6765\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u8a8d\u8a3c\u3092\u4f7f\u3063\u3066\u3044\u304f\u5834\u5408<\/h3>\n<p>DB \u306e root \u30e6\u30fc\u30b6\u3092\u5f93\u6765\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u8a8d\u8a3c\u306b\u5909\u66f4\u3059\u308b (\u4ee5\u524d\u306e\u65b9\u5f0f\u306b\u623b\u3059) \u3002\u79c1\u81ea\u8eab\u306f\u3001\u3053\u3061\u3089\u306e\u624b\u6cd5\u3067\u884c\u304f\u3053\u3068\u306b\u3059\u308b\u3002<\/p>\n<pre>\r\nuser@bionic:~$ sudo mysql\r\nMariaDB [(none)]&gt; set password for 'root'@'localhost'=password('testpass02');\r\nMariaDB [(none)]&gt; use mysql;\r\nMariaDB [mysql]&gt; update user set plugin='' where user='root';\r\nMariaDB [mysql]&gt; flush privileges;\r\nMariaDB [mysql]&gt; \\q<\/pre>\n<p>root \u30e6\u30fc\u30b6\u306e\u8a8d\u8a3c\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u5916\u3057\u3001\u901a\u5e38\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u3002<\/p>\n<p>\u4e00\u822c\u30e6\u30fc\u30b6\u306b\u3064\u3044\u3066\u3082\u3001\u901a\u5e38\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u3066\u4f5c\u6210\u3059\u308b\u3002<\/p>\n<pre>\r\nuser@bionic:~$ mysql -u root -p\r\nEnter password: testpass02\r\nMariaDB [(none)]&gt; CREATE USER wordpress@localhost IDENTIFIED BY 'testpass03';<\/pre>\n<p>\u3053\u306e\u5834\u5408\u3001\u30ed\u30b0\u30ed\u30fc\u30c6\u30fc\u30c8\u306e\u51e6\u7406 (\/etc\/logrotate.d\/mysql-server \u306e16\u884c\u76ee) \u306broot\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u5fc5\u8981\u306b\u306a\u308b\u3002\/etc\/mysql\/debian.cnf \u306e password \u884c\u306b\u5e73\u6587\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a18\u8ff0\u3057\u3066\u304a\u304f\u3053\u3068\u3002<br \/>\n<code>user@bionic:~$ sudo vi \/etc\/mysql\/debian.cnf<\/code><\/p>\n<pre>5\u884c\u76ee\u300110\u884c\u76ee\r\npassword = testpass02<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Ubuntu \u6a19\u6e96\u30d1\u30c3\u30b1\u30fc\u30b8\u306e MariaDB \u3092\u4f7f\u3046\u306b\u3042\u305f\u3063\u3066\u30cf\u30de\u308a\u305d\u3046\u306a\u7b87\u6240\u3092\u8a18\u8ff0\u3057\u3066\u307f\u308b\u3002 DB root \u30e6\u30fc\u30b6\u3067\u306e\u63a5\u7d9a\u306b\u5931\u6557\u3059\u308b MariaDB\/MySQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3044\u59cb\u3081\u308b\u3068\u304d\u306f\u3001\u307e\u305a mysql_s [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[13,9,14,26],"tags":[],"_links":{"self":[{"href":"https:\/\/fsck.jp\/index.php?rest_route=\/wp\/v2\/posts\/793"}],"collection":[{"href":"https:\/\/fsck.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fsck.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fsck.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fsck.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=793"}],"version-history":[{"count":0,"href":"https:\/\/fsck.jp\/index.php?rest_route=\/wp\/v2\/posts\/793\/revisions"}],"wp:attachment":[{"href":"https:\/\/fsck.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fsck.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fsck.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}