{"id":131829,"date":"2020-07-05T04:33:35","date_gmt":"2020-07-04T20:33:35","guid":{"rendered":"http:\/\/4563.org\/?p=131829"},"modified":"2020-07-05T04:33:35","modified_gmt":"2020-07-04T20:33:35","slug":"mysql-5-7-%e4%bd%bf%e7%94%a8-yum%e5%ae%89%e8%a3%85","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=131829","title":{"rendered":"Mysql 5.7 \u4f7f\u7528 yum\u5b89\u88c5"},"content":{"rendered":"

\u5728CentOS7\u4e2d\u9ed8\u8ba4\u5b89\u88c5\u6709MariaDB\uff0c\u8fd9\u4e2a\u662fMySQL\u7684\u5206\u652f\uff0c\u4f46\u4e3a\u4e86\u9700\u8981\uff0c\u8fd8\u662f\u8981\u5728\u7cfb\u7edf\u4e2d\u5b89\u88c5MySQL\uff0c\u800c\u4e14\u5b89\u88c5\u5b8c\u6210\u4e4b\u540e\u53ef\u4ee5\u76f4\u63a5\u8986\u76d6\u6389MariaDB\u3002<\/p>\n

<\/a>1.\u5b89\u88c5wget\u5de5\u5177<\/h3>\n

\u4f7f\u7528wget\u5de5\u5177\u4e0b\u8f7dmysql\u5b89\u88c5\u5305\u548cyum\u6e90\u6587\u4ef6<\/p>\n

\n\n\n
\n
1<\/span>
2<\/span>
3<\/span>
4<\/span>
5<\/span>
6<\/span>
7<\/span>
8<\/span>
9<\/span>
10<\/span>
11<\/span>
12<\/span>
13<\/span>
14<\/span>
15<\/span>
16<\/span>
17<\/span>
18<\/span>
19<\/span>
20<\/span>
21<\/span>
22<\/span>
23<\/span>
24<\/span>
25<\/span>
26<\/span>
27<\/span>
28<\/span>
29<\/span>
30<\/span>
31<\/span>
32<\/span>
33<\/span>
34<\/span>
35<\/span>
36<\/span>
37<\/span>
38<\/span>
39<\/span>
40<\/span>
41<\/span>
42<\/span>
<\/pre>\n<\/td>\n
\n
[root@node02 ~]# wget -i -c http:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-10.noarch.rpm<\/span>
-bash: wget: command not found<\/span>
You have new mail in \/var\/spool\/mail\/root<\/span>
[root@node02 ~]# yum install -y wget<\/span>
Loaded plugins: fastestmirror<\/span>
Loading mirror speeds from cached hostfile<\/span>
 * base: mirror.jdcloud.com<\/span>
 * extras: mirror.jdcloud.com<\/span>
 * updates: mirrors.tuna.tsinghua.edu.cn<\/span>
Resolving Dependencies<\/span>
--><\/span> Running transaction check<\/span><\/span>
---><\/span> Package wget.x86_64 0:1.14-18.el7_6.1 will be installed<\/span><\/span>
--><\/span> Finished Dependency Resolution<\/span><\/span>
<\/span>
Dependencies Resolved<\/span>
<\/span>
===================================================================================================<\/span>
 Package            Arch                 Version                          Repository          Size<\/span>
===================================================================================================<\/span>
Installing:<\/span>
 wget               x86_64               1.14-18.el7_6.1                  base               547 k<\/span>
<\/span>
Transaction Summary<\/span>
===================================================================================================<\/span>
Install  1 Package<\/span>
<\/span>
Total download size: 547 k<\/span>
Installed size: 2.0 M<\/span>
Downloading packages:<\/span>
wget-1.14-18.el7_6.1.x86_64.rpm                                             | 547 kB  00:00:08     <\/span>
Running transaction check<\/span>
Running transaction test<\/span>
Transaction test succeeded<\/span>
Running transaction<\/span>
  Installing : wget-1.14-18.el7_6.1.x86_64                                                     1\/1 <\/span>
  Verifying  : wget-1.14-18.el7_6.1.x86_64                                                     1\/1 <\/span>
<\/span>
Installed:<\/span>
  wget.x86_64 0:1.14-18.el7_6.1                                                                    <\/span>
<\/span>
Complete!<\/span>
[root@node02 ~]#<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
<\/a>2. \u4e0b\u8f7d\u5e76\u5b89\u88c5MySQL\u5b98\u65b9\u7684 Yum Repository<\/h3>\n
\n\n\n
\n
1<\/span>
2<\/span>
3<\/span>
4<\/span>
5<\/span>
6<\/span>
7<\/span>
8<\/span>
9<\/span>
10<\/span>
11<\/span>
12<\/span>
13<\/span>
14<\/span>
15<\/span>
16<\/span>
17<\/span>
18<\/span>
19<\/span>
20<\/span>
21<\/span>
22<\/span>
23<\/span>
24<\/span>
25<\/span>
26<\/span>
27<\/span>
28<\/span>
<\/pre>\n<\/td>\n
\n
[root@node02 ~]# wget -i -c http:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-10.noarch.rpm<\/span>
--2019-10-11 14:31:09--  http:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-10.noarch.rpm<\/span>
Resolving dev.mysql.com (dev.mysql.com)... 137.254.60.11<\/span>
Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:80... connected.<\/span>
HTTP request sent, awaiting response... 301 Moved Permanently<\/span>
Location: https:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-10.noarch.rpm [following]<\/span>
--2019-10-11 14:31:11--  https:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-10.noarch.rpm<\/span>
Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... connected.<\/span>
HTTP request sent, awaiting response... 302 Found<\/span>
Location: https:\/\/repo.mysql.com\/\/mysql57-community-release-el7-10.noarch.rpm [following]<\/span>
--2019-10-11 14:31:14--  https:\/\/repo.mysql.com\/\/mysql57-community-release-el7-10.noarch.rpm<\/span>
Resolving repo.mysql.com (repo.mysql.com)... 104.93.1.42<\/span>
Connecting to repo.mysql.com (repo.mysql.com)|104.93.1.42|:443... connected.<\/span>
HTTP request sent, awaiting response... 200 OK<\/span>
Length: 25548 (25K) [application\/x-redhat-package-manager]<\/span>
Saving to: \u2018mysql57-community-release-el7-10.noarch.rpm\u2019<\/span>
<\/span>
100%<\/span>[=========================================================>] 25,548      --.-K\/s   in<\/span> 0.001s  <\/span><\/span>
<\/span>
2019-10-11 14:31:15 (31.3 MB\/s) - \u2018mysql57-community-release-el7-10.noarch.rpm\u2019 saved [25548\/25548]<\/span>
<\/span>
-c: No such file or directory<\/span>
No URLs found in -c.<\/span>
FINISHED --2019-10-11 14:31:15--<\/span>
Total wall clock time: 5.9s<\/span>
Downloaded: 1 files, 25K in 0.001s (31.3 MB\/s)<\/span>
You have new mail in \/var\/spool\/mail\/root<\/span>
[root@node02 ~]#<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
\u4f7f\u7528\u4e0a\u9762\u7684\u547d\u4ee4\u5c31\u76f4\u63a5\u4e0b\u8f7d\u4e86\u5b89\u88c5\u7528\u7684Yum Repository\uff0c\u5927\u698225KB\u7684\u6837\u5b50\uff0c\u7136\u540e\u5c31\u53ef\u4ee5\u76f4\u63a5yum\u5b89\u88c5\u4e86\u3002<\/p>\n
\n\n\n
\n
1<\/span>
2<\/span>
3<\/span>
4<\/span>
5<\/span>
6<\/span>
7<\/span>
8<\/span>
9<\/span>
10<\/span>
11<\/span>
12<\/span>
13<\/span>
14<\/span>
15<\/span>
16<\/span>
17<\/span>
18<\/span>
19<\/span>
20<\/span>
21<\/span>
22<\/span>
23<\/span>
24<\/span>
25<\/span>
26<\/span>
27<\/span>
28<\/span>
29<\/span>
30<\/span>
31<\/span>
32<\/span>
33<\/span>
34<\/span>
35<\/span>
36<\/span>
37<\/span>
<\/pre>\n<\/td>\n
\n
[root@node02 ~]#  yum -y install mysql57-community-release-el7-10.noarch.rpm <\/span>
Loaded plugins: fastestmirror<\/span>
Examining mysql57-community-release-el7-10.noarch.rpm: mysql57-community-release-el7-10.noarch<\/span>
Marking mysql57-community-release-el7-10.noarch.rpm to be installed<\/span>
Resolving Dependencies<\/span>
--><\/span> Running transaction check<\/span><\/span>
---><\/span> Package mysql57-community-release.noarch 0:el7-10 will be installed<\/span><\/span>
--><\/span> Finished Dependency Resolution<\/span><\/span>
<\/span>
Dependencies Resolved<\/span>
<\/span>
===================================================================================================<\/span>
 Package                     Arch     Version     Repository                                  Size<\/span>
===================================================================================================<\/span>
Installing:<\/span>
 mysql57-community-release   noarch   el7-10      \/mysql57-community-release-el7-10.noarch    30 k<\/span>
<\/span>
Transaction Summary<\/span>
===================================================================================================<\/span>
Install  1 Package<\/span>
<\/span>
Total size: 30 k<\/span>
Installed size: 30 k<\/span>
Downloading packages:<\/span>
Running transaction check<\/span>
Running transaction test<\/span>
Transaction test succeeded<\/span>
Running transaction<\/span>
  Installing : mysql57-community-release-el7-10.noarch                                         1\/1 <\/span>
  Verifying  : mysql57-community-release-el7-10.noarch                                         1\/1 <\/span>
<\/span>
Installed:<\/span>
  mysql57-community-release.noarch 0:el7-10                                                        <\/span>
<\/span>
Complete!<\/span>
You have new mail in \/var\/spool\/mail\/root<\/span>
[root@node02 ~]#<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
\u4e0b\u9762\u5c31\u662f\u4f7f\u7528yum\u5b89\u88c5MySQL\u4e86,\u8fd9\u6b65\u53ef\u80fd\u4f1a\u82b1\u4e9b\u65f6\u95f4\uff0c\u5b89\u88c5\u5b8c\u6210\u540e\u5c31\u4f1a\u8986\u76d6\u6389\u4e4b\u524d\u7684mariadb\u3002<\/p>\n
\n\n\n
\n
1<\/span>
2<\/span>
3<\/span>
4<\/span>
5<\/span>
6<\/span>
7<\/span>
8<\/span>
9<\/span>
10<\/span>
11<\/span>
12<\/span>
13<\/span>
14<\/span>
15<\/span>
16<\/span>
17<\/span>
18<\/span>
19<\/span>
20<\/span>
21<\/span>
22<\/span>
23<\/span>
24<\/span>
25<\/span>
26<\/span>
27<\/span>
28<\/span>
29<\/span>
30<\/span>
31<\/span>
32<\/span>
33<\/span>
34<\/span>
35<\/span>
36<\/span>
37<\/span>
38<\/span>
39<\/span>
40<\/span>
41<\/span>
42<\/span>
43<\/span>
44<\/span>
45<\/span>
46<\/span>
47<\/span>
48<\/span>
49<\/span>
50<\/span>
51<\/span>
52<\/span>
53<\/span>
54<\/span>
55<\/span>
56<\/span>
57<\/span>
58<\/span>
59<\/span>
60<\/span>
61<\/span>
62<\/span>
63<\/span>
64<\/span>
65<\/span>
66<\/span>
67<\/span>
68<\/span>
69<\/span>
70<\/span>
71<\/span>
72<\/span>
73<\/span>
74<\/span>
75<\/span>
76<\/span>
77<\/span>
78<\/span>
79<\/span>
80<\/span>
81<\/span>
82<\/span>
83<\/span>
84<\/span>
85<\/span>
86<\/span>
87<\/span>
88<\/span>
89<\/span>
90<\/span>
91<\/span>
92<\/span>
93<\/span>
94<\/span>
95<\/span>
96<\/span>
97<\/span>
98<\/span>
99<\/span>
100<\/span>
101<\/span>
102<\/span>
103<\/span>
104<\/span>
105<\/span>
106<\/span>
107<\/span>
108<\/span>
109<\/span>
<\/pre>\n<\/td>\n
\n
[root@node02 ~]# yum -y install mysql-community-server<\/span>
Loaded plugins: fastestmirror<\/span>
Loading mirror speeds from cached hostfile<\/span>
 * base: mirror.jdcloud.com<\/span>
 * extras: mirror.jdcloud.com<\/span>
 * updates: mirrors.tuna.tsinghua.edu.cn<\/span>
mysql-connectors-community                                                  | 2.5 kB  00:00:00     <\/span>
mysql-tools-community                                                       | 2.5 kB  00:00:00     <\/span>
mysql57-community                                                           | 2.5 kB  00:00:00     <\/span>
(1\/3): mysql57-community\/x86_64\/primary_db                                  | 184 kB  00:00:01     <\/span>
(2\/3): mysql-tools-community\/x86_64\/primary_db                              |  61 kB  00:00:02     <\/span>
(3\/3): mysql-connectors-community\/x86_64\/primary_db                         |  44 kB  00:00:03     <\/span>
Resolving Dependencies<\/span>
--><\/span> Running transaction check<\/span><\/span>
---><\/span> Package mysql-community-server.x86_64 0:5.7.27-1.el7 will be installed<\/span><\/span>
--><\/span> Processing Dependency: mysql-community-common(x86-64) = 5.7.27-1.el7 for<\/span> package: mysql-community-server-5.7.27-1.el7.x86_64<\/span><\/span>
--><\/span> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for<\/span> package: mysql-community-server-5.7.27-1.el7.x86_64<\/span><\/span>
--><\/span> Running transaction check<\/span><\/span>
---><\/span> Package mysql-community-client.x86_64 0:5.7.27-1.el7 will be installed<\/span><\/span>
--><\/span> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for<\/span> package: mysql-community-client-5.7.27-1.el7.x86_64<\/span><\/span>
---><\/span> Package mysql-community-common.x86_64 0:5.7.27-1.el7 will be installed<\/span><\/span>
--><\/span> Running transaction check<\/span><\/span>
---><\/span> Package mariadb-libs.x86_64 1:5.5.60-1.el7_5 will be obsoleted<\/span><\/span>
--><\/span> Processing Dependency: libmysqlclient.so.18()(64bit) for<\/span> package: 2:postfix-2.10.1-7.el7.x86_64<\/span><\/span>
--><\/span> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for<\/span> package: 2:postfix-2.10.1-7.el7.x86_64<\/span><\/span>
---><\/span> Package mysql-community-libs.x86_64 0:5.7.27-1.el7 will be obsoleting<\/span><\/span>
--><\/span> Running transaction check<\/span><\/span>
---><\/span> Package mysql-community-libs-compat.x86_64 0:5.7.27-1.el7 will be obsoleting<\/span><\/span>
--><\/span> Finished Dependency Resolution<\/span><\/span>
<\/span>
Dependencies Resolved<\/span>
<\/span>
===================================================================================================<\/span>
 Package                           Arch         Version              Repository               Size<\/span>
===================================================================================================<\/span>
Installing:<\/span>
 mysql-community-libs              x86_64       5.7.27-1.el7         mysql57-community       2.2 M<\/span>
     replacing  mariadb-libs.x86_64 1:5.5.60-1.el7_5<\/span>
 mysql-community-libs-compat       x86_64       5.7.27-1.el7         mysql57-community       2.0 M<\/span>
     replacing  mariadb-libs.x86_64 1:5.5.60-1.el7_5<\/span>
 mysql-community-server            x86_64       5.7.27-1.el7         mysql57-community       165 M<\/span>
Installing for dependencies:<\/span>
 mysql-community-client            x86_64       5.7.27-1.el7         mysql57-community        24 M<\/span>
 mysql-community-common            x86_64       5.7.27-1.el7         mysql57-community       275 k<\/span>
<\/span>
Transaction Summary<\/span>
===================================================================================================<\/span>
Install  3 Packages (+2 Dependent packages)<\/span>
<\/span>
Total download size: 194 M<\/span>
Downloading packages:<\/span>
warning: \/var\/cache\/yum\/x86_64\/7\/mysql57-community\/packages\/mysql-community-common-5.7.27-1.el7.x86_64.rpm: Header V3 DSA\/SHA1 Signature, key ID 5072e1f5: NOKEY<\/span>
Public key for mysql-community-common-5.7.27-1.el7.x86_64.rpm is not installed<\/span>
(1\/5): mysql-community-common-5.7.27-1.el7.x86_64.rpm                       | 275 kB  00:00:01     <\/span>
(2\/5): mysql-community-libs-5.7.27-1.el7.x86_64.rpm                         | 2.2 MB  00:00:04     <\/span>
(3\/5): mysql-community-libs-compat-5.7.27-1.el7.x86_64.rpm                  | 2.0 MB  00:00:06     <\/span>
mysql-community-client-5.7.27- FAILED                                          18 MB 170:42:08 ETA <\/span>
http:\/\/repo.mysql.com\/yum\/mysql-5.7-community\/el\/7\/x86_64\/mysql-community-client-5.7.27-1.el7.x86_64.rpm: [Errno 12] Timeout on http:\/\/repo.mysql.com\/yum\/mysql-5.7-community\/el\/7\/x86_64\/mysql-community-client-5.7.27-1.el7.x86_64.rpm: (28, 'Operation too slow. Less than 1000 bytes\/sec transferred the last 30 seconds')<\/span>
Trying other mirror.<\/span>
mysql-community-server-5.7.27- FAILED                                          16 MB  --:--:-- ETA <\/span>
http:\/\/repo.mysql.com\/yum\/mysql-5.7-community\/el\/7\/x86_64\/mysql-community-server-5.7.27-1.el7.x86_64.rpm: [Errno 12] Timeout on http:\/\/repo.mysql.com\/yum\/mysql-5.7-community\/el\/7\/x86_64\/mysql-community-server-5.7.27-1.el7.x86_64.rpm: (28, 'Operation too slow. Less than 1000 bytes\/sec transferred the last 30 seconds')<\/span>
Trying other mirror.<\/span>
(4\/5): mysql-community-client-5.7.27-1.el7.x86_64.rpm                       |  24 MB  00:11:58     <\/span>
mysql-community-server-5.7.27- FAILED                                          4 MB 2600:47:50 ETA <\/span>
http:\/\/repo.mysql.com\/yum\/mysql-5.7-community\/el\/7\/x86_64\/mysql-community-server-5.7.27-1.el7.x86_64.rpm: [Errno 12] Timeout on http:\/\/repo.mysql.com\/yum\/mysql-5.7-community\/el\/7\/x86_64\/mysql-community-server-5.7.27-1.el7.x86_64.rpm: (28, 'Operation too slow. Less than 1000 bytes\/sec transferred the last 30 seconds')<\/span>
Trying other mirror.<\/span>
(5\/5): mysql-community-server-5.7.27-1.el7.x86_64.rpm                       | 165 MB  00:07:44     <\/span>
---------------------------------------------------------------------------------------------------<\/span>
Total                                                              148 kB\/s | 194 MB  00:22:20     <\/span>
Retrieving key from file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql<\/span>
Importing GPG key 0x5072E1F5:<\/span>
 Userid     : \"MySQL Release Engineering <mysql-build@oss.oracle.com>\"<\/span>
 Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5<\/span>
 Package    : mysql57-community-release-el7-10.noarch (installed)<\/span>
 From       : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql<\/span>
Running transaction check<\/span>
Running transaction test<\/span>
Transaction test succeeded<\/span>
Running transaction<\/span>
  Installing : mysql-community-common-5.7.27-1.el7.x86_64                                      1\/6 <\/span>
  Installing : mysql-community-libs-5.7.27-1.el7.x86_64                                        2\/6 <\/span>
  Installing : mysql-community-client-5.7.27-1.el7.x86_64                                      3\/6 <\/span>
  Installing : mysql-community-server-5.7.27-1.el7.x86_64                                      4\/6 <\/span>
  Installing : mysql-community-libs-compat-5.7.27-1.el7.x86_64                                 5\/6 <\/span>
  Erasing    : 1:mariadb-libs-5.5.60-1.el7_5.x86_64                                            6\/6 <\/span>
  Verifying  : mysql-community-libs-compat-5.7.27-1.el7.x86_64                                 1\/6 <\/span>
  Verifying  : mysql-community-common-5.7.27-1.el7.x86_64                                      2\/6 <\/span>
  Verifying  : mysql-community-server-5.7.27-1.el7.x86_64                                      3\/6 <\/span>
  Verifying  : mysql-community-client-5.7.27-1.el7.x86_64                                      4\/6 <\/span>
  Verifying  : mysql-community-libs-5.7.27-1.el7.x86_64                                        5\/6 <\/span>
  Verifying  : 1:mariadb-libs-5.5.60-1.el7_5.x86_64                                            6\/6 <\/span>
<\/span>
Installed:<\/span>
  mysql-community-libs.x86_64 0:5.7.27-1.el7    mysql-community-libs-compat.x86_64 0:5.7.27-1.el7 <\/span>
  mysql-community-server.x86_64 0:5.7.27-1.el7 <\/span>
<\/span>
Dependency Installed:<\/span>
  mysql-community-client.x86_64 0:5.7.27-1.el7     mysql-community-common.x86_64 0:5.7.27-1.el7    <\/span>
<\/span>
Replaced:<\/span>
  mariadb-libs.x86_64 1:5.5.60-1.el7_5                                                             <\/span>
#<\/span>\u63d0\u793a\u5b89\u88c5\u5b8c\u6210,\u8868\u793a\u5b89\u88c5\u6210\u529f<\/span><\/span>
Complete!<\/span>
You have new mail in \/var\/spool\/mail\/root<\/span>
<\/span>
#<\/span>\u5df2\u7ecf\u67e5\u8be2\u4e0d\u5230mariadb\u6570\u636e\u5e93\u4e86<\/span><\/span>
[root@node02 ~]# rpm -qa|grep mariadb<\/span>
You have new mail in \/var\/spool\/mail\/root<\/span>
[root@node02 ~]#<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
<\/a>3. MySQL\u6570\u636e\u5e93\u8bbe\u7f6e<\/h2>\n
\u9996\u5148\u542f\u52a8MySQL<\/p>\n
\n\n\n
\n
1<\/span>
2<\/span>
3<\/span>
4<\/span>
5<\/span>
6<\/span>
7<\/span>
8<\/span>
9<\/span>
10<\/span>
11<\/span>
12<\/span>
13<\/span>
14<\/span>
15<\/span>
16<\/span>
17<\/span>
18<\/span>
19<\/span>
<\/pre>\n<\/td>\n
\n
#<\/span>\u542f\u52a8mysql\u670d\u52a1<\/span><\/span>
[root@node02 ~]# systemctl start  mysqld.service<\/span>
#<\/span>\u67e5\u770bmysql\u8fd0\u884c\u72b6\u6001<\/span><\/span>
[root@node02 ~]# systemctl status  mysqld.service  <\/span>
\u25cf mysqld.service - MySQL Server<\/span>
   Loaded: loaded (\/usr\/lib\/systemd\/system\/mysqld.service; enabled; vendor preset: disabled)<\/span>
   #<\/span>\u8868\u793a\u5df2\u7ecf\u542f\u52a8(linux)<\/span><\/span>
   Active: active (running) since Fri 2019-10-11 15:14:57 CST; 6s ago<\/span>
     Docs: man:mysqld(8)<\/span>
           http:\/\/dev.mysql.com\/doc\/refman\/en\/using-systemd.html<\/span>
  Process: 22525 ExecStart=\/usr\/sbin\/mysqld --daemonize --pid-file=\/var\/run\/mysqld\/mysqld.pid $MYSQLD_OPTS (code=exited, status=0\/SUCCESS)<\/span>
  Process: 22449 ExecStartPre=\/usr\/bin\/mysqld_pre_systemd (code=exited, status=0\/SUCCESS)<\/span>
 Main PID: 22528 (mysqld)<\/span>
   CGroup: \/system.slice\/mysqld.service<\/span>
           \u2514\u250022528 \/usr\/sbin\/mysqld --daemonize --pid-file=\/var\/run\/mysqld\/mysqld.pid<\/span>
<\/span>
Oct 11 15:14:54 node02.kaikeba.com systemd[1]: Starting MySQL Server...<\/span>
Oct 11 15:14:57 node02.kaikeba.com systemd[1]: Started MySQL Server.<\/span>
[root@node02 ~]#<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
\u6b64\u65f6MySQL\u5df2\u7ecf\u5f00\u59cb\u6b63\u5e38\u8fd0\u884c\uff0c\u4e0d\u8fc7\u8981\u60f3\u8fdb\u5165MySQL\u8fd8\u5f97\u5148\u627e\u51fa\u6b64\u65f6root\u7528\u6237\u7684\u5bc6\u7801\uff0c\u901a\u8fc7\u5982\u4e0b\u547d\u4ee4\u53ef\u4ee5\u5728\u65e5\u5fd7\u6587\u4ef6\u4e2d\u627e\u51fa\u5bc6\u7801\uff1a<\/p>\n
\n\n\n
\n
1<\/span>
2<\/span>
3<\/span>
4<\/span>
5<\/span>
<\/pre>\n<\/td>\n
\n
#<\/span>\u67e5\u627e\u5230root\u7528\u6237\u767b\u5f55mysql\u6570\u636e\u5e93\u7684\u5bc6\u7801:7UOv>SVzygyB<\/span><\/span>
[root@node02 ~]# grep \"password\" \/var\/log\/mysqld.log<\/span>
2019-10-11T07:14:54.482816Z 1 [Note] A temporary password is generated for root@localhost: 7UOv>SVzygyB<\/span>
You have new mail in \/var\/spool\/mail\/root<\/span>
[root@node02 ~]#<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
\u547d\u4ee4\u8fdb\u5165\u6570\u636e\u5e93\uff1a<\/p>\n
\n\n\n
\n
1<\/span>
2<\/span>
3<\/span>
4<\/span>
5<\/span>
6<\/span>
7<\/span>
8<\/span>
9<\/span>
10<\/span>
11<\/span>
12<\/span>
13<\/span>
14<\/span>
15<\/span>
16<\/span>
17<\/span>
18<\/span>
19<\/span>
20<\/span>
21<\/span>
22<\/span>
23<\/span>
24<\/span>
25<\/span>
26<\/span>
27<\/span>
28<\/span>
29<\/span>
30<\/span>
31<\/span>
32<\/span>
33<\/span>
34<\/span>
35<\/span>
36<\/span>
37<\/span>
38<\/span>
39<\/span>
40<\/span>
41<\/span>
42<\/span>
43<\/span>
44<\/span>
45<\/span>
46<\/span>
47<\/span>
48<\/span>
49<\/span>
50<\/span>
51<\/span>
52<\/span>
53<\/span>
54<\/span>
55<\/span>
56<\/span>
57<\/span>
58<\/span>
59<\/span>
60<\/span>
61<\/span>
62<\/span>
63<\/span>
64<\/span>
65<\/span>
66<\/span>
67<\/span>
68<\/span>
69<\/span>
70<\/span>
71<\/span>
72<\/span>
73<\/span>
74<\/span>
75<\/span>
76<\/span>
77<\/span>
78<\/span>
79<\/span>
80<\/span>
81<\/span>
82<\/span>
83<\/span>
84<\/span>
85<\/span>
86<\/span>
87<\/span>
88<\/span>
89<\/span>
90<\/span>
91<\/span>
92<\/span>
93<\/span>
94<\/span>
95<\/span>
96<\/span>
97<\/span>
98<\/span>
99<\/span>
100<\/span>
101<\/span>
<\/pre>\n<\/td>\n
\n
[root@node02 ~]# mysql -u root -p<\/span>
Enter password: <\/span>
Welcome to the MySQL monitor.  Commands end with ; or g.<\/span>
Your MySQL connection id is 3<\/span>
Server version: 5.7.27<\/span>
<\/span>
Copyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.<\/span>
<\/span>
Oracle is a registered trademark of Oracle Corporation and\/or its<\/span>
affiliates. Other names may be trademarks of their respective<\/span>
owners.<\/span>
<\/span>
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.<\/span>
<\/span>
mysql><\/span> show databases;<\/span><\/span>
#<\/span>\u63d0\u793a\u4fee\u6539\u521d\u59cb\u5bc6\u7801<\/span><\/span>
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.<\/span>
mysql><\/span> show databases;<\/span><\/span>
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.<\/span>
#<\/span>\u6ce8\u610f\u5bc6\u7801\u8bbe\u7f6e\u4e0d\u80fd\u8fc7\u4e8e\u7b80\u5355\uff0cmysql\u6709\u5bc6\u7801\u8bbe\u7f6e\u89c4\u8303\uff08\u7279\u6b8a\u5b57\u7b26\u3001\u5b57\u6bcd\u5927\u5c0f\u5199\uff0c\u6570\u5b57\u4e09\u8005\u7684\u7ec4\u5408\uff09<\/span><\/span>
mysql><\/span> ALTER USER 'root'<\/span>@'localhost'<\/span> IDENTIFIED BY '!Qaz123456'<\/span>;<\/span><\/span>
#<\/span>\u6dfb\u52a0scm\u7528\u6237\u5bf9scm\u5e93\u7684\u8bbf\u95ee\u6743\u9650<\/span><\/span>
mysql><\/span> grant all on scm.* to scm@'%'<\/span> identified by '!Qaz123456'<\/span>;<\/span><\/span>
Query OK, 0 rows affected, 1 warning (0.01 sec)<\/span>
<\/span>
mysql><\/span> select user,host from user;<\/span><\/span>
+---------------+-----------+<\/span>
| user          | host      |<\/span>
+---------------+-----------+<\/span>
| scm           | %         |<\/span>
| mysql.session | localhost |<\/span>
| mysql.sys     | localhost |<\/span>
| root          | localhost |<\/span>
+---------------+-----------+<\/span>
4 rows in set (0.01 sec)<\/span>
<\/span>
#<\/span>\u5237\u65b0\u8bbf\u95ee\u6743\u9650\u7684\u8bbe\u7f6e,\u8fd9\u4e00\u6b65\u975e\u5e38\u91cd\u8981\uff0c\u5982\u679c\u6ca1\u6709\u64cd\u4f5c\uff0cscm\u8fdc\u7a0b\u8bbf\u95eemysql\u6570\u636e\u5e93\u5c31\u5931\u8d25.<\/span><\/span>
mysql><\/span> flush privileges;<\/span><\/span>
Query OK, 0 rows affected (0.01 sec)<\/span>
<\/span>
#<\/span>\u6dfb\u52a0root\u7528\u6237\u8fdc\u7a0b\u8bbf\u95ee\u6570\u636e\u5e93<\/span><\/span>
mysql><\/span>grant all on *.* to root@'%'<\/span> identified by '!Qaz123456'<\/span>;<\/span><\/span>
mysql><\/span> flush privileges;<\/span><\/span>
mysql><\/span> select user,host from user;<\/span><\/span>
+---------------+-----------+<\/span>
| user          | host      |<\/span>
+---------------+-----------+<\/span>
| root          | %         |<\/span>
| scm           | %         |<\/span>
| mysql.session | localhost |<\/span>
| mysql.sys     | localhost |<\/span>
| root          | localhost |<\/span>
+---------------+-----------+<\/span>
5 rows in set (0.00 sec)<\/span>
<\/span>
mysql><\/span> delete from user where<\/span> user='root'<\/span> and host='localhost'<\/span>;<\/span><\/span>
Query OK, 1 row affected (0.02 sec)<\/span>
<\/span>
mysql><\/span> select user,host from user;<\/span><\/span>
+---------------+-----------+<\/span>
| user          | host      |<\/span>
+---------------+-----------+<\/span>
| root          | %         |<\/span>
| scm           | %         |<\/span>
| mysql.session | localhost |<\/span>
| mysql.sys     | localhost |<\/span>
+---------------+-----------+<\/span>
4 rows in set (0.00 sec)<\/span>
<\/span>
mysql><\/span> flush privileges;<\/span><\/span>
<\/span>
#<\/span>\u521b\u5efascm\u6570\u636e\u5e93<\/span><\/span>
mysql><\/span> create database scm;<\/span><\/span>
Query OK, 1 row affected (0.01 sec)<\/span>
<\/span>
mysql><\/span> show databases;<\/span><\/span>
+--------------------+<\/span>
| Database           |<\/span>
+--------------------+<\/span>
| information_schema |<\/span>
| mysql              |<\/span>
| performance_schema |<\/span>
| scm                |<\/span>
| sys                |<\/span>
+--------------------+<\/span>
5 rows in set (0.00 sec)<\/span>
<\/span>
<\/span>
mysql><\/span> update mysql.user set<\/span> Grant_priv='Y'<\/span>,Super_priv='Y'<\/span> where<\/span> user = 'root'<\/span> and host = '%'<\/span>;<\/span><\/span>
Query OK, 1 row affected (0.00 sec)<\/span>
Rows matched: 1  Changed: 1  Warnings: 0<\/span>
<\/span>
mysql><\/span> flush privileges;<\/span><\/span>
Query OK, 0 rows affected (0.00 sec)<\/span>
<\/span>
mysql><\/span> quit<\/span><\/span>
Bye<\/span>
You have new mail in \/var\/spool\/mail\/root<\/span>
#<\/span>\u4ece\u8d77mysql\u670d\u52a1<\/span><\/span>
[root@node02 ~]# systemctl restart mysqld.service<\/span>
[root@node02 ~]#<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n","protected":false},"excerpt":{"rendered":"
\u5728CentOS7\u4e2d\u9ed8\u8ba4\u5b89\u88c5\u6709Mar…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/131829"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=131829"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/131829\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=131829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=131829"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=131829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}