由于现场环境无外网,很多yum安装的依赖无法安装,所以使用mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar版本
先卸载自带的mariadb:
rpm -qa |grep mysql
rpm -e --nodeps 'mysql57-community-release-el7-10.noarch'
rpm -qa |grep mysql
whereis mysql
find / -name mysql
rm -rf /usr/lib64/mysql
rm -rf /usr/share/mysql
rm -rf /etc/selinux/targeted/active/modules/100/mysql
rpm -qa|grep mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
rpm -qa|grep mariadb
或者直接这样卸载mariadb:
或者这样卸载mariadb:
tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
mysqld --initialize初始化
无法启动:
systemctl status mysqld.service
原因:无权限
查看data路径:vim /etc/my.cnf
chmod -R 777 /var/lib/mysql
systemctl restart mysqld.service
查看状态:systemctl status mysqld.service
查看初始密码
grep 'temporary password' /var/log/mysqld.log
如果查出来多个,选最后一个
登录
mysql -uroot -p
输入上一步记住的密码
设置密码验证安全级别:设置密码验证安全级别0,长度4:
set global validate_password_policy=0;
set global validate_password_length=4;
报错:ERROR 1193 (HY000): Unknown system variable ‘validate_password_policy’
解决方案:打开/etc/my.cnf,然后在[mysqld]的下方加入如下代码:
plugin-load-add=validate_password.so
validate-password=FORCE_PLUS_PERMANENT
修改root密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
取消严格模式:
set GLOBAL sql_mode='';
设置可远程访问IP:
grant all privileges on *.* to 'root'@'%' IDENTIFIED BY '密码';
flush privileges;
如果提示Your password does not satisfy the current policy requirements,是因为密码安全级别不够
需要做如下设置:
set global validate_password_policy=0;
set global validate_password_mixed_case_count=2;
然后再次设置可远程访问IP:
grant all privileges on *.* to 'root'@'%' IDENTIFIED BY '密码';
flush privileges;
开机自启动:systemctl enable mysqld