CentOS7离线安装MySQL57

CentOS7离线安装MySQL57

MySQL离线安装包
http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-common-5.7.28-1.el7.x86_64.rpm
http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-devel-5.7.28-1.el7.x86_64.rpm
http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-libs-5.7.28-1.el7.x86_64.rpm
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64//mysql-connector-odbc-8.0.18-1.el7.x86_64.rpm
http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-client-5.7.28-1.el7.x86_64.rpm
http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-server-5.7.28-1.el7.x86_64.rpm
安装所需要的依赖

yum -y install numactl

卸载mariadb

[root@VM-0-12-centos ~]# rpm -qa|grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
[root@VM-0-12-centos ~]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
[root@VM-0-12-centos ~]# rpm -qa|grep mariadb

安装原生yum源（非必选）

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall mysql57-community-release-el7-8.noarch.rpm

安装mysql rpm

rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-connector-odbc-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm

如果出现以下错误

则在每个命令后加上–nodeps --force

rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-devel-5.7.28-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-connector-odbc-8.0.18-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm --nodeps --force

启动mysql服务器

service mysqld start

修改密码
mysql会默认给一个初始密码，需要修改
查看初始密码方式

cat /var/log/mysqld.log | grep password
2020-09-10T07:01:48.412701Z 1 [Note] A temporary password is generated for root@localhost: ghyO?N+e)6*G

登陆mysql

mysql -u root -p

输入初始密码
因为mysql的密码规则异常烦人，可以先修改mysql密码规则

set global validate_password_policy=0;
set global validate_password_mixed_case_count=0;
set global validate_password_special_char_count=0;
set global validate_password_length=6;

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

如果需要远程链接

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;