{"id":1883,"date":"2017-02-28T20:54:08","date_gmt":"2017-02-28T12:54:08","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=1883"},"modified":"2017-02-28T20:54:08","modified_gmt":"2017-02-28T12:54:08","slug":"centos7%e5%ae%89%e8%a3%85mysql5-6-28%e5%8f%8a%e5%85%b6%e4%bf%ae%e6%94%b9%e5%af%86%e7%a0%81","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/centos7%e5%ae%89%e8%a3%85mysql5-6-28%e5%8f%8a%e5%85%b6%e4%bf%ae%e6%94%b9%e5%af%86%e7%a0%81\/","title":{"rendered":"CentOS7\u5b89\u88c5MySQL5.6.28\u53ca\u5176\u4fee\u6539\u5bc6\u7801"},"content":{"rendered":"<p>\u7cfb\u7edf\u662fCentOS7-1604-mini\u6700\u5c0f\u5316\u5b89\u88c5\u7248<br \/>\n1.\u5b89\u88c5\u4f9d\u8d56\u4ee5\u53ca\u5220\u9664mariadb\u7684lib\u5e93\u9ed8\u8ba4\u662f\u81ea\u5e26\u7684<\/p>\n<pre class=\"prettyprint\"><code class=\"hljs cmake has-numbering\">yum <span class=\"hljs-keyword\">install<\/span> -y wget libaio\r\nyum <span class=\"hljs-keyword\">remove<\/span>  mariadb*<\/code><\/pre>\n<p>2.\u4e0b\u8f7dMySQL RPM\u5305<\/p>\n<pre class=\"prettyprint\"><code class=\"hljs avrasm has-numbering\">cd \/tmp\/ &amp;&amp; wget -c https:\/\/downloads<span class=\"hljs-preprocessor\">.mysql<\/span><span class=\"hljs-preprocessor\">.com<\/span>\/archives\/get\/file\/MySQL-<span class=\"hljs-number\">5.6<\/span><span class=\"hljs-number\">.28<\/span>-<span class=\"hljs-number\">1.<\/span>linux_glibc2<span class=\"hljs-number\">.5<\/span><span class=\"hljs-preprocessor\">.x<\/span>86_64<span class=\"hljs-preprocessor\">.rpm<\/span>-bundle<span class=\"hljs-preprocessor\">.tar<\/span><\/code><\/pre>\n<p>3.\u89e3\u538btar\u5305<\/p>\n<pre class=\"prettyprint\"><code class=\"hljs avrasm has-numbering\">cd \/tmp\/ &amp;&amp; tar -xvf MySQL-<span class=\"hljs-number\">5.6<\/span><span class=\"hljs-number\">.28<\/span>-<span class=\"hljs-number\">1.<\/span>linux_glibc2<span class=\"hljs-number\">.5<\/span><span class=\"hljs-preprocessor\">.x<\/span>86_64<span class=\"hljs-preprocessor\">.rpm<\/span>-bundle<span class=\"hljs-preprocessor\">.tar<\/span> \r\nrm -rf \/tmp\/MySQL-<span class=\"hljs-number\">5.6<\/span><span class=\"hljs-number\">.28<\/span>-<span class=\"hljs-number\">1.<\/span>linux_glibc2<span class=\"hljs-number\">.5<\/span><span class=\"hljs-preprocessor\">.x<\/span>86_64<span class=\"hljs-preprocessor\">.rpm<\/span>-bundle<span class=\"hljs-preprocessor\">.tar<\/span><\/code><\/pre>\n<p>4.\u5b89\u88c5\u76f8\u5173\u7684\u8f6f\u4ef6<\/p>\n<pre class=\"prettyprint\"><code class=\"hljs bash has-numbering\"><span class=\"hljs-built_in\">cd<\/span> \/tmp\/ &amp;&amp; rpm -ivh MySQL*<\/code><\/pre>\n<p>5.\u542f\u52a8<\/p>\n<pre class=\"prettyprint\"><code class=\"hljs bash has-numbering\">systemctl enable mysql <span class=\"hljs-comment\">#\u5f00\u673a\u81ea\u542f\u52a8<\/span>\r\nsystemctl start mysql  <span class=\"hljs-comment\">#\u542f\u52a8mysql<\/span><\/code><\/pre>\n<p>6.\u4fee\u6539\u5bc6\u7801mysql\u5728\u5b89\u88c5\u7684\u65f6\u5019\uff0c\u4e3a\u4e86\u5b89\u5168\u9ed8\u8ba4\u4f1a\u751f\u6210\u968f\u673a\u5bc6\u7801\u4f4d\u7f6e\u5728 \/root\/.mysql_secret\u00a0 \u5982\u4e0b\u9762\u7684\u6587\u4ef6<\/p>\n<pre class=\"prettyprint\"><code class=\"hljs sql has-numbering\">[root@izltf35j605nncz user]# cat \/root\/.mysql_secret\r\n# The random password <span class=\"hljs-operator\"><span class=\"hljs-keyword\">set<\/span> <span class=\"hljs-keyword\">for<\/span> the root <span class=\"hljs-keyword\">user<\/span> <span class=\"hljs-keyword\">at<\/span> Sat Feb <span class=\"hljs-number\">25<\/span> <span class=\"hljs-number\">14<\/span>:<span class=\"hljs-number\">50<\/span>:<span class=\"hljs-number\">11<\/span> <span class=\"hljs-number\">2017<\/span> (<span class=\"hljs-keyword\">local<\/span> <span class=\"hljs-keyword\">time<\/span>): TjMBpQi0UeNWjUev<\/span><\/code><\/pre>\n<p>7.\u4fee\u6539\u5bc6\u7801\u00a0 \u4fee\u6539\u5bc6\u7801\u6709\u51e0\u79cd\u65b9\u5f0f\u00a0 \u9996\u5148\u67e5\u770b\u539f\u6709\u7684\u914d\u7f6e\u00a0 mysql&gt; select host,user,password from mysql.user;<\/p>\n<table>\n<thead>\n<tr>\n<th>host<\/th>\n<th>user<\/th>\n<th>password<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>localhost<\/td>\n<td>root<\/td>\n<td>*4F5D16242740A35AC75396074A16FCA85E733DDE<\/td>\n<\/tr>\n<tr>\n<td>izltf35j605nncz<\/td>\n<td>root<\/td>\n<td>*4F5D16242740A35AC75396074A16FCA85E733DDE<\/td>\n<\/tr>\n<tr>\n<td>127.0.0.1<\/td>\n<td>root<\/td>\n<td>*4F5D16242740A35AC75396074A16FCA85E733DDE<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>sakila<\/td>\n<td>*94099046963A7BE31E0443DC095E0657EB47EA94<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>test<\/td>\n<td>*A1774F61D244D786BB7AF496A710B809508AE6B2<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>root<\/td>\n<td>*A1774F61D244D786BB7AF496A710B809508AE6B2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>6 rows in set (0.00 sec)<\/p>\n<p>1.\u4f7f\u7528set password for \u2018\u7528\u6237\u540d\u2019@\u2019\u4e3b\u673a\u540d\u2019=password(\u2018\u5bc6\u7801\u2019)\uff1b<\/p>\n<pre class=\"prettyprint\"><code class=\"hljs bash has-numbering\"><span class=\"hljs-keyword\">set<\/span> password <span class=\"hljs-keyword\">for<\/span> <span class=\"hljs-string\">'root'<\/span>@<span class=\"hljs-string\">'localhost'<\/span>=password(<span class=\"hljs-string\">'123456'<\/span>)<\/code><\/pre>\n<p>mysql&gt; select host,user,password from mysql.user;<\/p>\n<table>\n<thead>\n<tr>\n<th>host<\/th>\n<th>user<\/th>\n<th>password<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>localhost<\/td>\n<td>root<\/td>\n<td>*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9<\/td>\n<\/tr>\n<tr>\n<td>izltf35j605nncz<\/td>\n<td>root<\/td>\n<td>*4F5D16242740A35AC75396074A16FCA85E733DDE<\/td>\n<\/tr>\n<tr>\n<td>127.0.0.1<\/td>\n<td>root<\/td>\n<td>*4F5D16242740A35AC75396074A16FCA85E733DDE<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>sakila<\/td>\n<td>*94099046963A7BE31E0443DC095E0657EB47EA94<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>test<\/td>\n<td>*A1774F61D244D786BB7AF496A710B809508AE6B2<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>root<\/td>\n<td>*A1774F61D244D786BB7AF496A710B809508AE6B2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>6 rows in set (0.00 sec)<\/p>\n<p>2.\u4f7f\u7528update\u4fee\u6539 update mysql.user set password=password(\u2018123456\u2019) where user=\u2019root\u2019;<\/p>\n<pre class=\"prettyprint\"><code class=\"hljs sql has-numbering\"><span class=\"hljs-operator\"><span class=\"hljs-keyword\">update<\/span> mysql.<span class=\"hljs-keyword\">user<\/span> <span class=\"hljs-keyword\">set<\/span> password=password(<span class=\"hljs-string\">'123456'<\/span>) <span class=\"hljs-keyword\">where<\/span> <span class=\"hljs-keyword\">user<\/span>=<span class=\"hljs-string\">'root'<\/span>;<\/span><\/code><\/pre>\n<p>mysql&gt; select host,user,password from mysql.user;<\/p>\n<table>\n<thead>\n<tr>\n<th>host<\/th>\n<th>user<\/th>\n<th>password<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>localhost<\/td>\n<td>root<\/td>\n<td>*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9<\/td>\n<\/tr>\n<tr>\n<td>izltf35j605nncz<\/td>\n<td>root<\/td>\n<td>*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9<\/td>\n<\/tr>\n<tr>\n<td>127.0.0.1<\/td>\n<td>root<\/td>\n<td>*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>sakila<\/td>\n<td>*94099046963A7BE31E0443DC095E0657EB47EA94<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>test<\/td>\n<td>*A1774F61D244D786BB7AF496A710B809508AE6B2<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>root<\/td>\n<td>*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>6 rows in set (0.00 sec)<\/p>\n<p>3.\u4f7f\u7528grant all privileges on sakila.* to \u2018sakila\u2019@\u2019%\u2019 identified by \u2018123456\u2019;\u4fee\u6539.\u8bbe\u7f6e\u8fdc\u7a0b\u8bbf\u95ee<\/p>\n<pre class=\"prettyprint\"><code class=\"hljs sql has-numbering\"><span class=\"hljs-operator\"><span class=\"hljs-keyword\">grant<\/span> <span class=\"hljs-keyword\">all<\/span> <span class=\"hljs-keyword\">privileges<\/span> <span class=\"hljs-keyword\">on<\/span> sakila.* <span class=\"hljs-keyword\">to<\/span> <span class=\"hljs-string\">'sakila'<\/span>@<span class=\"hljs-string\">'%'<\/span> identified <span class=\"hljs-keyword\">by<\/span> <span class=\"hljs-string\">'123456'<\/span>;<\/span><\/code><\/pre>\n<p>mysql&gt; select host,user,password from mysql.user;<\/p>\n<table>\n<thead>\n<tr>\n<th>host<\/th>\n<th>user<\/th>\n<th>password<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>localhost<\/td>\n<td>root<\/td>\n<td>*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9<\/td>\n<\/tr>\n<tr>\n<td>izltf35j605nncz<\/td>\n<td>root<\/td>\n<td>*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9<\/td>\n<\/tr>\n<tr>\n<td>127.0.0.1<\/td>\n<td>root<\/td>\n<td>*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>sakila<\/td>\n<td>*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>test<\/td>\n<td>*A1774F61D244D786BB7AF496A710B809508AE6B2<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>root<\/td>\n<td>*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>6 rows in set (0.00 sec)<\/p>\n<p>\u6ce8\u610f\uff1a\u521d\u6b21\u5b89\u88c5\u8bbe\u7f6e\u5bc6\u7801\u65f6\u5019\u4e00\u5b9a\u8981\u4f7f\u7528update\u4fee\u6539\u5bc6\u7801\uff0c\u66f4\u6539root\u5bc6\u7801\u3002\u8fd9\u6837\u4f7f\u7528localhost\u6216\u8005127.0.0.1\u65f6\u5019\u5bc6\u7801\u90fd\u4e00\u6837\u3002\u5426\u5219\u5f88\u6709\u53ef\u80fd\u4e0d\u4e00\u6837\uff0c\u5bfc\u81f4\u4e0d\u80fd\u4f7f\u7528\uff0c\u5982\u679c\u6570\u636e\u5e93\u670d\u52a1\u5668\u548cweb\u7b49\u5728\u4e00\u4e2a\u670d\u52a1\u5668\u7684\u65f6\u5019\uff0c\u5c3d\u91cf\u4f7f\u7528localhost\u3002\u5728linux\u4e0bmysql\u4f7f\u7528localhost\u7684\u65f6\u5019\u4f7f\u7528\u7684\u662funix\u5957\u63a5\u5b57\uff0c\u800c\u5176\u4ed6\u4f7f\u7528\u7684\u662ftcp\/ip\u534f\u8bae\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u539f\u6587\u94fe\u63a5\uff1ahttps:\/\/www.centoscn.com\/mysql\/2017\/0228\/8553.html<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7cfb\u7edf\u662fCentOS7-1604-mini\u6700\u5c0f\u5316\u5b89\u88c5\u7248 1.\u5b89\u88c5\u4f9d\u8d56\u4ee5\u53ca\u5220\u9664mariadb\u7684lib\u5e93\u9ed8\u8ba4\u662f\u81ea\u5e26\u7684 &#8230; <a title=\"CentOS7\u5b89\u88c5MySQL5.6.28\u53ca\u5176\u4fee\u6539\u5bc6\u7801\" class=\"read-more\" href=\"https:\/\/cn.hostease.com\/xueyuan\/jishu\/centos7%e5%ae%89%e8%a3%85mysql5-6-28%e5%8f%8a%e5%85%b6%e4%bf%ae%e6%94%b9%e5%af%86%e7%a0%81\/\" aria-label=\"\u9605\u8bfb CentOS7\u5b89\u88c5MySQL5.6.28\u53ca\u5176\u4fee\u6539\u5bc6\u7801\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[49,5,10],"tags":[495,45],"class_list":["post-1883","post","type-post","status-publish","format-standard","hentry","category-linux","category-jishu","category-shujuku","tag-centos7-x","tag-mysql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=1883"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1883\/revisions"}],"predecessor-version":[{"id":1884,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1883\/revisions\/1884"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=1883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=1883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=1883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}