{"id":494,"date":"2017-01-03T12:54:19","date_gmt":"2017-01-03T03:54:19","guid":{"rendered":"http:\/\/www.typea.info\/blog\/index.php\/2017\/01\/03\/mysql57_centos_7\/"},"modified":"2017-01-03T12:54:19","modified_gmt":"2017-01-03T03:54:19","slug":"mysql57_centos_7","status":"publish","type":"post","link":"https:\/\/www.typea.info\/blog\/index.php\/2017\/01\/03\/mysql57_centos_7\/","title":{"rendered":"MySQL5.7 \u3092 CentOS 7 \u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb"},"content":{"rendered":"<p><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.6\/ja\/linux-installation-yum-repo.html\">MySQL Yum \u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u4f7f\u7528\u3057\u3066 MySQL \u3092 Linux \u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/a>\u3092\u53c2\u8003\u306b\u3057\u306a\u304c\u3089\u3001CentOS7\u306b Yum \u3092\u5229\u7528\u3057\u3066MySQL\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u884c\u3046\u3002<\/p>\n<p><a href=\"https:\/\/www.amazon.co.jp\/%E8%A9%B3%E8%A7%A3MySQL-5-7-%E6%AD%A2%E3%81%BE%E3%82%89%E3%81%AC%E9%80%B2%E5%8C%96%E3%81%AB%E4%B9%97%E3%82%8A%E9%81%85%E3%82%8C%E3%81%AA%E3%81%84%E3%81%9F%E3%82%81%E3%81%AE%E3%83%86%E3%82%AF%E3%83%8B%E3%82%AB%E3%83%AB%E3%82%AC%E3%82%A4%E3%83%89-NEXT-ONE\/dp\/4798147400\/ref=as_li_ss_il?ie=UTF8&amp;qid=1483415522&amp;sr=8-3&amp;keywords=MySQL&amp;linkCode=li2&amp;tag=typea09-22&amp;linkId=28b452185c1878f062d232b47378ad0e\" target=\"_blank\"><img decoding=\"async\" border=\"0\" src=\"\/\/ws-fe.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=4798147400&amp;Format=_SL160_&amp;ID=AsinImage&amp;MarketPlace=JP&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=typea09-22\" \/><\/a><img loading=\"lazy\" decoding=\"async\" style=\"border-top-style: none !important; border-left-style: none !important; border-bottom-style: none !important; border-right-style: none !important; margin: 0px\" border=\"0\" alt=\"\" src=\"https:\/\/ir-jp.amazon-adsystem.com\/e\/ir?t=typea09-22&amp;l=li2&amp;o=9&amp;a=4798147400\" width=\"1\" height=\"1\" \/><\/p>\n<h2>1.Yum \u30ea\u30dd\u30b8\u30c8\u30ea<\/h2>\n<h3>1.1 Yum \u30ea\u30dd\u30b8\u30c8\u30ea\u306e\u53d6\u5f97<\/h3>\n<p><a href=\"http:\/\/dev.mysql.com\/downloads\/repo\/yum\/\">Download MySQL Yum Repository<\/a> \u304b\u3089\u3001\u8a72\u5f53\u306e\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u63a2\u3059\u3002<\/p>\n<p><a href=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst01_2.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"mysql_inst01\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"mysql_inst01\" src=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst01_thumb.jpg\" width=\"402\" height=\"107\" \/><\/a><\/p>\n<p><a href=\"https:\/\/ja.wikipedia.org\/wiki\/CentOS\">RHEL \u3068 CentOS \u306e\u30e1\u30b8\u30e3\u30fc\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u308b<\/a>\u306e\u3067\u3001RHEL7\u306e\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u9078\u629e\u3057\u3001\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30dc\u30bf\u30f3\u3002<\/p>\n<p>\u9077\u79fb\u5148\u306e\u753b\u9762\u3067\u3001\u30ed\u30b0\u30a4\u30f3\u3092\u6c42\u3081\u3089\u308c\u308b\u304c\u3001\u5de6\u4e0b\u306b\u3001\u76f4\u63a5\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308bURL\u304c\u30ea\u30f3\u30af(No thanks just start my download) \u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001URL\u3092\u30b3\u30d4\u30fc\u3059\u308b\u3002<\/p>\n<p><a href=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst02_2.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"mysql_inst02\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"mysql_inst02\" src=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst02_thumb.jpg\" width=\"361\" height=\"241\" \/><\/a><\/p>\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5148\u306e\u30b5\u30fc\u30d0\u30fc\u306b\u63a5\u7d9a\u3057\u9069\u5f53\u306a\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u4e0a\u8a18URL\u304b\u3089wget\u3067\u30ea\u30dd\u30b8\u30c8\u30eaRPM\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/p>\n<pre class=\"prettyprint linenums\">$ wget <a href=\"http:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-9.noarch.rpm\">http:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-9.noarch.rpm<\/a><\/pre>\n<h3>1.2 Yum\u30ea\u30dd\u30b8\u30c8\u30ea\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<pre class=\"prettyprint linenums\">$ su\r\n\u30d1\u30b9\u30ef\u30fc\u30c9:\r\n# yum localinstall mysql57-community-release-el7-9.noarch.rpm<\/pre>\n<p><a href=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst03_2.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"mysql_inst03\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"mysql_inst03\" src=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst03_thumb.jpg\" width=\"452\" height=\"153\" \/><\/a><\/p>\n<p>MySQL Yum \u30ea\u30dd\u30b8\u30c8\u30ea\u306e\u3059\u3079\u3066\u306e\u30b5\u30d6\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u8868\u793a\u3057\u3001\u3069\u308c\u304c\u6709\u52b9\u3067\u3069\u308c\u304c\u7121\u52b9\u304b\u3092\u78ba\u8a8d\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u6700\u65b0GA\u304c\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\u3002<\/p>\n<pre class=\"prettyprint linenums\"># yum repolist all | grep mysql\r\nmysql-connectors-community\/x86_64 MySQL Connectors Community         \u6709\u52b9:    30\r\nmysql-connectors-community-source MySQL Connectors Community - Sourc \u7121\u52b9\r\nmysql-tools-community\/x86_64      MySQL Tools Community              \u6709\u52b9:    40\r\nmysql-tools-community-source      MySQL Tools Community - Source     \u7121\u52b9\r\nmysql-tools-preview\/x86_64        MySQL Tools Preview                \u7121\u52b9\r\nmysql-tools-preview-source        MySQL Tools Preview - Source       \u7121\u52b9\r\nmysql55-community\/x86_64          MySQL 5.5 Community Server         \u7121\u52b9\r\nmysql55-community-source          MySQL 5.5 Community Server - Sourc \u7121\u52b9\r\nmysql56-community\/x86_64          MySQL 5.6 Community Server         \u7121\u52b9\r\nmysql56-community-source          MySQL 5.6 Community Server - Sourc \u7121\u52b9\r\nmysql57-community\/x86_64          MySQL 5.7 Community Server         \u6709\u52b9:   164\r\nmysql57-community-source          MySQL 5.7 Community Server - Sourc \u7121\u52b9\r\nmysql80-community\/x86_64          MySQL 8.0 Community Server         \u7121\u52b9\r\nmysql80-community-source          MySQL 8.0 Community Server - Sourc \u7121\u52b9<\/pre>\n<ul>\n<li>\u6700\u65b0\u306e GA \u30b7\u30ea\u30fc\u30ba\u306e\u6700\u65b0\u306e\u30ea\u30ea\u30fc\u30b9\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5834\u5408\u306f\u3001\u69cb\u6210\u306f\u4e0d\u8981 <\/li>\n<li>\u6700\u65b0\u306e GA \u30b7\u30ea\u30fc\u30ba\u4ee5\u5916\u306e\u7279\u5b9a\u306e\u30b7\u30ea\u30fc\u30ba\u306e\u6700\u65b0\u30ea\u30ea\u30fc\u30b9\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u306b\u306f\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u524d\u306b\u3001\u6700\u65b0\u306e GA \u30b7\u30ea\u30fc\u30ba\u306e\u30b5\u30d6\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u7121\u52b9\u306b\u3057\u3001\u305d\u306e\u7279\u5b9a\u306e\u30b7\u30ea\u30fc\u30ba\u306e\u30b5\u30d6\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u6709\u52b9\u306b\u3059\u308b\u3002 <\/li>\n<li>\u4f7f\u7528\u3057\u3066\u3044\u308b\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067 yum-config-manager \u304c\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u767a\u884c\u3059\u308b\u3053\u3068\u3067\u5b9f\u884c\u53ef\u80fd <\/li>\n<\/ul>\n<pre class=\"prettyprint linenums\">$ sudo yum-config-manager --disable mysql56-community\r\n$ sudo yum-config-manager --enable mysql57-community-dmr<\/pre>\n<h2>2.MySQL\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n<h3>2.1 Yum\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<pre class=\"prettyprint linenums\"># yum install mysql-community-server<\/pre>\n<h3>2.2 MySQL\u306e\u8d77\u52d5<\/h3>\n<pre class=\"prettyprint linenums\"># systemctl start  mysqld.service<\/pre>\n<h3>2.3 \u63a5\u7d9a<\/h3>\n<h4>2.3.1 root \u30d1\u30b9\u30ef\u30fc\u30c9<\/h4>\n<p>root \u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u5206\u304b\u3089\u306a\u3044\u30025.6 \u306e\u3068\u304d\u306f\u3001\/root\/.mysql_secret \u306b\u51fa\u529b\u3055\u308c\u3066\u3044\u305f\u304c\u3001\u5b58\u5728\u3057\u3066\u3044\u306a\u3044\u3002<\/p>\n<pre class=\"prettyprint linenums\">[root@localhost ~]# mysql -u root -p\r\nEnter password:\r\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)<\/pre>\n<p><a href=\"http:\/\/qiita.com\/okuzawats\/items\/d3cd9f8aca7262715629\">MySQL 5.7\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3089\u51fa\u3066\u304d\u305fERROR 1045 (28000)\u306e\u5bfe\u51e6\u6cd5<\/a><\/p>\n<p>\u30ed\u30b0\u306b\u51fa\u529b\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u3060\u3002\u30d1\u30b9\u30ef\u30fc\u30c9\u90e8\u5206\u3092\u30b3\u30d4\u30fc\u3057\u3066\u30ed\u30b0\u30a4\u30f3<\/p>\n<pre class=\"prettyprint linenums\">[root@localhost ~]# cat \/var\/log\/mysqld.log | grep 'password is generated'\r\n2017-01-02T14:16:14.031813Z 1 [Note] A temporary password is generated for root@localhost: eOq=?fDX5kyy<\/pre>\n<p><a href=\"http:\/\/qiita.com\/RyochanUedasan\/items\/9a49309019475536d22a\">mysql5.7\u3067\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5909\u66f4\u3059\u308b<\/a><\/p>\n<blockquote>\n<p>validate_password_policy\u306e\u521d\u671f\u5024\u306fMEDIUM\u3067\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a\u306b\u5fc5\u8981\u306a\u6761\u4ef6\u306f<br \/>\n    <br \/>MEDIUM \u30dd\u30ea\u30b7\u30fc\u306f\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u6700\u4f4e 1 \u3064\u306e\u6570\u5024\u6587\u5b57\u3092\u542b\u307f\u30011 \u3064\u306e\u5c0f\u6587\u5b57\u304a\u3088\u3073\u5927\u6587\u5b57\u3092\u542b\u307f\u30011 \u3064\u306e\u7279\u6b8a\u6587\u5b57 (\u82f1\u6570\u5b57\u4ee5\u5916) \u3092\u542b\u3080\u5fc5\u8981\u304c\u3042\u308b\u3068\u3044\u3046\u6761\u4ef6\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n<\/blockquote>\n<pre class=\"prettyprint linenums\">mysql&gt; set password for root@localhost=password('Password@123');\r\nQuery OK, 0 rows affected, 1 warning (0.00 sec)<\/pre>\n<h4>2.3.2 \u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u8a2d\u5b9a<\/h4>\n<p>mysql_secure_installation \u3092\u5b9f\u884c\u3057\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30fc\u30dd\u30ea\u30b7\u30fc\u3092\u8a2d\u5b9a<\/p>\n<pre class=\"prettyprint linenums\">[root@localhost ~]# mysql_secure_installation\r\n\r\nSecuring the MySQL server deployment.\r\n\r\nEnter password for user root:\r\nThe 'validate_password' plugin is installed on the server.\r\nThe subsequent steps will run with the existing configuration\r\nof the plugin.\r\nUsing existing password for root.\r\n\r\nEstimated strength of the password: 100\r\nChange the password for root ? ((Press y|Y for Yes, any other key for No) :\r\n\r\n ... skipping.\r\nBy default, a MySQL installation has an anonymous user,\r\nallowing anyone to log into MySQL without having to have\r\na user account created for them. This is intended only for\r\ntesting, and to make the installation go a bit smoother.\r\nYou should remove them before moving into a production\r\nenvironment.\r\n\r\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : y\r\nSuccess.\r\n\r\n\r\nNormally, root should only be allowed to connect from\r\n'localhost'. This ensures that someone cannot guess at\r\nthe root password from the network.\r\n\r\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) :\r\n\r\n ... skipping.\r\nBy default, MySQL comes with a database named 'test' that\r\nanyone can access. This is also intended only for testing,\r\nand should be removed before moving into a production\r\nenvironment.\r\n\r\n\r\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) :\r\n\r\n ... skipping.\r\nReloading the privilege tables will ensure that all changes\r\nmade so far will take effect immediately.\r\n\r\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y\r\nSuccess.\r\n\r\nAll done!<\/pre>\n<h4>2.3.3 CentOS \u30d5\u30a1\u30a4\u30a2\u30fc\u30a6\u30a9\u30fc\u30eb\u8a2d\u5b9a<\/h4>\n<p>\u5916\u90e8\u304b\u3089\u63a5\u7d9a\u3067\u304d\u306a\u3044\u306e\u3067\u30013306\u30dd\u30fc\u30c8\u3092\u958b\u3051\u308b<\/p>\n<pre class=\"prettyprint linenums\"># firewall-cmd --permanent --zone=public --add-port=3306\/tcp\r\nsuccess\r\n# firewall-cmd --reload\r\nsuccess<\/pre>\n<h4>2.3.4 \u5225PC\u306e MySQL Workbench \u304b\u3089\u63a5\u7d9a<\/h4>\n<p>\u63a5\u7d9a\u5148\u30db\u30b9\u30c8\u304c\u8a31\u53ef\u3055\u308c\u3066\u3044\u306a\u3044\u3002<\/p>\n<p><a href=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst04_2.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"mysql_inst04\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"mysql_inst04\" src=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst04_thumb.jpg\" width=\"310\" height=\"158\" \/><\/a><\/p>\n<p>\u30a2\u30af\u30bb\u30b9\u62d2\u5426\u306e\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c8<\/p>\n<p><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.6\/ja\/connection-access.html\">\u30a2\u30af\u30bb\u30b9\u5236\u5fa1\u3001\u30b9\u30c6\u30fc\u30b8 1: \u63a5\u7d9a\u306e\u691c\u8a3c<\/a><\/p>\n<blockquote>\n<p>ID \u30c1\u30a7\u30c3\u30af\u306f\u3001<code>user<\/code> \u30c6\u30fc\u30d6\u30eb\u306e 3 \u3064\u306e\u30b9\u30b3\u30fc\u30d7\u30ab\u30e9\u30e0 (<code>Host<\/code>\u3001<code>User<\/code>\u3001<code>Password<\/code>) \u3092\u4f7f\u7528\u3057\u3066\u5b9f\u65bd\u3055\u308c\u307e\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u306f\u3001\u4e00\u90e8\u306e <code>user<\/code> \u30c6\u30fc\u30d6\u30eb\u884c\u306e <code>Host<\/code> \u304a\u3088\u3073 <code>User<\/code> \u30ab\u30e9\u30e0\u304c\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30db\u30b9\u30c8\u540d\u304a\u3088\u3073\u30e6\u30fc\u30b6\u30fc\u540d\u3068\u4e00\u81f4\u3057\u3001\u305d\u306e\u884c\u306b\u6307\u5b9a\u3055\u308c\u3066\u3044\u308b\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304b\u3089\u63d0\u4f9b\u3055\u308c\u305f\u5834\u5408\u306e\u307f\u3001\u63a5\u7d9a\u3092\u53d7\u3051\u5165\u308c\u307e\u3059\u3002\u8a31\u5bb9\u53ef\u80fd\u306a <code>Host<\/code>\u304a\u3088\u3073 <code>User<\/code> \u5024\u306b\u3064\u3044\u3066\u306e\u30eb\u30fc\u30eb\u306f\u3001<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.6\/ja\/account-names.html\">\u30bb\u30af\u30b7\u30e7\u30f36.2.3\u300c\u30a2\u30ab\u30a6\u30f3\u30c8\u540d\u306e\u6307\u5b9a\u300d<\/a>\u306b\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/blockquote>\n<p>\u4efb\u610f\u306e\u30db\u30b9\u30c8\u304b\u3089\u63a5\u7d9a\u3067\u304d\u308b\u3001app \u30e6\u30fc\u30b6\u30fc \u3092\u4f5c\u6210\u3002<\/p>\n<p>\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u5fc5\u9808\u304b\u3064\u3001\u82f1\u5927\u6587\u5b57\u3001\u5c0f\u6587\u5b57\u3001\u6570\u5b57\u3001\u8a18\u53f7\u3092\u542b\u3080\u30d1\u30b9\u30ef\u30fc\u30c9\u3057\u304b\u53d7\u3051\u4ed8\u3051\u3066\u304f\u308c\u306a\u3044\u3002<\/p>\n<pre class=\"prettyprint linenums\">mysql&gt; use mysql\r\nReading table information for 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\nmysql&gt; create user 'app'@'%';\r\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements\r\nmysql&gt; create user 'app'@'%' identified by '*****';\r\nQuery OK, 0 rows affected (0.02 sec)\r\nmysql&gt; select user,host from user;\r\n+-----------+-----------+\r\n| user      | host      |\r\n+-----------+-----------+\r\n| app       | %         |\r\n| mysql.sys | localhost |\r\n| root      | localhost |\r\n+-----------+-----------+\r\n3 rows in set (0.00 sec)<\/pre>\n<p>\u63a5\u7d9a\u6210\u529f<\/p>\n<p><a href=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst05_2.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"mysql_inst05\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"mysql_inst05\" src=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst05_thumb.jpg\" width=\"321\" height=\"244\" \/><\/a><\/p>\n<h4>2.3.5 \u30e6\u30fc\u30b6\u30fc\u306b\u6a29\u9650\u4ed8\u4e0e<\/h4>\n<p>\u7ba1\u7406\u8005\u6a29\u9650\u3092\u4ed8\u4e0e\u3057\u3066\u3001Workbench\u304b\u3089\u63a5\u7d9a<\/p>\n<pre class=\"prettyprint linenums\">mysql&gt; grant all privileges on *.* to 'root'@'%' identified by '********' with grant option;\r\nQuery OK, 0 rows affected, 1 warning (0.00 sec)<\/pre>\n<p><a href=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst06_4.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"mysql_inst06\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"mysql_inst06\" src=\"http:\/\/typea.info\/blg\/glob\/Windows-Live-Writer\/MySQL_13ED6\/mysql_inst06_thumb_1.jpg\" width=\"366\" height=\"214\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.amazon.co.jp\/%E5%AE%9F%E8%B7%B5%E3%83%8F%E3%82%A4%E3%83%91%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%B3%E3%82%B9MySQL-%E7%AC%AC3%E7%89%88-Baron-Schwartz\/dp\/4873116384\/ref=as_li_ss_il?ie=UTF8&amp;qid=1483415522&amp;sr=8-9&amp;keywords=MySQL&amp;linkCode=li2&amp;tag=typea09-22&amp;linkId=d3fa7428dac923a0fea70385c1a5ef1c\" target=\"_blank\"><img decoding=\"async\" border=\"0\" src=\"\/\/ws-fe.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=4873116384&amp;Format=_SL160_&amp;ID=AsinImage&amp;MarketPlace=JP&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=typea09-22\" \/><\/a><img loading=\"lazy\" decoding=\"async\" style=\"border-top-style: none !important; border-left-style: none !important; border-bottom-style: none !important; border-right-style: none !important; margin: 0px\" border=\"0\" alt=\"\" src=\"https:\/\/ir-jp.amazon-adsystem.com\/e\/ir?t=typea09-22&amp;l=li2&amp;o=9&amp;a=4873116384\" width=\"1\" height=\"1\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Yum \u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u4f7f\u7528\u3057\u3066 MySQL \u3092 Linux \u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3092\u53c2\u8003\u306b\u3057\u306a\u304c\u3089\u3001CentOS7\u306b Yum \u3092\u5229\u7528\u3057\u3066MySQL\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u884c\u3046\u3002 1.Yum \u30ea\u30dd\u30b8\u30c8\u30ea 1.1 Yum \u30ea\u30dd [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","_veu_custom_css":"","veu_display_promotion_alert":"","vkexunit_cta_each_option":"","footnotes":""},"categories":[64,59],"tags":[],"class_list":["post-494","post","type-post","status-publish","format-standard","hentry","category-centos","category-mysql"],"veu_head_title_object":{"title":"","add_site_title":""},"_links":{"self":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts\/494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=494"}],"version-history":[{"count":0,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts\/494\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}