学习笔记-MySQL数据库RPM安装 20210127
RPM安装SQL数据库
从最新版本的linux系统开始，默认的是 Mariadb而不是mysql！这里依旧以mysql为例进行展示
安装之前先检查系统是否装有mysql ，这里返回空值，说明没有安装 。
WARNING! The remote SSH server rejected X11 forwarding request. Last login: Wed Jan 27 19:44:59 2021 from 192.168.0.103 [root@localhost ~]# rpm -qa | grep mysql（#这里返回空值，说明没有安装）
[root@localhost ~]#
这里执行安装命令是无效的，因为centos-7默认是Mariadb，所以执行以下命令只是更新Mariadb数据库。
#安装可用：yum install mysql
#删除可用：yum remove mysql
一、安装sql
1 [root@localhost ~]# 2 [root@localhost ~]# yum install mysql（#开始安装） 3 Loaded plugins: fastestmirror 4 Determining fastest mirrors 5 * base: mirrors.njupt.edu.cn 6 * extras: mirrors.njupt.edu.cn 7 * updates: ty1.mirror.newmediaexpress.com 8 base | 3.6 kB 00:00:00 9 extras | 2.9 kB 00:00:00 10 updates | 2.9 kB 00:00:00 11 (1/4): base/7/x86_64/group_gz | 153 kB 00:00:01 12 (2/4): extras/7/x86_64/primary_db | 222 kB 00:00:00 13 (3/4): base/7/x86_64/primary_db | 6.1 MB 00:00:01 14 (4/4): updates/7/x86_64/primary_db | 4.7 MB 00:00:11 15 Resolving Dependencies 16 --> Running transaction check 17 ---> Package mariadb.x86_64 1:5.5.68-1.el7 will be installed 18 --> Processing Dependency: perl(Sys::Hostname) for package: 1:mariadb-5.5.68-1.el7.x86_64 19 --> Processing Dependency: perl(IPC::Open3) for package: 1:mariadb-5.5.68-1.el7.x86_64 20 --> Processing Dependency: perl(Getopt::Long) for package: 1:mariadb-5.5.68-1.el7.x86_64 21 --> Processing Dependency: perl(File::Temp) for package: 1:mariadb-5.5.68-1.el7.x86_64 22 --> Processing Dependency: perl(Fcntl) for package: 1:mariadb-5.5.68-1.el7.x86_64 23 --> Processing Dependency: perl(Exporter) for package: 1:mariadb-5.5.68-1.el7.x86_64 24 --> Processing Dependency: /usr/bin/perl for package: 1:mariadb-5.5.68-1.el7.x86_64 25 --> Running transaction check 26 ---> Package perl.x86_64 4:5.16.3-297.el7 will be installed 27 --> Processing Dependency: perl-libs = 4:5.16.3-297.el7 for package: 4:perl-5.16.3-297.el7.x86_64 28 --> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-297.el7.x86_64 29 --> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-297.el7.x86_64 30 --> Processing Dependency: perl-macros for package: 4:perl-5.16.3-297.el7.x86_64 31 --> Processing Dependency: perl-libs for package: 4:perl-5.16.3-297.el7.x86_64 32 --> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-297.el7.x86_64 33 --> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-297.el7.x86_64 34 --> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-297.el7.x86_64 35 --> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-297.el7.x86_64 36 --> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-297.el7.x86_64 37 --> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-297.el7.x86_64 38 --> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-297.el7.x86_64 39 --> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-297.el7.x86_64 40 --> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-297.el7.x86_64 41 --> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-297.el7.x86_64 42 --> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-297.el7.x86_64 43 --> Processing Dependency: perl(File::Spec::Unix) for package: 4:perl-5.16.3-297.el7.x86_64 44 --> Processing Dependency: perl(File::Spec::Functions) for package: 4:perl-5.16.3-297.el7.x86_64 45 --> Processing Dependency: perl(File::Spec) for package: 4:perl-5.16.3-297.el7.x86_64 46 --> Processing Dependency: perl(File::Path) for package: 4:perl-5.16.3-297.el7.x86_64 47 --> Processing Dependency: perl(Cwd) for package: 4:perl-5.16.3-297.el7.x86_64 48 --> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-297.el7.x86_64 49 --> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-297.el7.x86_64 50 ---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed 51 ---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed 52 ---> Package perl-Getopt-Long.noarch 0:2.40-3.el7 will be installed 53 --> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-3.el7.noarch 54 --> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-3.el7.noarch 55 --> Running transaction check 56 ---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed 57 ---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed 58 ---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed 59 ---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed 60 ---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed 61 --> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch 62 --> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch 63 ---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed 64 --> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch 65 --> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch 66 ---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed 67 ---> Package perl-Socket.x86_64 0:2.010-5.el7 will be installed 68 ---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed 69 ---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed 70 ---> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed 71 ---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed 72 ---> Package perl-constant.noarch 0:1.27-2.el7 will be installed 73 ---> Package perl-libs.x86_64 4:5.16.3-297.el7 will be installed 74 ---> Package perl-macros.x86_64 4:5.16.3-297.el7 will be installed 75 ---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed 76 ---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed 77 --> Running transaction check 78 ---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed 79 ---> Package perl-Pod-Escapes.noarch 1:1.04-297.el7 will be installed 80 ---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed 81 --> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch 82 --> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch 83 ---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed 84 --> Running transaction check 85 ---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed 86 ---> Package perl-parent.noarch 1:0.225-244.el7 will be installed 87 --> Finished Dependency Resolution 88 89 Dependencies Resolved 90 91 ======================================================================================================================================== 92 Package Arch Version Repository Size 93 ======================================================================================================================================== 94 Installing: 95 mariadb x86_64 1:5.5.68-1.el7 base 8.8 M 96 Installing for dependencies: 97 perl x86_64 4:5.16.3-297.el7 base 8.0 M 98 perl-Carp noarch 1.26-244.el7 base 19 k 99 perl-Encode x86_64 2.51-7.el7 base 1.5 M 100 perl-Exporter noarch 5.68-3.el7 base 28 k 101 perl-File-Path noarch 2.09-2.el7 base 26 k 102 perl-File-Temp noarch 0.23.01-3.el7 base 56 k 103 perl-Filter x86_64 1.49-3.el7 base 76 k 104 perl-Getopt-Long noarch 2.40-3.el7 base 56 k 105 perl-HTTP-Tiny noarch 0.033-3.el7 base 38 k 106 perl-PathTools x86_64 3.40-5.el7 base 82 k 107 perl-Pod-Escapes noarch 1:1.04-297.el7 base 52 k 108 perl-Pod-Perldoc noarch 3.20-4.el7 base 87 k 109 perl-Pod-Simple noarch 1:3.28-4.el7 base 216 k 110 perl-Pod-Usage noarch 1.63-3.el7 base 27 k 111 perl-Scalar-List-Utils x86_64 1.27-248.el7 base 36 k 112 perl-Socket x86_64 2.010-5.el7 base 49 k 113 perl-Storable x86_64 2.45-3.el7 base 77 k 114 perl-Text-ParseWords noarch 3.29-4.el7 base 14 k 115 perl-Time-HiRes x86_64 4:1.9725-3.el7 base 45 k 116 perl-Time-Local noarch 1.2300-2.el7 base 24 k 117 perl-constant noarch 1.27-2.el7 base 19 k 118 perl-libs x86_64 4:5.16.3-297.el7 base 689 k 119 perl-macros x86_64 4:5.16.3-297.el7 base 44 k 120 perl-parent noarch 1:0.225-244.el7 base 12 k 121 perl-podlators noarch 2.5.1-3.el7 base 112 k 122 perl-threads x86_64 1.87-4.el7 base 49 k 123 perl-threads-shared x86_64 1.43-6.el7 base 39 k 124 125 Transaction Summary 126 ======================================================================================================================================== 127 Install 1 Package (+27 Dependent packages) 128 129 Total download size: 20 M 130 Installed size: 85 M 131 Is this ok [y/d/N]: y 132 Downloading packages: 133 warning: /var/cache/yum/x86_64/7/base/packages/perl-5.16.3-297.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEYTA 134 Public key for perl-5.16.3-297.el7.x86_64.rpm is not installed 135 (1/28): perl-5.16.3-297.el7.x86_64.rpm | 8.0 MB 00:00:02 136 (2/28): perl-Carp-1.26-244.el7.noarch.rpm | 19 kB 00:00:00 137 (3/28): perl-Encode-2.51-7.el7.x86_64.rpm | 1.5 MB 00:00:00 138 (4/28): perl-Exporter-5.68-3.el7.noarch.rpm | 28 kB 00:00:00 139 (5/28): perl-File-Path-2.09-2.el7.noarch.rpm | 26 kB 00:00:00 140 (6/28): perl-File-Temp-0.23.01-3.el7.noarch.rpm | 56 kB 00:00:00 141 (7/28): perl-Filter-1.49-3.el7.x86_64.rpm | 76 kB 00:00:00 142 (8/28): perl-Getopt-Long-2.40-3.el7.noarch.rpm | 56 kB 00:00:00 143 (9/28): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm | 38 kB 00:00:00 144 (10/28): perl-PathTools-3.40-5.el7.x86_64.rpm | 82 kB 00:00:00 145 (11/28): perl-Pod-Escapes-1.04-297.el7.noarch.rpm | 52 kB 00:00:00 146 (12/28): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm | 87 kB 00:00:00 147 (13/28): mariadb-5.5.68-1.el7.x86_64.rpm | 8.8 MB 00:00:03 148 (14/28): perl-Pod-Simple-3.28-4.el7.noarch.rpm | 216 kB 00:00:00 149 (15/28): perl-Pod-Usage-1.63-3.el7.noarch.rpm | 27 kB 00:00:00 150 (16/28): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm | 36 kB 00:00:00 151 (17/28): perl-Socket-2.010-5.el7.x86_64.rpm | 49 kB 00:00:00 152 (18/28): perl-Storable-2.45-3.el7.x86_64.rpm | 77 kB 00:00:00 153 (19/28): perl-Text-ParseWords-3.29-4.el7.noarch.rpm | 14 kB 00:00:00 154 (20/28): perl-Time-HiRes-1.9725-3.el7.x86_64.rpm | 45 kB 00:00:00 155 (21/28): perl-Time-Local-1.2300-2.el7.noarch.rpm | 24 kB 00:00:00 156 (22/28): perl-constant-1.27-2.el7.noarch.rpm | 19 kB 00:00:00 157 (23/28): perl-macros-5.16.3-297.el7.x86_64.rpm | 44 kB 00:00:00 158 (24/28): perl-parent-0.225-244.el7.noarch.rpm | 12 kB 00:00:00 159 (25/28): perl-podlators-2.5.1-3.el7.noarch.rpm | 112 kB 00:00:00 160 (26/28): perl-threads-1.87-4.el7.x86_64.rpm | 49 kB 00:00:00 161 (27/28): perl-libs-5.16.3-297.el7.x86_64.rpm | 689 kB 00:00:00 162 (28/28): perl-threads-shared-1.43-6.el7.x86_64.rpm | 39 kB 00:00:00 163 ---------------------------------------------------------------------------------------------------------------------------------------- 164 Total 5.5 MB/s | 20 MB 00:00:03 165 Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 166 Importing GPG key 0xF4A80EB5: 167 Userid : "CentOS-7 Key (CentOS 7 Official Signing Key) <security@centos.org>" 168 Fingerprint: 6341 ab27 53d7 8a78 a7c2 7bb1 24c6 a8a7 f4a8 0eb5 169 Package : centos-release-7-9.2009.0.el7.centos.x86_64 (@anaconda) 170 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 171 Is this ok [y/N]: y 172 Running transaction check 173 Running transaction test 174 Transaction test succeeded 175 Running transaction 176 Installing : 1:perl-parent-0.225-244.el7.noarch 1/28 177 Installing : perl-HTTP-Tiny-0.033-3.el7.noarch 2/28 178 Installing : perl-podlators-2.5.1-3.el7.noarch 3/28 179 Installing : perl-Pod-Perldoc-3.20-4.el7.noarch 4/28 180 Installing : 1:perl-Pod-Escapes-1.04-297.el7.noarch 5/28 181 Installing : perl-Encode-2.51-7.el7.x86_64 6/28 182 Installing : perl-Text-ParseWords-3.29-4.el7.noarch 7/28 183 Installing : perl-Pod-Usage-1.63-3.el7.noarch 8/28 184 Installing : 4:perl-libs-5.16.3-297.el7.x86_64 9/28 185 Installing : perl-Storable-2.45-3.el7.x86_64 10/28 186 Installing : perl-Exporter-5.68-3.el7.noarch 11/28 187 Installing : perl-constant-1.27-2.el7.noarch 12/28 188 Installing : perl-Socket-2.010-5.el7.x86_64 13/28 189 Installing : perl-Time-Local-1.2300-2.el7.noarch 14/28 190 Installing : perl-Carp-1.26-244.el7.noarch 15/28 191 Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64 16/28 192 Installing : perl-PathTools-3.40-5.el7.x86_64 17/28 193 Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64 18/28 194 Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch 19/28 195 Installing : perl-File-Temp-0.23.01-3.el7.noarch 20/28 196 Installing : perl-File-Path-2.09-2.el7.noarch 21/28 197 Installing : perl-threads-shared-1.43-6.el7.x86_64 22/28 198 Installing : perl-threads-1.87-4.el7.x86_64 23/28 199 Installing : perl-Filter-1.49-3.el7.x86_64 24/28 200 Installing : 4:perl-macros-5.16.3-297.el7.x86_64 25/28 201 Installing : perl-Getopt-Long-2.40-3.el7.noarch 26/28 202 Installing : 4:perl-5.16.3-297.el7.x86_64 27/28 203 Installing : 1:mariadb-5.5.68-1.el7.x86_64 28/28 204 Verifying : perl-HTTP-Tiny-0.033-3.el7.noarch 1/28 205 Verifying : perl-threads-shared-1.43-6.el7.x86_64 2/28 206 Verifying : perl-Storable-2.45-3.el7.x86_64 3/28 207 Verifying : 4:perl-libs-5.16.3-297.el7.x86_64 4/28 208 Verifying : perl-Exporter-5.68-3.el7.noarch 5/28 209 Verifying : perl-constant-1.27-2.el7.noarch 6/28 210 Verifying : perl-PathTools-3.40-5.el7.x86_64 7/28 211 Verifying : perl-Socket-2.010-5.el7.x86_64 8/28 212 Verifying : 1:perl-parent-0.225-244.el7.noarch 9/28 213 Verifying : 1:perl-Pod-Escapes-1.04-297.el7.noarch 10/28 214 Verifying : perl-File-Temp-0.23.01-3.el7.noarch 11/28 215 Verifying : 1:perl-Pod-Simple-3.28-4.el7.noarch 12/28 216 Verifying : perl-Time-Local-1.2300-2.el7.noarch 13/28 217 Verifying : perl-Carp-1.26-244.el7.noarch 14/28 218 Verifying : 4:perl-Time-HiRes-1.9725-3.el7.x86_64 15/28 219 Verifying : perl-Scalar-List-Utils-1.27-248.el7.x86_64 16/28 220 Verifying : perl-Pod-Usage-1.63-3.el7.noarch 17/28 221 Verifying : perl-Encode-2.51-7.el7.x86_64 18/28 222 Verifying : perl-Pod-Perldoc-3.20-4.el7.noarch 19/28 223 Verifying : perl-podlators-2.5.1-3.el7.noarch 20/28 224 Verifying : perl-File-Path-2.09-2.el7.noarch 21/28 225 Verifying : perl-threads-1.87-4.el7.x86_64 22/28 226 Verifying : 1:mariadb-5.5.68-1.el7.x86_64 23/28 227 Verifying : perl-Filter-1.49-3.el7.x86_64 24/28 228 Verifying : perl-Getopt-Long-2.40-3.el7.noarch 25/28 229 Verifying : perl-Text-ParseWords-3.29-4.el7.noarch 26/28 230 Verifying : 4:perl-5.16.3-297.el7.x86_64 27/28 231 Verifying : 4:perl-macros-5.16.3-297.el7.x86_64 28/28 232 233 Installed: 234 mariadb.x86_64 1:5.5.68-1.el7 235 236 Dependency Installed: 237 perl.x86_64 4:5.16.3-297.el7 perl-Carp.noarch 0:1.26-244.el7 perl-Encode.x86_64 0:2.51-7.el7 238 perl-Exporter.noarch 0:5.68-3.el7 perl-File-Path.noarch 0:2.09-2.el7 perl-File-Temp.noarch 0:0.23.01-3.el7 239 perl-Filter.x86_64 0:1.49-3.el7 perl-Getopt-Long.noarch 0:2.40-3.el7 perl-HTTP-Tiny.noarch 0:0.033-3.el7 240 perl-PathTools.x86_64 0:3.40-5.el7 perl-Pod-Escapes.noarch 1:1.04-297.el7 perl-Pod-Perldoc.noarch 0:3.20-4.el7 241 perl-Pod-Simple.noarch 1:3.28-4.el7 perl-Pod-Usage.noarch 0:1.63-3.el7 perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 242 perl-Socket.x86_64 0:2.010-5.el7 perl-Storable.x86_64 0:2.45-3.el7 perl-Text-ParseWords.noarch 0:3.29-4.el7 243 perl-Time-HiRes.x86_64 4:1.9725-3.el7 perl-Time-Local.noarch 0:1.2300-2.el7 perl-constant.noarch 0:1.27-2.el7 244 perl-libs.x86_64 4:5.16.3-297.el7 perl-macros.x86_64 4:5.16.3-297.el7 perl-parent.noarch 1:0.225-244.el7 245 perl-podlators.noarch 0:2.5.1-3.el7 perl-threads.x86_64 0:1.87-4.el7 perl-threads-shared.x86_64 0:1.43-6.el7
Complete!
二、下载mysql的repo源
2.1下载 # wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
[root@localhost ~]# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm -bash: wget: command not found
2.2 当使用wget下载linux下的类库的时候，出现的问题，这里已经说了，主要是linux 下没有找到wget 这个库，所以我们可以进行更新一下：
使用yum进行安装： yum -y install wget
[root@localhost ~]# yum -y install wget（#安装wget 这个库）
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.njupt.edu.cn
* extras: mirrors.njupt.edu.cn
* updates: ty1.mirror.newmediaexpress.com
Resolving Dependencies
--> Running transaction check
---> Package wget.x86_64 0:1.14-18.el7_6.1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================
Installing:
wget x86_64 1.14-18.el7_6.1 base 547 k
Transaction Summary
========================================================================================================================================
Install 1 Package
Total download size: 547 k
Installed size: 2.0 M
Downloading packages:
wget-1.14-18.el7_6.1.x86_64.rpm | 547 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : wget-1.14-18.el7_6.1.x86_64 1/1
Verifying : wget-1.14-18.el7_6.1.x86_64 1/1
Installed:
wget.x86_64 0:1.14-18.el7_6.1
Complete!
2.3 继续下载mysql的repo源：
1 [root@localhost ~]# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm 2 --2021-01-27 20:36:15-- http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm 3 Resolving repo.mysql.com (repo.mysql.com)... 96.17.188.242 4 Connecting to repo.mysql.com (repo.mysql.com)|96.17.188.242|:80... connected. 5 HTTP request sent, awaiting response... 200 OK 6 Length: 6140 (6.0K) [application/x-redhat-package-manager] 7 Saving to: ‘mysql-community-release-el7-5.noarch.rpm’ 8 9 100%[============================================================================================================================================>] 6,140 10 11 2021-01-27 20:36:17 (26.1 KB/s) - ‘mysql-community-release-el7-5.noarch.rpm’ saved [6140/6140]
2.4继续安装mysql-community-release-el7-5.noarch.rpm包
[root@localhost ~]# rpm -qa | grep mysql（# rpm -qa | gerp [软件名称] # 查询软件是否被安装）
mysql-community-release-el7-5.noarch
1 [root@localhost ~]# sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm 2 Preparing... ################################# [100%] 3 Updating / installing... 4 1:mysql-community-release-el7-5 ################################# [100%]
2.5安装这个包后，会获得两个mysql的yum repo源：
/etc/yum.repos.d/mysql-community.repo，
/etc/yum.repos.d/mysql-community-source.repo
1 [root@localhost ~]# cd /etc/yum.repos.d（#打开etc目录查看一下） 2 [root@localhost yum.repos.d]# ls 3 CentOS-Base.repo CentOS-Debuginfo.repo CentOS-Media.repo CentOS-Vault.repo mysql-community.repo 4 CentOS-CR.repo CentOS-fasttrack.repo CentOS-Sources.repo CentOS-x86_64-kernel.repo mysql-community-source.repo 5 [root@localhost yum.repos.d]#
2.6、正式安装mysql
# sudo yum install mysql-server
1 [root@localhost yum.repos.d]# sudo yum install mysql-server（#安装mysql） 2 Loaded plugins: fastestmirror 3 Loading mirror speeds from cached hostfile 4 * base: mirrors.njupt.edu.cn 5 * extras: mirrors.njupt.edu.cn 6 * updates: ty1.mirror.newmediaexpress.com 7 mysql-connectors-community | 2.6 kB 00:00:00 8 mysql-tools-community | 2.6 kB 00:00:02 9 mysql56-community | 2.6 kB 00:00:01 10 (1/3): mysql-connectors-community/x86_64/primary_db | 72 kB 00:00:04 11 (2/3): mysql56-community/x86_64/primary_db | 297 kB 00:00:06 12 (3/3): mysql-tools-community/x86_64/primary_db | 85 kB 00:00:08 13 Resolving Dependencies 14 --> Running transaction check 15 ---> Package mysql-community-server.x86_64 0:5.6.51-2.el7 will be installed 16 --> Processing Dependency: mysql-community-common(x86-64) = 5.6.51-2.el7 for package: mysql-community-server-5.6.51-2.el7.x86_64 17 --> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.51-2.el7.x86_64 18 --> Processing Dependency: net-tools for package: mysql-community-server-5.6.51-2.el7.x86_64 19 --> Processing Dependency: perl(DBI) for package: mysql-community-server-5.6.51-2.el7.x86_64 20 --> Processing Dependency: perl(Data::Dumper) for package: mysql-community-server-5.6.51-2.el7.x86_64 21 --> Running transaction check 22 ---> Package mariadb.x86_64 1:5.5.68-1.el7 will be obsoleted 23 ---> Package mysql-community-client.x86_64 0:5.6.51-2.el7 will be obsoleting 24 --> Processing Dependency: mysql-community-libs(x86-64) >= 5.6.10 for package: mysql-community-client-5.6.51-2.el7.x86_64 25 ---> Package mysql-community-common.x86_64 0:5.6.51-2.el7 will be installed 26 ---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed 27 ---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed 28 --> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64 29 --> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64 30 ---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed 31 --> Running transaction check 32 ---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted 33 ---> Package mysql-community-libs.x86_64 0:5.6.51-2.el7 will be obsoleting 34 ---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed 35 --> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch 36 --> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch 37 --> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch 38 --> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch 39 --> Running transaction check 40 ---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed 41 --> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch 42 --> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch 43 ---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed 44 --> Running transaction check 45 ---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed 46 ---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed 47 --> Finished Dependency Resolution 48 49 Dependencies Resolved 50 51 ============================================================================================================================================================ 52 Package Arch Version Repository Size 53 ============================================================================================================================================================ 54 Installing: 55 mysql-community-client x86_64 5.6.51-2.el7 mysql56-community 21 M 56 replacing mariadb.x86_64 1:5.5.68-1.el7 57 mysql-community-libs x86_64 5.6.51-2.el7 mysql56-community 2.2 M 58 replacing mariadb-libs.x86_64 1:5.5.68-1.el7 59 mysql-community-server x86_64 5.6.51-2.el7 mysql56-community 67 M 60 Installing for dependencies: 61 mysql-community-common x86_64 5.6.51-2.el7 mysql56-community 287 k 62 net-tools x86_64 2.0-0.25.20131004git.el7 base 306 k 63 perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k 64 perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k 65 perl-DBI x86_64 1.627-4.el7 base 802 k 66 perl-Data-Dumper x86_64 2.145-3.el7 base 47 k 67 perl-IO-Compress noarch 2.061-2.el7 base 260 k 68 perl-Net-Daemon noarch 0.48-5.el7 base 51 k 69 perl-PlRPC noarch 0.2020-14.el7 base 36 k 70 71 Transaction Summary 72 ============================================================================================================================================================ 73 Install 3 Packages (+9 Dependent packages) 74 75 Total download size: 91 M 76 Is this ok [y/d/N]: y 77 Downloading packages: 78 warning: /var/cache/yum/x86_64/7/mysql56-community/packages/mysql-community-common-5.6.51-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY 79 Public key for mysql-community-common-5.6.51-2.el7.x86_64.rpm is not installed 80 (1/12): mysql-community-common-5.6.51-2.el7.x86_64.rpm | 287 kB 00:00:05 81 (2/12): mysql-community-libs-5.6.51-2.el7.x86_64.rpm | 2.2 MB 00:00:35 82 (3/12): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:00 83 (4/12): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:00 84 (5/12): net-tools-2.0-0.25.20131004git.el7.x86_64.rpm | 306 kB 00:00:00 85 (6/12): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:00 86 (7/12): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:00 87 (8/12): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:00 88 (9/12): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00 89 (10/12): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00 90 (11/12): mysql-community-client-5.6.51-2.el7.x86_64.rpm | 21 MB 00:36:12 91 (12/12): mysql-community-server-5.6.51-2.el7.x86_64.rpm | 67 MB 00:52:49 92 ------------------------------------------------------------------------------------------------------------------------------------------------------------ 93 Total 29 kB/s | 91 MB 00:53:31 94 Retrieving key from file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 95 Importing GPG key 0x5072E1F5: 96 Userid : "MySQL Release Engineering <mysql-build@oss.oracle.com>" 97 Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5 98 Package : mysql-community-release-el7-5.noarch (installed) 99 From : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 100 Is this ok [y/N]: y 101 Running transaction check 102 Running transaction test 103 Transaction test succeeded 104 Running transaction 105 Warning: RPMDB altered outside of yum. 106 Installing : mysql-community-common-5.6.51-2.el7.x86_64 1/14 107 Installing : perl-Data-Dumper-2.145-3.el7.x86_64 2/14 108 Installing : mysql-community-libs-5.6.51-2.el7.x86_64 3/14 109 Installing : mysql-community-client-5.6.51-2.el7.x86_64 4/14 110 Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 5/14 111 Installing : net-tools-2.0-0.25.20131004git.el7.x86_64 6/14 112 Installing : perl-Net-Daemon-0.48-5.el7.noarch 7/14 113 Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 8/14 114 Installing : perl-IO-Compress-2.061-2.el7.noarch 9/14 115 Installing : perl-PlRPC-0.2020-14.el7.noarch 10/14 116 Installing : perl-DBI-1.627-4.el7.x86_64 11/14 117 Installing : mysql-community-server-5.6.51-2.el7.x86_64 12/14 118 Erasing : 1:mariadb-5.5.68-1.el7.x86_64 13/14 119 Erasing : 1:mariadb-libs-5.5.68-1.el7.x86_64 14/14 120 Verifying : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 1/14 121 Verifying : perl-Net-Daemon-0.48-5.el7.noarch 2/14 122 Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 3/14 123 Verifying : mysql-community-libs-5.6.51-2.el7.x86_64 4/14 124 Verifying : net-tools-2.0-0.25.20131004git.el7.x86_64 5/14 125 Verifying : mysql-community-server-5.6.51-2.el7.x86_64 6/14 126 Verifying : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 7/14 127 Verifying : mysql-community-common-5.6.51-2.el7.x86_64 8/14 128 Verifying : perl-DBI-1.627-4.el7.x86_64 9/14 129 Verifying : perl-IO-Compress-2.061-2.el7.noarch 10/14 130 Verifying : perl-PlRPC-0.2020-14.el7.noarch 11/14 131 Verifying : mysql-community-client-5.6.51-2.el7.x86_64 12/14 132 Verifying : 1:mariadb-libs-5.5.68-1.el7.x86_64 13/14 133 Verifying : 1:mariadb-5.5.68-1.el7.x86_64 14/14 134 135 Installed: 136 mysql-community-client.x86_64 0:5.6.51-2.el7 mysql-community-libs.x86_64 0:5.6.51-2.el7 mysql-community-server.x86_64 0:5.6.51-2.el7 137 138 Dependency Installed: 139 mysql-community-common.x86_64 0:5.6.51-2.el7 net-tools.x86_64 0:2.0-0.25.20131004git.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 140 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 141 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7 142 143 Replaced: 144 mariadb.x86_64 1:5.5.68-1.el7 mariadb-libs.x86_64 1:5.5.68-1.el7 145 146 Complete!
2.6.2安装完成后再次查看是否安装了SQL
[root@localhost yum.repos.d]# rpm -qa | grep mysql
2.6.3发现多了四条新的mysql开头的包。
1 [root@localhost yum.repos.d]# rpm -qa | grep mysql 2 mysql-community-release-el7-5.noarch 3 mysql-community-common-5.6.51-2.el7.x86_64 4 mysql-community-libs-5.6.51-2.el7.x86_64 5 mysql-community-client-5.6.51-2.el7.x86_64 6 mysql-community-server-5.6.51-2.el7.x86_64
3.重置密码(5.6默认是没有密码的)
3.1重置密码前，首先要登录
# mysql -u root进入后配置密码
1 [root@localhost yum.repos.d]# mysql -u root 2 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 3 [root@localhost yum.repos.d]#
登录时有可能报这样的错：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)，
原因是/var/lib/mysql的访问权限问题。
3.2下面的命令把/var/lib/mysql的拥有者改为当前用户：
# sudo chown -R openscanner:openscanner /var/lib/mysql
3.3如果报chown: invalid user: ‘openscanner:openscanner’错误，
更换命令，并用 ll 查看目录权限列表
1 [root@localhost yum.repos.d]# chown root /var/lib/mysql/ 2 [root@localhost yum.repos.d]# ll
1 [root@localhost yum.repos.d]# chown root /var/lib/mysql/ 2 [root@localhost yum.repos.d]# ll 3 total 48 4 -rw-r--r--. 1 root root 1664 Oct 23 22:53 CentOS-Base.repo 5 -rw-r--r--. 1 root root 1309 Oct 23 22:53 CentOS-CR.repo 6 -rw-r--r--. 1 root root 649 Oct 23 22:53 CentOS-Debuginfo.repo 7 -rw-r--r--. 1 root root 314 Oct 23 22:53 CentOS-fasttrack.repo 8 -rw-r--r--. 1 root root 630 Oct 23 22:53 CentOS-Media.repo 9 -rw-r--r--. 1 root root 1331 Oct 23 22:53 CentOS-Sources.repo 10 -rw-r--r--. 1 root root 8515 Oct 23 22:53 CentOS-Vault.repo 11 -rw-r--r--. 1 root root 616 Oct 23 22:53 CentOS-x86_64-kernel.repo 12 -rw-r--r--. 1 root root 1209 Jan 29 2014 mysql-community.repo 13 -rw-r--r--. 1 root root 1060 Jan 29 2014 mysql-community-source.repo
附：
① 更改文件拥有者 (chown )
[root@linux ~]# chown + 账号名称+ 文件或目录
chown root /var/lib/mysql/
② 改变文件的用户组用命令 chgrp
[root@linux ~]# chgrp+ 组名+文件或目录
③ 对于目录权限修改之后，默认只是修改当前级别的权限。
如果子目录也要递归需要加R参数
Chown -R : 进行递归,连同子目录下的所有文件、目录
3.4 重启服务
# service mysqld restart
1 [root@localhost yum.repos.d]# service mysqld restart 2 Redirecting to /bin/systemctl restart mysqld.service 3 [root@localhost yum.repos.d]#
4.1改完权限之后，再来登陆
#mysql -u root -p
mysql > use mysql;（#用mysql登陆）
mysql > update user set password=password('123456') where user='root';（#设置root用户的密码为123456）
mysql > exit;（#退出）
1 [root@localhost ~]$ mysql -u root 2 Welcome to the MySQL monitor. Commands end with ; or \g. 3 Your MySQL connection id is 5 4 Server version: 5.6.51 MySQL Community Server (GPL) 5 6 Copyright (c) 2000, 2021, Oracle and/or its affiliates. All rights reserved. 7 8 Oracle is a registered trademark of Oracle Corporation and/or its 9 affiliates. Other names may be trademarks of their respective 10 owners. 11 12 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 13 14 mysql> use mysql 15 Reading table information for completion of table and column names 16 You can turn off this feature to get a quicker startup with -A 17 18 Database changed 19 mysql> update user set password=password('123456') where user='root';（#设置root用户的密码为123456） 20 Query OK, 4 rows affected (0.00 sec) 21 Rows matched: 4 Changed: 4 Warnings: 0
4.2重启后才生效
重启mysql服务后才生效 # service mysqld restart
4.3.1、登陆后查询数据库编码格式，确保是 UTF-8
#mysql -u root -p，然后会跳转至需要输入密码进行下一步
#mysql>show variables like "%char%";（最后面这个分号不能少）
4.3.2需要修改编码格式为UTF-8，导入数据库sql的时候，请确保sql文件为utf8编码
进入mysql命令行后 输入：set names utf8;
4.4开放3306端口号
1 [15:54:30 root@localhost ~]$ firewall-cmd --zone=public --add-port=3306/tcp --permanent 2 success 3 [15:54:34 root@localhost ~]$ firewall-cmd --reload 4 success
firewalld 防火墙（centos-7）运行命令,并重启成功！
5.0登陆SQL，试试看命令
1 mysql> show databases;（#命令末尾的分号不能忘！） 2 +--------------------+ 3 | Database | 4 +--------------------+ 5 | information_schema | 6 | mysql | 7 | performance_schema | 8 +--------------------+ 9 3 rows in set (0.00 sec) 10 11 mysql> select user();（#末尾的分号不能忘！） 12 +----------------+ 13 | user() | 14 +----------------+ 15 | root@localhost | 16 +----------------+ 17 1 row in set (0.00 sec)
至此安装成功！
