{"id":1820,"date":"2017-02-24T10:04:32","date_gmt":"2017-02-24T02:04:32","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=1820"},"modified":"2017-02-24T10:04:32","modified_gmt":"2017-02-24T02:04:32","slug":"centos7-rpm%e6%96%b9%e5%bc%8f%e5%ae%89%e8%a3%85mysql5-7-%e8%af%a6%e7%bb%86%e6%95%99%e7%a8%8b","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/centos7-rpm%e6%96%b9%e5%bc%8f%e5%ae%89%e8%a3%85mysql5-7-%e8%af%a6%e7%bb%86%e6%95%99%e7%a8%8b\/","title":{"rendered":"centos7 rpm\u65b9\u5f0f\u5b89\u88c5mysql5.7 \u8be6\u7ec6\u6559\u7a0b"},"content":{"rendered":"

\u7b2c\u4e00\u6b65\uff1a\u4e0b\u8f7dmysql<\/h3>\n

\u5728Linux\u7ec8\u7aef\u4f7f\u7528wget\u547d\u4ee4\u4e0b\u8f7d\u7f51\u7edc\u8d44\u6e90\uff1a<\/p>\n

wget https:\/\/mirrors.sohu<\/span>.com<\/span>\/mysql\/MySQL-5.7<\/span>\/mysql-5.7<\/span>.17<\/span>-linux-glibc2.5<\/span>-x86_64.tar<\/span>.gz<\/span><\/code><\/pre>\n
1:\u68c0\u67e5\u662f\u5426\u672c\u5730\u5df2\u7ecf\u5b89\u88c5\u4e86MySQL<\/p>\n
rpm -qa | grep mysql<\/span><\/code><\/pre>\n
2:\u5378\u8f7d\u4ee5\u524d\u7684mysql<\/p>\n
rpm -e<\/span> \u5df2\u7ecf\u5b58\u5728\u7684MySQL\u5168\u540d<\/code><\/pre>\n
\u7b2c\u4e8c\u6b65\uff1a\u89e3\u538b\u6587\u4ef6<\/h3>\n
\u63a5\u4e0b\u6765\u53bb\u5230\u79fb\u52a8\u540e\u7684\u76ee\u5f55cd \/usr\/local<\/code>\u00a0\uff0c\u7136\u540e\u89e3\u538b<\/p>\n
tar zxvf mysql-<\/span>5.7<\/span>.17<\/span>-linux<\/span>-glibc2<\/span>.5<\/span>-x86_64<\/span>.<\/span>tar<\/code><\/pre>\n
\u89e3\u538b\u540e\u4e3a\u4e86\u65b9\u4fbf\u540e\u9762\u64cd\u4f5c\u53ef\u628a\u89e3\u538b\u540e\u6587\u4ef6\u540d\u4fee\u6539\u4e3amysql\uff1a<\/p>\n
mv mysql-<\/span>5.7<\/span>.17<\/span>-linux<\/span>-glibc2<\/span>.5<\/span>-x86_64<\/span> mysql<\/code><\/pre>\n
\u7b2c\u4e09\u6b65\uff1a\u914d\u7f6e\u542f\u52a8\u6587\u4ef6<\/h3>\n
\u7136\u540e\u53bb\u5230\u00a0mysql<\/code>\u00a0\u7684\u00a0support-files<\/code>\u76ee\u5f55\u4e0b<\/p>\n
1\u3001\u590d\u5236my.cnf<\/code>\u00a0\u5230\u00a0\/etc\/my.cnf<\/code>\u00a0(mysqld\u542f\u52a8\u65f6\u81ea\u52a8\u8bfb\u53d6)<\/h4>\n
cp<\/span> my-default.cnf<\/span> \/etc\/my.cnf<\/span><\/code><\/pre>\n
\u6ce8\u610f\uff1a\u5982\u679c\u4f60\u5728\u5b89\u88c5\u65f6Linux\u865a\u62df\u673a\u65f6\u540c\u65f6\u5b89\u88c5\u4e86\u9ed8\u8ba4\u7684mysql\uff0c\u6b64\u65f6\u64cd\u4f5c\u4ee5\u4e0a\u6b65\u9aa4\uff0c\u7ec8\u7aef\u5c06\u4f1a\u63d0\u793a\u4f60\u6587\u4ef6\u5df2\u5b58\u5728\u662f\u5426\u8986\u76d6\uff0c\u8f93\u5165yes\u8986\u76d6\u5373\u53ef\u3002<\/p><\/blockquote>\n
2\u3001\u914d\u7f6e\u6570\u636e\u5e93\u7f16\u7801<\/h4>\n
vi \/etc\/my<\/span>.cnf<\/code><\/pre>\n
\u5728\u8fd9\u4efd\u6587\u4ef6\u4e2d\u53ef\u4ee5\u6dfb\u52a0\u4ee5\u4e0b\u914d\u7f6e\u4fe1\u606f(\u5982\u679c\u6709\u4fee\u6539\u5373\u53ef)<\/p>\n
[mysql]<\/span>\r\ndefault-character-set=utf8<\/span><\/span>\r\n\r\n[mysqld]<\/span>\r\ndefault-storage-engine=INNODB<\/span><\/span>\r\ncharacter_set_server=utf8<\/span><\/span><\/code><\/pre>\n
3\u3001\u590d\u5236mysql.server<\/code>\u5230\/etc\/init.d\/<\/code>\u00a0\u76ee\u5f55\u4e0b\u3010\u76ee\u7684\u60f3\u5b9e\u73b0\u5f00\u673a\u81ea\u52a8\u6267\u884c\u6548\u679c\u3011<\/h4>\n
\u6267\u884c\u547d\u4ee4\uff08mysql\u662f\u670d\u52a1\u540d\uff09\uff1a<\/p>\n
cp<\/span> mysql.server<\/span> \/etc\/init.d<\/span>\/mysql <\/code><\/pre>\n
4\u3001\u4fee\u6539\u00a0\/etc\/init.d\/mysql<\/code>\u53c2\u6570<\/h4>\n
vi \/etc\/init.d<\/span>\/mysql<\/code><\/pre>\n
\u7ed9\u4e0e2\u4e2a\u76ee\u5f55\u4f4d\u7f6e<\/p>\n
basedir=<\/span>\/usr\/local<\/span>\/mysql\r\ndatadir=<\/span>\/usr\/local<\/span>\/mysql\/data<\/span><\/code><\/pre>\n
5\u3001\u51fa\u4e8e\u5b89\u5168\u4fbf\u5229\uff0c\u521b\u5efa\u4e00\u4e2a\u64cd\u4f5c\u6570\u636e\u5e93\u7684\u4e13\u95e8\u7528\u6237<\/h4>\n
>1)\u3001groupadd mysql<\/code>\u00a0#\u5efa\u7acb\u4e00\u4e2amysql\u7684\u7ec4\u00a0 \u3000\u3000>2)\u3001useradd -r -g mysql mysql<\/code>\u00a0#\u5efa\u7acbmysql\u7528\u6237\uff0c\u5e76\u4e14\u628a\u7528\u6237\u653e\u5230mysql\u7ec4\u00a0 \u3000\u3000>3)\u3001passwd mysql<\/code>\u00a0#\u7ed9mysql\u7528\u6237\u8bbe\u7f6e\u4e00\u4e2a\u5bc6\u7801\u00a0 \u3000\u30004)\u3001\u7ed9\u76ee\u5f55\/usr\/local\/mysql<\/code>\u66f4\u6539\u62e5\u6709\u8005\u00a0chown -R mysql:mysql \/usr\/local\/mysql\/<\/code><\/p>\n
\u7b2c\u56db\u6b65\uff1a\u521d\u59cb\u5316 mysql \u7684\u6570\u636e\u5e93<\/h3>\n
\u9996\u5148\u53bb\u5230mysql<\/code>\u7684bin<\/code>\u76ee\u5f55<\/p>\n
1.\u521d\u59cb\u5316<\/h4>\n
.<\/span>\/mysqld<\/span> -<\/span>-<\/span>initialize<\/span> -<\/span>-<\/span>user=mysql<\/span> -<\/span>-<\/span>basedir=\/usr\/local\/mysql<\/span> -<\/span>-<\/span>datadir=\/usr\/local\/mysql\/data<\/span><\/code><\/pre>\n
\u751f\u6210\u51fa\u4e00\u4e2adata\u76ee\u5f55\uff0c\u4ee3\u8868\u6570\u636e\u5e93\u5df2\u7ecf\u521d\u59cb\u5316\u6210\u529f\u00a0 \u5e76\u4e14mysql\u7684root\u7528\u6237\u751f\u6210\u4e00\u4e2a\u4e34\u65f6\u5bc6\u7801\uff1a***<\/em><\/strong>(\u6700\u597d\u5148\u8bb0\u5f55\u8fd9\u4e2a\u4e34\u65f6\u5bc6\u7801)<\/p>\n
2.\u7ed9\u6570\u636e\u5e93\u52a0\u5bc6<\/h4>\n
.\/mysql_ssl_rsa_setup --datadir=\/usr\/local<\/span>\/mysql\/data<\/span><\/code><\/pre>\n
3.\u542f\u52a8mysql(\u4e3a\u4e86\u4e0d\u8ba9\u8fdb\u7a0b\u5361\u4e3b\uff0c\u53ef\u5728\u542f\u52a8mysql\u7684\u547d\u4ee4\u540e\u52a0\u4e0a&\u4ee3\u8868\u6b64\u8fdb\u7a0b\u5728\u540e\u53f0\u8fd0\u884c)<\/h4>\n
.\/mysqld_safe --user<\/span>=mysql &<\/span><\/code><\/pre>\n
4.\u68c0\u67e5ps -ef|grep mysql<\/code><\/h4>\n
\u53d1\u73b0\u6709\u8fdb\u7a0b\u4fbf\u4ee3\u8868\u542f\u52a8\u6210\u529f\u3002<\/strong><\/p>\n
\u7b2c\u4e94\u6b65\uff1a\u8fdb\u5165\u5ba2\u6237\u7aef<\/h3>\n
1.\u767b\u5f55:<\/h4>\n
 .<\/span>\/mysql -uroot<\/span> -p<\/span>    #p<\/span>\u540e\u8f93\u5165\u4e4b\u524d\u7684\u4e34\u65f6\u5bc6\u7801<\/code><\/pre>\n
2.\u4fee\u6539\u5bc6\u7801<\/h4>\n
set<\/span> password=password('\u65b0\u5bc6\u7801'<\/span>);<\/span><\/code><\/pre>\n
\u7b2c\u516d\u6b65\uff1a\u8bbe\u7f6e\u8fdc\u7a0b\u8bbf\u95ee<\/h3>\n
1\uff0c\u5728\u8fdc\u7a0b\u8bbf\u95ee\u4e4b\u524d\u9700\u5148\u6253\u5f00centos7\u7684\u7aef\u53e3:<\/h4>\n
1):\u5f00\u542f\u7aef\u53e3:<\/h5>\n
firewall<\/span>-<\/span>cmd<\/span> -<\/span>-<\/span>zone=public<\/span> -<\/span>-<\/span>add<\/span>-<\/span>port=3306\/tcp<\/span> -<\/span>-<\/span>permanent<\/span><\/code><\/pre>\n
2):\u91cd\u542f\u9632\u706b\u5899:<\/h5>\n
firewall<\/span>-<\/span>cmd<\/span> -<\/span>-<\/span>reload<\/span><\/code><\/pre>\n
2\uff0c\u6388\u6743<\/h4>\n
mysql>grant all privileges on *.* to \u8fdc\u7a0b\u8bbf\u95ee\u7528\u6237\u540d@'%' identified by '\u7528\u6237\u5bc6\u7801';<\/code>\u00a0 mysql>select host,user from user;<\/code>\u3010\u591a\u51fa1\u6761\u8fdc\u7a0b\u767b\u5f55\u7528\u6237\u8bb0\u5f55\u3011\u00a0 mysql>flush privileges;<\/code>(\u5237\u65b0)<\/p>\n
\u6b64\u65f6\u5c31\u53ef\u4ee5\u4f7f\u7528\u8fdc\u7a0b\u673a\u5668\u8fdb\u884c\u8bbf\u95ee\u5566!<\/strong><\/p>\n
\u89e3\u6790\uff1a\u4f7f\u7528mysql -h\u4e3b\u673aip -u\u7528\u6237\u540d -p\u5bc6\u7801\u5373\u53ef\u8fdb\u884c\u8fdc\u7a0b\u8bbf\u95ee<\/strong><\/p>\n
\u7b2c\u4e03\u6b65\uff1a\u8bbe\u7f6e\u5f00\u673a\u81ea\u542f\u52a8<\/h3>\n
1\u3001\u6dfb\u52a0\u670d\u52a1mysql<\/h4>\n
chkconfig --add mysql<\/code>\u00a0\u3010mysqld -install\u3011<\/p>\n
2\u3001\u8bbe\u7f6emysql\u670d\u52a1\u4e3a\u81ea\u52a8<\/h4>\n
chkconfig mysql on<\/code><\/p>\n
3\u3001\u91cd\u542f\u67e5\u770b\u8fdb\u7a0b<\/h4>\n
init 6<\/code><\/pre>\n
ps -ef|grep mysql<\/span><\/code><\/pre>\n
\u7b2c\u516b\u6b65\uff1a\u914d\u7f6e\u73af\u5883\u53d8\u91cf<\/h3>\n
\u4e3a\u4e86\u65b9\u4fbf\u64cd\u4f5c\uff0c\u914d\u7f6e\u73af\u5883\u53d8\u91cf\u8fd8\u662f\u6709\u5fc5\u8981\u7684\u3002<\/p>\n
vi \/etc\/profile\r\nexport<\/span> PATH=$JAVA_HOME<\/span>\/bin:\/usr\/local\/mysql\/bin:$PATH<\/span><\/code><\/pre>\n
\u5c0f\u7ed3\uff1a\u5230\u8fd9\u4e00\u6b65\u57fa\u672c\u7684\u914d\u7f6e\u57fa\u672c\u5c31\u5b8c\u6210\u4e86\u3002<\/p>\n
 <\/p>\n
 <\/p>\n
\u539f\u6587\u94fe\u63a5\uff1ahttps:\/\/www.centoscn.com\/mysql\/2017\/0224\/8528.html<\/p>\n","protected":false},"excerpt":{"rendered":"
\u7b2c\u4e00\u6b65\uff1a\u4e0b\u8f7dmysql \u5728Linux\u7ec8\u7aef\u4f7f\u7528wget\u547d\u4ee4\u4e0b\u8f7d\u7f51\u7edc\u8d44\u6e90\uff1a wget https:\/\/mirror … \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":[559],"class_list":["post-1820","post","type-post","status-publish","format-standard","hentry","category-linux","category-jishu","category-shujuku","tag-linuxmysql5-7"],"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\/1820","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=1820"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1820\/revisions"}],"predecessor-version":[{"id":1821,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1820\/revisions\/1821"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=1820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=1820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=1820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}