MySql旧版本(卸载)

rpm -e --nodeps `rpm -qa | grep -i mysql` && rm -rf /var/lib/mysql /etc/my.cnf.rpmsave /var/log/mysqld.log

MySql新版本(安装)

yum install openssl-devel && rpm -ivh --force --nodeps /opt/mysql/*.rpm

MySql登录

启动服务：systemctl start mysqld
重启服务：systemctl restart mysqld
关闭服务：systemctl stop mysqld
临时密码：cat /var/log/mysqld.log
登录root：mysql -u root -p

MySql改密码

1.变更密码策略
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Abc@123456';
set global validate_password.policy = 0;
set global validate_password.length = 6;2.修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';3.创建新用户
create user '用户名'@'%' IDENTIFIED WITH mysql_native_password BY '密码';4.授权新用户
grant all on *.* to '用户名'@'%';5.删除新用户
drop user '用户名'@'%';

MySql连接

防火墙打开端口权限：firewall-cmd --zone=public --add-port=3306/tcp --permanent && firewall-cmd --reload