mysql 配置linux

mysql官网下载地址：

https://downloads.mysql.com/archives/community/

yum install perl net-tools -y  //安装mysql依赖
rpm -qa | grep mariadb  //查找CentOS自带的数据库
rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64  //删除CentOS自带的数据库
tar -xvf mysql-5.7.19-1.el7.x86_64.rpm-bundle.tar //解压文件

rpm -ivh mysql-community-common-5.7.19-1.el7.x86_64.rpm (1)
rpm -ivh mysql-community-libs-5.7.19-1.el7.x86_64.rpm (2)
rpm -ivh mysql-community-client-5.7.19-1.el7.x86_64.rpm (3)
rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm (4)
systemctl start mysqld //启动服务
systemctl status mysqld
cat /var/log/mysqld.log | grep password //获取系统默认密码
mysql -u root -p //输入获取系统默认密码

//5.7版本：
set global validate_password_policy=LOW; //修改密码权限 
set global validate_password_length=6; //设置密码长度
//8.0版本：
set global validate_password.policy=LOW; //修改密码权限 
set global validate_password.length=6; //设置密码长度
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; //更改加密方式
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; //更改密码
flush privileges; //刷新权限
use mysql;
select host,user from user;

update user set host='%' where user = 'root'; //host='%' 所有人都可以访问指定（'IP'）
commit; //提交修复
exit; //退出mysql
systemctl restart mysqld; //从起服务
windows访问 mysql -h 192.168.30.129 -u root -P 3306 -p
vi /etc/my.cnf //mysql配置