mysql离线部署

mysql离线部署

准备安装包

https://dev.mysql.com/downloads/mysql/
mysql-community-client-5.7.27-1.el7.x86_64.rpm
mysql-community-common-5.7.27-1.el7.x86_64.rpm
mysql-community-devel-5.7.27-1.el7.x86_64.rpm
mysql-community-libs-5.7.27-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-server-5.7.27-1.el7.x86_64.rpm

删除mariadb-libs

[[email protected] mysql]# rpm -qa | grep mariadb
mariadb-libs-5.5.44-2.el7.centos.x86_64
[[email protected] mysql]# rpm -e mariadb-libs-5.5.44-2.el7.centos.x86_64 --nodeps

按顺序安装

[[email protected] mysql]# rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm 
warning: mysql-community-common-5.7.27-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-common-5.7.27-1.e################################# [100%]
[[email protected] mysql]# rpm -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm 
warning: mysql-community-libs-5.7.27-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-libs-5.7.27-1.el7################################# [100%]
[[email protected] mysql]# rpm -ivh mysql-community-devel-5.7.27-1.el7.x86_64.rpm 
warning: mysql-community-devel-5.7.27-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-devel-5.7.27-1.el################################# [100%]
[[email protected] mysql]# rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm 
warning: mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-libs-compat-5.7.2################################# [100%]
[[email protected] mysql]# rpm -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm 
warning: mysql-community-client-5.7.27-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing..
   1:mysql-community-client-5.7.27-1.e################################# [100%]
[[email protected] mysql]#  rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.27-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-server-5.7.27-1.e################################# [100%]

启动mysql

[[email protected] mysql]# service mysqld start
Redirecting to /bin/systemctl start  mysqld.service

获取root账号密码

[[email protected] mysql]# cat /var/log/mysqld.log
[Note] A temporary password is generated for [email protected]: 18?>cb?hEo0U

进入mysql shell客户端

[[email protected] mysql]# mysql -uroot -p
Enter password: 

修改root密码报错

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>  SET PASSWORD = PASSWORD('ocmcc1234');
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

修改密码安全强度

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)

修改root密码

mysql>  SET PASSWORD = PASSWORD('cmcc1234');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

开启远程登录

mysql> grant all privileges on *.* to [email protected]'%' identified by 'cmcc1234';
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)