检查是否安装了Mariadb(把我害苦了)

rpm -qa|grep mariadb

删除Mariadb

rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

下载mysql 5.7.34

1、wget https://cdn.mysql.com/archives/mysql-5.7/mysql-community-common-5.7.35-1.el7.x86_64.rpm
2、wget https://cdn.mysql.com/archives/mysql-5.7/mysql-community-client-5.7.35-1.el7.x86_64.rpm
3、wget https://cdn.mysql.com/archives/mysql-5.7/mysql-community-libs-5.7.35-1.el7.x86_64.rpm
4、wget https://cdn.mysql.com/archives/mysql-5.7/mysql-community-server-5.7.34-1.el7.x86_64.rpm
或 wget https://cdn.mysql.com/archives/mysql-5.7/mysql-community-server-5.7.35-1.el7.x86_64.rpm

安装命令

1、sudo rpm -ivh mysql-community-common-5.7.35-1.el7.x86_64.rpm
2、sudo rpm -ivh mysql-community-libs-5.7.35-1.el7.x86_64.rpm
3、sudo rpm -ivh mysql-community-client-5.7.35-1.el7.x86_64.rpm
4、sudo rpm -ivh mysql-community-server-5.7.35-1.el7.x86_64.rpm
--nodeps：不检查依赖关系
--force：强制安装

注

为什么不用yum -y install mysql-community-server-5.7.34-1.el7.x86_64.rpm
因为报错：
错误：软件包：mysql-community-server-5.7.34-1.el7.x86_64 (/mysql-community-server-5.7.34-1.el7.x86_64)
需要：mysql-community-client(x86-64) >= 5.7.9
错误：软件包：mysql-community-server-5.7.34-1.el7.x86_64 (/mysql-community-server-5.7.34-1.el7.x86_64)
需要：mysql-community-common(x86-64) = 5.7.34-1.el7

配置

修改默认密码

vim /etc/my.cnf
在文件末尾添加 skip-grant-tables

启动mysql

systemctl start mysqld

登录

mysql -u root -p
use information_schema
update mysql.user set authentication_string=password('你的密码') where user='用户';
exit

修改密码

mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

设置开机启动

systemctl enable mysqld

设置密码复杂度

SHOW VARIABLES LIKE 'validate_password%';
set global validate_password_length=6;

开启mysql的远程访问

grant all privileges on . to 'root'@'192.168.0.1' identified by 'password' with grant option;

创建用户

flush privileges;
CREATE USER 'admin'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON . TO 'admin'@'%' WITH GRANT OPTION;

将字符限制修改为全小写

lower_case_table_names=1

卸载Mysql

rpm -qa|grep -i mysql #查看已经安装的mysql组件
rpm -ev --nodeps mysql-community-server-5.7.35-1.el7.x86_64 # 卸载组件