{"id":6674,"date":"2024-11-14T11:37:17","date_gmt":"2024-11-14T03:37:17","guid":{"rendered":"https:\/\/fwq.ai\/blog\/6674\/"},"modified":"2024-11-14T11:37:17","modified_gmt":"2024-11-14T03:37:17","slug":"centos7-mysql%e5%8e%8b%e7%bc%a9%e5%8c%85%e5%ae%89%e8%a3%85%e6%95%99%e7%a8%8b","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/6674\/","title":{"rendered":"centos7 mysql\u538b\u7f29\u5305\u5b89\u88c5\u6559\u7a0b"},"content":{"rendered":"<blockquote><p>\n  \u672c\u6559\u7a0b\u5c06\u6307\u5bfc\u4f60\u5728 centos 7 \u7cfb\u7edf\u4e0a\u4f7f\u7528\u538b\u7f29\u5305\u624b\u52a8\u5b89\u88c5 mysql \u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u3002\u9002\u7528\u4e8e\u60f3\u8981\u4ece\u6e90\u4ee3\u7801\u81ea\u5b9a\u4e49\u5b89\u88c5 mysql \u6216\u5bf9\u4f7f\u7528 yum \u4ed3\u5e93\u5305\u4e0d\u611f\u5174\u8da3\u7684\u7528\u6237\u3002\u5b89\u88c5\u8fc7\u7a0b\u6d89\u53ca\u83b7\u53d6 mysql \u6e90\u4ee3\u7801\uff0c\u7f16\u8bd1\u5e76\u5b89\u88c5\u8f6f\u4ef6\uff0c\u7136\u540e\u6839\u636e\u4f60\u7684\u7cfb\u7edf\u8981\u6c42\u8fdb\u884c\u914d\u7f6e\u3002\n<\/p><\/blockquote>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/202410\/17\/2024101714210325091.jpg\" class=\"aligncenter\" title=\"centos7 mysql\u538b\u7f29\u5305\u5b89\u88c5\u6559\u7a0b\u63d2\u56fe\" alt=\"centos7 mysql\u538b\u7f29\u5305\u5b89\u88c5\u6559\u7a0b\u63d2\u56fe\" \/><\/p>\n<p><strong>CentOS 7 \u4e0a\u4f7f\u7528\u538b\u7f29\u5305\u5b89\u88c5 MySQL<\/strong><\/p>\n<p><strong>\u6b65\u9aa4 1\uff1a\u4e0b\u8f7d MySQL \u538b\u7f29\u5305<\/strong><\/p>\n<ul>\n<li>\u8bbf\u95ee MySQL \u5b98\u65b9\u7f51\u7ad9https:\/\/dev..com\/downloads\/mysql\/\u3002<\/li>\n<li>\u5728\u201cGeneral Availability (GA) Releases\u201d\u90e8\u5206\uff0c\u9009\u62e9 MySQL \u7684\u6700\u65b0\u7a33\u5b9a\u7248\u672c\u3002<\/li>\n<li>\u4e0b\u8f7d\u9002\u7528\u4e8e Linux \u7684\u201cGeneric Linux\u201d\u538b\u7f29\u5305\u3002<\/li>\n<\/ul>\n<p><strong>\u6b65\u9aa4 2\uff1a\u521b\u5efa MySQL \u7528\u6237<\/strong><\/p>\n<ul>\n<li>\u4ee5 root \u7528\u6237\u8eab\u4efd\u521b\u5efa\u65b0\u7684 MySQL \u7528\u6237\uff1a<\/li>\n<\/ul>\n<pre>adduser mysql<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<ul>\n<li>\u8bbe\u7f6e MySQL \u7528\u6237\u7684\u5bc6\u7801\uff1a<\/li>\n<\/ul>\n<pre>passwd mysql<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p><strong>\u6b65\u9aa4 3\uff1a\u89e3\u538b MySQL \u538b\u7f29\u5305<\/strong><\/p>\n<p><span>\u70b9\u51fb\u4e0b\u8f7d<\/span>\u201c\u201d\uff1b<\/p>\n<ul>\n<li>\u5207\u6362\u5230\u60a8\u8981\u5b89\u88c5 MySQL \u7684\u76ee\u5f55\uff0c\u4f8b\u5982 \/opt\uff1a<\/li>\n<\/ul>\n<pre>cd \/opt<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<ul>\n<li>\u89e3\u538b\u4e0b\u8f7d\u7684 MySQL \u538b\u7f29\u5305\uff1a<\/li>\n<\/ul>\n<pre>tar -xf mysql-*.tar.gz<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p><strong>\u6b65\u9aa4 4\uff1a\u914d\u7f6e MySQL<\/strong><\/p>\n<ul>\n<li>\u5207\u6362\u5230\u89e3\u538b\u540e\u7684 MySQL \u76ee\u5f55\uff1a<\/li>\n<\/ul>\n<pre>cd \/opt\/mysql<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<ul>\n<li>\u521d\u59cb\u5316 MySQL \u6570\u636e\u76ee\u5f55\uff1a<\/li>\n<\/ul>\n<pre>.\/scripts\/mysql_install_db --user=mysql<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<ul>\n<li>\u590d\u5236 MySQL \u914d\u7f6e\u6587\u4ef6\uff1a<\/li>\n<\/ul>\n<pre>cp \/opt\/mysql\/support-files\/my-default.cnf \/etc\/my.cnf<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<ul>\n<li>\u7f16\u8f91 \/etc\/my.cnf \u914d\u7f6e\u6587\u4ef6\uff1a<\/li>\n<\/ul>\n<pre>[mysqld]\nbind-address = 0.0.0.0<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<ul>\n<li>\u4fdd\u5b58\u5e76\u5173\u95ed\u914d\u7f6e\u6587\u4ef6\u3002<\/li>\n<\/ul>\n<p><strong>\u6b65\u9aa4 5\uff1a\u542f\u52a8 MySQL \u670d\u52a1<\/strong><\/p>\n<ul>\n<li>\u542f\u52a8 MySQL \u670d\u52a1\uff1a<\/li>\n<\/ul>\n<pre>systemctl start mysqld<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p><strong>\u6b65\u9aa4 6\uff1a\u5b89\u5168 MySQL<\/strong><\/p>\n<ul>\n<li>\u8fd0\u884c MySQL \u5b89\u5168\u811a\u672c\u4ee5\u8bbe\u7f6e root \u7528\u6237\u5bc6\u7801\u548c\u5176\u4ed6\u5b89\u5168\u8bbe\u7f6e\uff1a<\/li>\n<\/ul>\n<pre>.\/bin\/mysql_secure_installation<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p><strong>\u6b65\u9aa4 7\uff1a\u8fde\u63a5\u5230 MySQL<\/strong><\/p>\n<ul>\n<li>\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u8fde\u63a5\u5230 MySQL \u63a7\u5236\u53f0\uff1a<\/li>\n<\/ul>\n<pre>mysql -u root -p<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<ul>\n<li>\u8f93\u5165\u60a8\u5728\u5b89\u5168\u811a\u672c\u4e2d\u8bbe\u7f6e\u7684 root \u7528\u6237\u5bc6\u7801\u3002<\/li>\n<\/ul>\n<p>\u4ee5\u4e0a\u5c31\u662f7 \u538b\u7f29\u5305\u5b89\u88c5\u6559\u7a0b\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u7f51\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6559\u7a0b\u5c06\u6307\u5bfc\u4f60\u5728 centos 7 \u7cfb\u7edf\u4e0a\u4f7f\u7528\u538b\u7f29\u5305\u624b\u52a8\u5b89\u88c5 mysql \u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u3002\u9002\u7528\u4e8e\u60f3\u8981\u4ece\u6e90\u4ee3\u7801\u81ea\u5b9a\u4e49\u5b89\u88c5 mysql \u6216\u5bf9\u4f7f\u7528 yum \u4ed3\u5e93\u5305\u4e0d\u611f\u5174\u8da3\u7684\u7528\u6237\u3002\u5b89\u88c5\u8fc7\u7a0b\u6d89\u53ca\u83b7\u53d6 mysql \u6e90\u4ee3\u7801\uff0c\u7f16\u8bd1\u5e76\u5b89\u88c5\u8f6f\u4ef6\uff0c\u7136\u540e\u6839\u636e\u4f60\u7684\u7cfb\u7edf\u8981\u6c42\u8fdb\u884c\u914d\u7f6e\u3002 CentOS 7 \u4e0a\u4f7f\u7528\u538b\u7f29\u5305\u5b89\u88c5 MySQL \u6b65\u9aa4 1\uff1a\u4e0b\u8f7d MySQL \u538b\u7f29\u5305 \u8bbf\u95ee MySQL \u5b98\u65b9\u7f51\u7ad9https:\/\/dev..com\/downloads\/mysql\/\u3002 \u5728\u201cGeneral Availability (GA) Releases\u201d\u90e8\u5206\uff0c\u9009\u62e9 MySQL \u7684\u6700\u65b0\u7a33\u5b9a\u7248\u672c\u3002 \u4e0b\u8f7d\u9002\u7528\u4e8e Linux \u7684\u201cGeneric Linux\u201d\u538b\u7f29\u5305\u3002 \u6b65\u9aa4 2\uff1a\u521b\u5efa MySQL \u7528\u6237 \u4ee5 root \u7528\u6237\u8eab\u4efd\u521b\u5efa\u65b0\u7684 MySQL \u7528\u6237\uff1a adduser mysql \u767b\u5f55\u540e\u590d\u5236 \u8bbe\u7f6e MySQL \u7528\u6237\u7684\u5bc6\u7801\uff1a passwd mysql \u767b\u5f55\u540e\u590d\u5236 \u6b65\u9aa4 3\uff1a\u89e3\u538b MySQL \u538b\u7f29\u5305 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-6674","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/6674","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=6674"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/6674\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=6674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=6674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=6674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}