{"id":1144,"date":"2019-06-08T08:28:32","date_gmt":"2019-06-08T00:28:32","guid":{"rendered":"https:\/\/freesilo.com\/?p=1144"},"modified":"2019-12-29T15:50:02","modified_gmt":"2019-12-29T07:50:02","slug":"centos7%e4%bd%bf%e7%94%a8yum%e5%ae%89%e8%a3%85mysql","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=1144","title":{"rendered":"CentOS7\u4f7f\u7528yum\u5b89\u88c5MySQL"},"content":{"rendered":"

1\u3001CentOS7\u7684yum\u6e90\u4e2d\u9ed8\u8ba4\u662f\u6ca1\u6709mysql\u7684\uff0c\u6211\u4eec\u5148\u4e0b\u8f7dmysql\u7684repo\u6e90<\/p>\n

wget\u00a0http:\/\/repo.mysql.com\/mysql-community-release-el7-5.noarch.rpm<\/pre>\n
\"image.png\"<\/p>\n
2\u3001\u5b89\u88c5mysql-community-release-el7-5.noarch.rpm\u5305<\/p>\n
sudo\u00a0rpm\u00a0-ivh\u00a0mysql-community-release-el7-5.noarch.rpm<\/pre>\n
\"image.png\"<\/p>\n
3\u3001\u5b89\u88c5mysql\uff0c\u6839\u636e\u63d0\u793a\u5b89\u88c5\u5373\u53ef<\/p>\n
sudo\u00a0yum\u00a0install\u00a0mysql-server<\/pre>\n
\"image.png\"<\/p>\n
\"image.png\"<\/p>\n
4\u3001\u5b89\u88c5\u5b8c\u6210\u540e\u6ca1\u6709\u5bc6\u7801\uff0c\u9700\u8981\u91cd\u7f6e\u5bc6\u7801<\/p>\n
mysql\u00a0-u\u00a0root<\/pre>\n
\u767b\u5f55\u65f6\u6709\u53ef\u80fd\u62a5\u8fd9\u6837\u7684\u9519\uff1aERROR 2002 (HY000): Can\u2018t connect to local MySQL server through socket \u2018\/var\/lib\/mysql\/mysql.sock\u2018 (2)\uff0c\u539f\u56e0\u662f\/var\/lib\/mysql\u7684\u8bbf\u95ee\u6743\u9650\u95ee\u9898\u3002\u4e0b\u9762\u7684\u547d\u4ee4\u628a\/var\/lib\/mysql\u7684\u62e5\u6709\u8005\u6539\u4e3a\u5f53\u524d\u7528\u6237<\/p>\n
sudo\u00a0chown\u00a0-R\u00a0root:root\u00a0\/var\/lib\/mysql<\/pre>\n
\u91cd\u542fmysql\u670d\u52a1<\/p>\n
service\u00a0mysqld\u00a0restart<\/pre>\n
\u63a5\u4e0b\u6765\u91cd\u7f6eroot\u7528\u6237\u5bc6\u7801\uff1a<\/p>\n
mysql\u00a0-u\u00a0root\u00a0\u00a0\/\/\u76f4\u63a5\u56de\u8f66\u8fdb\u5165mysql\u63a7\u5236\u53f0<\/pre>\n
use\u00a0mysql;<\/pre>\n
update\u00a0user\u00a0set\u00a0password=password('111111')\u00a0where\u00a0user='root';<\/pre>\n
\"image.png\"<\/p>\n
\u6574\u4e2a\u5b89\u88c5\u5b8c\u6210\uff01<\/p>\n
PS:<\/p>\n
\u5141\u8bb8\u4f7f\u7528\u7528\u6237\u540droot\u5bc6\u7801123456\u4ece\u4efb\u4f55\u4e3b\u673a\u8fde\u63a5\u5230mysql\u670d\u52a1\u5668<\/p>\n
mysql>GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘111111’ WITH GRANT OPTION;<\/p>\n
\u5237\u65b0\u6743\u9650<\/p>\n
mysql>FLUSH PRIVILEGES;<\/p>\n
\u9000\u51famysql<\/p>\n
mysql>exit;<\/p>\n
\u5f00\u542f\u9632\u706b\u5899mysql3306\u7aef\u53e3\u7684\u5916\u90e8\u8bbf\u95ee<\/p>\n
CentOS\u5347\u7ea7\u52307\u4e4b\u540e\uff0c\u4f7f\u7528firewalld\u4ee3\u66ff\u4e86\u539f\u6765\u7684iptables\u3002\u4e0b\u9762\u8bb0\u5f55\u5982\u4f55\u4f7f\u7528firewalld\u5f00\u653eLinux\u7aef\u53e3<\/p>\n
–zone : \u4f5c\u7528\u57df\uff0c\u7f51\u7edc\u533a\u57df\u5b9a\u4e49\u4e86\u7f51\u7edc\u8fde\u63a5\u7684\u53ef\u4fe1\u7b49\u7ea7\u3002\u8fd9\u662f\u4e00\u4e2a\u4e00\u5bf9\u591a\u7684\u5173\u7cfb\uff0c\u8fd9\u610f\u5473\u7740\u4e00\u6b21\u8fde\u63a5\u53ef\u4ee5\u4ec5\u4ec5\u662f\u4e00\u4e2a\u533a\u57df\u7684\u4e00\u90e8\u5206\uff0c\u800c\u4e00\u4e2a\u533a\u57df\u53ef\u4ee5\u7528\u4e8e\u5f88\u591a\u8fde\u63a5<\/p>\n
–add-port : \u6dfb\u52a0\u7aef\u53e3\u4e0e\u901a\u4fe1\u534f\u8bae\uff0c\u683c\u5f0f\u4e3a\uff1a\u7aef\u53e3\/\u901a\u8baf\u534f\u8bae\uff0c\u534f\u8bae\u662ftcp \u6216 udp<\/p>\n
–permanent : \u6c38\u4e45\u751f\u6548\uff0c\u6ca1\u6709\u6b64\u53c2\u6570\u7cfb\u7edf\u91cd\u542f\u540e\u7aef\u53e3\u8bbf\u95ee\u5931\u6548<\/p>\n
firewall-cmd –zone=public –add-port=3306\/tcp –permanent<\/p>\n
\u91cd\u542f\u9632\u706b\u5899<\/p>\n
firewall-cmd –reload<\/p>\n","protected":false},"excerpt":{"rendered":"
1\u3001CentOS7\u7684yum\u6e90\u4e2d\u9ed8\u8ba4\u662f\u6ca1\u6709mysql\u7684\uff0c\u6211\u4eec\u5148\u4e0b\u8f7dmysql\u7684re…
Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,18],"tags":[],"class_list":["post-1144","post","type-post","status-publish","format-standard","hentry","category-linux","category-mysql"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/1144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1144"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/1144\/revisions"}],"predecessor-version":[{"id":1150,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/1144\/revisions\/1150"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}