环境:Centos7
yum仓库下载MySQL
yum localinstall -y https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
yum安装MySQL
yum install -y mysql-community-server
启动MySQL服务,并设置开机启动
systemctl start mysqld
systemctl status mysqld
systemctl enable mysqld
查看默认密码
grep 'temporary password' /var/log/mysqld.log
使用默认密码登录
mysql -u root -p
修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
设置root账号允许远程登录,并重新加载权限
use mysql; update user set host='%' where user='root'; flush privileges;
防火墙开启3306端口,并重新加载防火墙
firewall-cmd --state firewall-cmd --add-port=3306/tcp --permanent firewall-cmd --reload
查看MySQL版本
mysql -V
重置密码级别
SHOW VARIABLES LIKE 'validate_password%';
set global validate_password.policy=0; set global validate_password.length=4;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
use mysql; update user set host='%' where user='root'; flush privileges;exit;
卸载
查看安装情况
yum list installed mysql*
卸载
yum remove -y mysql*
rm -rf /var/lib/mysql