---------大神绕路--------
首先一台轻量级服务器
以此执行
sudo su root
cd /usr/local/src/
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
要是成功了就会出现这样的代码 (前面的时间等等不用关注,主要是 saved)
2018-07-09 10:40:10 (171 MB/s) - ‘mysql57-community-release-el7-8.noarch.rpm’ saved [9116/9116]
第三条指令结束了就出现以下如图:
执行 rpm
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #更改加密方式
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码'; #更新用户密码
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
会出现以下:
warning: mysql57-community-release-el7-8.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5172efs5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql57-community-release-el7-8 ################################# [100%]
到这部就需要 install mysql-server
yum -y install mysql-server
然后就出现以下:(解释?不解释)
Loaded plugins: fastestmirror
base | 3.6 kB 00:00:00
epel | 3.2 kB 00:00:00
extras | 3.4 kB 00:00:00
mysql-connectors-community | 2.5 kB 00:00:00
mysql-tools-community | 2.5 kB 00:00:00
mysql57-community | 2.5 kB 00:00:00
updates | 3.4 kB 00:00:00
(1/10): epel/x86_64/group_gz | 88 kB 00:00:00
(2/10): base/7/x86_64/group_gz | 166 kB 00:00:00
(3/10): epel/x86_64/updateinfo | 925 kB 00:00:00
(4/10): extras/7/x86_64/primary_db | 150 kB 00:00:00
(5/10): base/7/x86_64/primary_db | 5.9 MB 00:00:00
(6/10): mysql-connectors-community/x86_64/primary_db | 20 kB 00:00:00
(7/10): epel/x86_64/primary | 3.5 MB 00:00:00
(8/10): updates/7/x86_64/primary_db | 3.6 MB 00:00:00
(9/10): mysql-tools-community/x86_64/primary_db | 41 kB 00:00:00
(10/10): mysql57-community/x86_64/primary_db | 144 kB 00:00:00
Determining fastest mirrors
epel 12604/12604
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.22-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.22-1.el7 for package: mysql-community-server-5.7.22-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.22-1.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-5.7.22-1.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-5.7.22-1.el7.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-5.7.22-1.el7.x86_64
--> Running transaction check
---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
---> Package mysql-community-client.x86_64 0:5.7.22-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.22-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.22-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.52-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
---> Package mysql-community-libs.x86_64 0:5.7.22-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:5.7.22-1.el7 will be obsoleting
--> Finished Dependency Resolution
Dependencies Resolved
===========================================================================================================================================================================================
Package Arch Version Repository Size
===========================================================================================================================================================================================
Installing:
mysql-community-libs x86_64 5.7.22-1.el7 mysql57-community 2.1 M
replacing mariadb-libs.x86_64 1:5.5.52-1.el7
mysql-community-libs-compat x86_64 5.7.22-1.el7 mysql57-community 2.0 M
replacing mariadb-libs.x86_64 1:5.5.52-1.el7
mysql-community-server x86_64 5.7.22-1.el7 mysql57-community 165 M
Installing for dependencies:
libaio x86_64 0.3.109-13.el7 base 24 k
mysql-community-client x86_64 5.7.22-1.el7 mysql57-community 24 M
mysql-community-common x86_64 5.7.22-1.el7 mysql57-community 274 k
Transaction Summary
===========================================================================================================================================================================================
Install 3 Packages (+3 Dependent packages)
Total download size: 193 M
Downloading packages:
(1/6): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:00
warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYB/s | 24 kB --:--:-- ETA
Public key for mysql-community-common-5.7.22-1.el7.x86_64.rpm is not installed
(2/6): mysql-community-common-5.7.22-1.el7.x86_64.rpm | 274 kB 00:00:00
(3/6): mysql-community-libs-5.7.22-1.el7.x86_64.rpm | 2.1 MB 00:00:00
(4/6): mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm | 2.0 MB 00:00:00
(5/6): mysql-community-client-5.7.22-1.el7.x86_64.rpm | 24 MB 00:00:03
(6/6): mysql-community-server-5.7.22-1.el7.x86_64.rpm | 165 MB 00:00:14
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 12 MB/s | 193 MB 00:00:16
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
Userid : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
Package : mysql57-community-release-el7-8.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
Installing : mysql-community-common-5.7.22-1.el7.x86_64 1/7
Installing : mysql-community-libs-5.7.22-1.el7.x86_64 2/7
Installing : mysql-community-client-5.7.22-1.el7.x86_64 3/7
Installing : libaio-0.3.109-13.el7.x86_64 4/7
Installing : mysql-community-server-5.7.22-1.el7.x86_64 5/7
Installing : mysql-community-libs-compat-5.7.22-1.el7.x86_64 6/7
Erasing : 1:mariadb-libs-5.5.52-1.el7.x86_64 7/7
Verifying : mysql-community-libs-compat-5.7.22-1.el7.x86_64 1/7
Verifying : mysql-community-common-5.7.22-1.el7.x86_64 2/7
Verifying : mysql-community-server-5.7.22-1.el7.x86_64 3/7
Verifying : mysql-community-client-5.7.22-1.el7.x86_64 4/7
Verifying : mysql-community-libs-5.7.22-1.el7.x86_64 5/7
Verifying : libaio-0.3.109-13.el7.x86_64 6/7
Verifying : 1:mariadb-libs-5.5.52-1.el7.x86_64 7/7
Installed:
mysql-community-libs.x86_64 0:5.7.22-1.el7 mysql-community-libs-compat.x86_64 0:5.7.22-1.el7 mysql-community-server.x86_64 0:5.7.22-1.el7
Dependency Installed:
libaio.x86_64 0:0.3.109-13.el7 mysql-community-client.x86_64 0:5.7.22-1.el7 mysql-community-common.x86_64 0:5.7.22-1.el7
Replaced:
mariadb-libs.x86_64 1:5.5.52-1.el7
Complete!
下一步:开启服务
systemctl start mysqld.service
systemctl status mysqld.service
一定要有原谅色这两个单词:
到这里就安装成功了:
接下来是需要登陆:查看你的密码
grep "password" /var/log/mysqld.log
红色箭头就是密码
接下来就是登陆进去:
mysql -uroot -p
结束了。。。。。哈哈哈
日了狗了,还需要开放端口给外界链接使用!~~~~~
执行firewall-cmd --permanent --zone=public --add-port=3306/tcp,提示FirewallD is not running,也就是说防火墙未开启
防火墙开启:systemctl start firewalld
查看防火墙状态:systemctl status firewalld
然后:
设置3306端口:firewall-cmd --zone=public --add-port=3306/tcp --permanent 出现success
firewall-cmd --reload 防火墙规则更行
firewall-cmd --list-ports 查看port list
到此结束
CREATE USER 'sa'@'%' IDENTIFIED BY 'some_pass'; #创建一个用户名为sa,密码为some_pass的用户,可以自己更改
GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'sa'@'%'; #授予sa这个用户可以远程访问的权限
CREATE USER 'admin'@'%' IDENTIFIED BY 'some_pass'; #创建一个管理员用户
GRANT ALL ON *.* TO 'admin'@'%'; #授予数据库操作权限,可以增删改查
flush privileges; #授权立即生效