删除mariaDB
rpm -qa|grep mariadb
rpm -e --nodeps __________
1、安装解压
tar vxf mysql-5.7.25-1.el7.x86_64.rpm-bundle.tar -C /opt/programs/
2、安装包 ([root@hadoop102 software]# rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm --force --nodeps)
rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm
3、重启
systemctl start mysqld <i9EIch.0hrF
4、查看随机密码
cat /var/log/mysqld.log | grep password grep "password" /var/log/mysqld.log 都是查看随机密码
修改密码强度
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=4;
mysql> set password=password("123456");
mysql -uroot -p 第一次登录使用随机密码
修改密码
mysql> alter user 'root'@'localhost' identified by 'root'; 密码:root
Query OK, 0 rows affected (0.00 sec)
5、装了它第一次登录是不需要密码的,就导致再装mysql也不需要密码。
rm -rf /var/lib/mysql
systemctl restart mysqld
6、这时候就要查找系统给我们的临时密码
grep password /var/log/mysqld.log (Cf4IV>65g+.m)
7、进入mysql中修改密码,强度变低
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=4;
mysql> set password=password("123456");
8、进入mysql中,设置MySQL可远程登录
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456';
mysql> FLUSH PRIVILEGES;