mysql 配置linux

mysql官网下载地址：

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

 

?

1 2 3 4

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 //解压文件

 

?

1 2 3 4 5 6 7 8

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 //输入获取系统默认密码

 

?

1 2 3 4 5 6 7 8 9 10 11

//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;

?

1 2 3 4 5 6

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配置Access denied for user root@localhost解决方法skip-grant-tables