{"id":319,"date":"2024-07-27T14:39:11","date_gmt":"2024-07-27T06:39:11","guid":{"rendered":"http:\/\/www.chan.ink\/?p=319"},"modified":"2024-07-27T22:24:22","modified_gmt":"2024-07-27T14:24:22","slug":"mysql%e5%9c%a8centos7-9%e4%b8%8b%e7%9a%84%e5%ae%89%e8%a3%85%e8%ae%b0%e5%bd%95","status":"publish","type":"post","link":"http:\/\/www.chan.ink\/index.php\/2024\/07\/27\/mysql%e5%9c%a8centos7-9%e4%b8%8b%e7%9a%84%e5%ae%89%e8%a3%85%e8%ae%b0%e5%bd%95\/","title":{"rendered":"Mysql\u5728centos7.9\u4e0b\u7684\u5b89\u88c5\u8bb0\u5f55"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u9996\u5148\u8981\u67e5\u770b\u4e00\u4e0bCentOS 7.9\u7cfb\u7edf\u662f\u5426\u5df2\u5b89\u88c5mysql\u5386\u53f2\u7248\u672c\uff0c\u53ef\u4f7f\u7528\u5982\u4e0b\u547d\u4ee4\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>rpm -qa|<strong>grep<\/strong> mysql\nrpm -qa|<strong>grep<\/strong> mariadb\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u5b58\u5728mysql\u5386\u53f2\u7248\u672c\u53ef\u7528\u4ee5\u4e0b\u547d\u4ee4\uff0c\u4f9d\u6b21\u8fdb\u884c\u5378\u8f7d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>yum -y <strong>remove<\/strong>  mysql\u5b89\u88c5\u5305\u540d\u79f0\nyum -y <strong>remove<\/strong>  mariadb\u5b89\u88c5\u5305\u540d\u79f0\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u7531\u4e8eCentOS7\u9ed8\u8ba4yum\u5b89\u88c5\u6570\u636e\u5e93\u662fmariadb\uff0c\u56e0\u6b64\u9700\u8981\u901a\u8fc7repo\u6e90\u8fdb\u884c\u5b89\u88c5mysql8.0\u6700\u65b0\u7248\u672c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;root@hecs-164387 software]# wget  https:\/\/dev.mysql.com\/<strong>get<\/strong>\/mysql80-community-<strong>release<\/strong>-el7-3.noarch.rpm\n&#91;root@hecs-164387 software]# rpm -ivh mysql80-community-<strong>release<\/strong>-el7-3.noarch.rpm\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u9632\u6b62yum\u6e90\u7f13\u5b58\u5bfc\u81f4\u4e0d\u751f\u6548\uff0c\u66f4\u65b0\u7f13\u5b58<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;root@hecs-164387 software]# yum clean all\n&#91;root@hecs-164387 software]# yum makecache\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u5b89\u88c5mysql\u524d\uff0c\u5148\u6267\u884c\u8fd9\u4e2a\u547d\u4ee4<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">rpm &#8212;<strong>import<\/strong> https:\/\/repo.mysql.com\/RPM-GPG-KEY-mysql-2023<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b89\u88c5Mysql8.0\u6570\u636e\u5e93<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;root@hecs-164387 software]# yum install mysql-community-server mysql-community\n&#91;root@hecs-164387 software]# mysql -V   \/\/\u67e5\u770b\u5f53\u524d\u5b89\u88c5mysql\u7248\u672c<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a href=\"https:\/\/www.cnblogs.com\/505donkey\/p\/17954029\">centos7 \u5b89\u88c5 mysql8.0<\/a><\/h1>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"\u5b89\u88c5\u73af\u5883\">\u5b89\u88c5\u73af\u5883<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u64cd\u4f5c\u7cfb\u7edf\uff1acentos 7.9<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"\u5b89\u5168\u524d\u68c0\u67e5\">\u5b89\u5168\u524d\u68c0\u67e5<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. \u68c0\u67e5\u5386\u53f2\u7248\u672c<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>rpm -qa | grep -i mysql\nrpm -qa | grep -i mariadb\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3010\u8bf4\u660e\u3011mariadb\u4e3amysql\u9879\u76ee\u4e00\u4e2a\u5206\u652f\uff0c\u5728\u4f7f\u7528\u4e0a\u5f88\u591a\u65b9\u9762\u4e0emysql\u975e\u5e38\u7c7b\u4f3c\uff0c\u50cfcentos7\uff0cmariadb\u5df2\u7ecf\u66ff\u4ee3mysql\u4f5c\u4e3a\u9ed8\u8ba4yum\u5b89\u88c5\u7684\u6570\u636e\u5e93\uff0c\u6545\u68c0\u67e5\u5386\u53f2\u7248\u672c\u65f6\u4f1a\u4e00\u8d77\u68c0\u67e5\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. \u5378\u8f7d\u5386\u53f2\u7248\u672c\uff08\u5982\u5df2\u5b89\u88c5\u8fc7\uff09<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>yum remove -y mysql\u5b89\u88c5\u5305\u540d\u79f0\nyum remove -y mariadb\u5b89\u88c5\u5305\u540d\u79f0\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3010\u8bf4\u660e\u3011\u5b89\u88c5\u5305\u540d\u79f0\u4e3a\u6b65\u9aa41\u68c0\u67e5\u7ed3\u679c\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3. \u6e05\u7406\u6b8b\u7559\u6570\u636e\u76ee\u5f55\u53ca\u6587\u4ef6<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5220\u9664\u5b89\u88c5\u76ee\u5f55\uff08\u793a\u4f8b\uff09<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code># \u83b7\u53d6\u5b89\u88c5\u76ee\u5f55\nwhereis mysql\n\n# \u5220\u9664\u5b89\u88c5\u76ee\u5f55\nrm -rf \/usr\/lib64\/mysql \/usr\/share\/mysql\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5220\u9664\u6570\u636e\u76ee\u5f55\uff08\u793a\u4f8b\uff09<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>rm -rf \/var\/lib\/mysql\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5220\u9664\u914d\u7f6e\u6587\u4ef6\uff08\u793a\u4f8b\uff09<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>rm -rf \/etc\/my.cnf\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5220\u9664\u65e5\u5fd7\u6587\u4ef6\uff08\u793a\u4f8b\uff09<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>rm -rf \/var\/log\/mysql\nrm -rf \/var\/log\/mysqld.log\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5220\u9664\u4e34\u65f6\u6587\u4ef6\uff08\u793a\u4f8b\uff09<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>rm -rf \/tmp\/mysql*\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5220\u9664\u670d\u52a1\u548c\u542f\u52a8\u811a\u672c\uff08\u793a\u4f8b\uff09<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>rm -rf \/etc\/init.d\/mysql\nrm -rf \/usr\/lib\/systemd\/system\/mysql.service\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3010\u6ce8\u610f\u3011\u4ee5\u4e0a\u6e05\u7406\u76ee\u5f55\u6216\u6587\u4ef6\u5747\u53c2\u8003\u9ed8\u8ba4\u5b89\u88c5\uff0c\u5177\u4f53\u6e05\u7406\u65f6\u8bf7\u4ee5\u5b9e\u9645\u5b89\u88c5\u4e3a\u51c6\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"\u5f00\u59cb\u5b89\u88c5\">\u5f00\u59cb\u5b89\u88c5<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. \u4e0b\u8f7dmysql\u5b98\u65b9yum\u6e90<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>wget  https:\/\/dev.mysql.com\/get\/mysql80-community-release-el7-3.noarch.rpm\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3010\u8bf4\u660e\u3011centos7\u4f7f\u7528yum\u5b89\u88c5\u9ed8\u8ba4\u4e3amariadb\uff0c\u6240\u4ee5\u9700\u8981\u53e6\u5916\u4ecemysql\u5b98\u65b9\u4e0b\u8f7d\uff0c\u6545\u76f4\u63a5\u4f7f\u7528\u5b98\u65b9\u63d0\u4f9b\u7684yum\u6e90\uff0c\u53ef\u4ee5\u65b9\u4fbf\u5904\u7406mysql\u4f9d\u8d56\u5173\u7cfb\uff0c\u7b80\u5316\u5b89\u88c5\u8fc7\u7a0b\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. \u5b89\u88c5\u5b98\u65b9yum\u6e90<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>rpm -ivh mysql80-community-release-el7-3.noarch.rpm\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3. \u66f4\u65b0yum\u6e90\u7f13\u5b58<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6e05\u7406yum\u7f13\u5b58\u76ee\u5f55\nyum clean all\n\n# \u91cd\u65b0\u4e0a\u4f20yum\u7f13\u5b58\nyum makecache\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3010\u8bf4\u660e\u3011\u56e0\u4e3ayum\u6e90\u6709\u66f4\u65b0\uff0c\u6240\u4ee5\u8981\u6e05\u9664\u8fc7\u65f6\u7f13\u5b58\uff0c\u4ee5\u83b7\u53d6\u6700\u65b0\u8f6f\u4ef6\u5305\u4fe1\u606f\uff0c\u907f\u514d\u5b89\u88c5\u6216\u66f4\u65b0\u8fc7\u7a0b\u4f7f\u7528\u4e86\u8fc7\u65f6\u7684\u8f6f\u4ef6\u5305\u7f13\u5b58\u4fe1\u606f\u5bfc\u81f4\u95ee\u9898\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4. \u5bfc\u5165GPG\u5bc6\u94a5<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>rpm --import https:\/\/repo.mysql.com\/RPM-GPG-KEY-mysql-2022\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3010\u8bf4\u660e\u3011GPG\u5bc6\u94a5\u662f\u5904\u4e8e\u5b89\u5168\u8003\u8651\uff0c\u7528\u6765\u9a8c\u8bc1\u4e0b\u8f7d\u7684\u5305\u662f\u5426\u662f\u539f\u59cb\u7684\u3001\u672a\u88ab\u7be1\u6539\u7684\uff0c\u5982\u679c\u4e0d\u9700\u8981\u6821\u9a8c\u5bc6\u94a5\uff0c\u53ef\u5728\u5b89\u88c5\u65f6\u52a0\u5165<code>--nogpgcheck<\/code>\u53c2\u6570\u8df3\u8fc7\u6821\u9a8c\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5. \u5b89\u88c5MySQL<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>yum install -y mysql-community-server mysql-community\n\n# \u9a8c\u8bc1\u662f\u5426\u5b89\u88c5\u6210\u529f\nmysql -V\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6. \u542f\u52a8 mysql \u670d\u52a1<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl start mysqld\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>7. \u8bbe\u7f6e\u5f00\u673a\u542f\u52a8\uff08\u53ef\u9009\uff09<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl enable mysqld\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>8. \u67e5\u770broot\u521d\u59cb\u5bc6\u7801<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>grep 'temporary password' \/var\/log\/mysqld.log\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>9. \u767b\u5f55mysql<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u5bc6\u7801\u4e3a\u4e0a\u4e00\u6b65\u83b7\u53d6\u7684\u521d\u59cb\u5bc6\u7801\nmysql -u root -p\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>10. \u4fee\u6539\u5bc6\u7801<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER 'root'@'localhost' IDENTIFIED BY '\u65b0\u5bc6\u7801';\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>11. \u8bbe\u7f6e\u8fdc\u7a0b\u8bbf\u95ee\uff08\u53ef\u9009\uff09<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '\u65b0\u5bc6\u7801' WITH GRANT OPTION;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148\u8981\u67e5\u770b\u4e00\u4e0bCentOS 7.9\u7cfb\u7edf\u662f\u5426\u5df2\u5b89\u88c5mysql\u5386\u53f2\u7248\u672c\uff0c\u53ef\u4f7f\u7528\u5982\u4e0b\u547d\u4ee4\uff1a \u5982\u5b58\u5728mysql\u5386\u53f2\u7248\u672c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-319","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts\/319","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/comments?post=319"}],"version-history":[{"count":2,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts\/319\/revisions"}],"predecessor-version":[{"id":321,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts\/319\/revisions\/321"}],"wp:attachment":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/media?parent=319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/categories?post=319"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/tags?post=319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}