{"id":521,"date":"2021-01-16T06:49:09","date_gmt":"2021-01-16T06:49:09","guid":{"rendered":"http:\/\/blog.caincity.com\/?p=521"},"modified":"2021-01-16T07:20:22","modified_gmt":"2021-01-16T07:20:22","slug":"%e5%ae%89%e8%a3%85mysql","status":"publish","type":"post","link":"http:\/\/blog.caincity.com\/?p=521","title":{"rendered":"\u4e91\u670d\u52a1\u5668\u521d\u59cb\u5316   \u7b2c\u4e94\u7ae0\uff1a\u5b89\u88c5MySQL"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">\u4e00\u3001\u67e5\u770b\u7248\u672c<\/h4>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">mysqld -v<\/p>\n\n\n\n<p>\u663e\u793a\u201c-bash: mysqld: \u672a\u627e\u5230\u547d\u4ee4\u201d\u8868\u793a\u672a\u5b89\u88c5<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e8c\u3001\u5b89\u88c5mysql<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">1\u3001\u5b89\u88c5Yum Repository<\/h5>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">wget https:\/\/repo.mysql.com\/\/mysql80-community-release-el8-1.noarch.rpm<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">2\u3001\u4f7f\u7528rpm\u6765\u5b89\u88c5MySQL<\/h5>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">rpm -ivh mysql80-community-release-el8-1.noarch.rpm<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">3\u3001\u5b89\u88c5mysql<\/h5>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">yum -y install mysql-server<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e09\u3001\u542f\u52a8\u670d\u52a1<\/h4>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">systemctl start mysqld.service<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u56db\u3001\u5f00\u673a\u542f\u52a8<\/h4>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">systemctl enable mysqld.service<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e94\u3001\u521d\u59cb\u5316mysql<\/h4>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">mysql_secure_installation<\/p>\n\n\n\n<p>\u56de\u8f66<br>\u8bbe\u7f6e\u5bc6\u7801<br>\u786e\u8ba4\u5bc6\u7801<br>y<br>y<br>y<br>y<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u516d\u3001\u521b\u5efa\u8fdc\u7a0b\u7528\u6237<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">1\u3001\u8fdb\u5165mysql<\/h5>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">mysql -u root -p<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">2\u3001\u521b\u5efa\u7528\u6237<\/h5>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">create user &#8216;snakeyi&#8217;@&#8217;%&#8217; identified by &#8216;12345678&#8217;;<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">3\u3001\u7528\u6237\u6388\u6743<\/h5>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">grant all privileges on <em>.<\/em> to &#8216;snakeyi&#8217;@&#8217;%&#8217; with grant option;<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">4\u3001\u5237\u65b0\u7cfb\u7edf\u6743\u9650<\/h5>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">flush privileges;<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">5\u3001\u5176\u5b83\u547d\u4ee4<\/h5>\n\n\n\n<h5 class=\"wp-block-heading\">\u2460\u3001\u67e5\u770bMYSQL\u6570\u636e\u5e93\u4e2d\u6240\u6709\u7528\u6237<\/h5>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">SELECT DISTINCT CONCAT(&#8216;User: &#8221;&#8217;,user,&#8221;&#8217;@&#8221;&#8217;,host,&#8221;&#8217;;&#8217;) AS query FROM mysql.user;<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">\u2461\u3001\u67e5\u770b\u6570\u636e\u5e93\u4e2d\u5177\u4f53\u67d0\u4e2a\u7528\u6237\u7684\u6743\u9650<\/h5>\n\n\n\n<p class=\"has-text-color has-background has-very-light-gray-color has-very-dark-gray-background-color\">show grants for &#8216;snakeyi&#8217;@&#8217;%&#8217;;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5e38\u7528\u547d\u4ee4<\/h4>\n\n\n\n<p>\u670d\u52a1\u72b6\u6001\uff1asystemctl status mysqld.service<br>\u542f\u52a8\u670d\u52a1\uff1asystemctl start mysqld.service<br>\u505c\u6b62\u670d\u52a1\uff1asystemctl stop mysqld.service<br>\u91cd\u542f\u670d\u52a1\uff1asystemctl restart mysqld.service<br>\u5f00\u673a\u542f\u52a8\uff1asystemctl enable mysqld.service<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5b89\u88c5MySQL<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[27],"tags":[36,29,31],"_links":{"self":[{"href":"http:\/\/blog.caincity.com\/index.php?rest_route=\/wp\/v2\/posts\/521"}],"collection":[{"href":"http:\/\/blog.caincity.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.caincity.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.caincity.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.caincity.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=521"}],"version-history":[{"count":3,"href":"http:\/\/blog.caincity.com\/index.php?rest_route=\/wp\/v2\/posts\/521\/revisions"}],"predecessor-version":[{"id":542,"href":"http:\/\/blog.caincity.com\/index.php?rest_route=\/wp\/v2\/posts\/521\/revisions\/542"}],"wp:attachment":[{"href":"http:\/\/blog.caincity.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.caincity.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=521"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.caincity.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}