Linux安装mysql

rpm -qa | grep mysql
如果有服务就卸载 yum remove '软件名'
wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql80-community-release-el7-3.noarch.rpm
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum -y install mysql-community-server
systemctl start mysqld
systemctl status mysqld
cat /var/log/mysqld.log | grep password
mysql -V 查看版本

安装完后需要修改密码 qdkj123456QDKJ!@#$%
alter user user() identified by "qdkj123456QDKJ!@#$%";
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'qdkj123456QDKJ!@#$%' WITH GRANT OPTION;

修改加密规则
ALTER USER 'root'@'%' IDENTIFIED BY 'qdkj123456QDKJ!@#$%' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'qdkj123456QDKJ!@#$%';
//刷新权限（可以直接复制）
FLUSH PRIVILEGES;

远程连接
mysql -uroot -pqdkj123456QDKJ!@#$%
use mysql
select user,host from user;
update user set host='%' where host='localhost' and user='root';
select user,host from user;
lush privileges;

service firewalld stop 关闭防火墙