MySql8安装后的配置

grep 'temporary password' /var/log/mysqld.log

设置远程

1
2
3
4
5
6
7
8
9
10
systemctl start mysqld
mysql -u root -p
use mysql;

ALTER USER 'root'@'localhost' IDENTIFIED BY '>2_o&ypFfhen';
update user set host = '%' where user = 'root' and host='localhost';

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '>2_o&ypFfhen';
GRANT ALL ON *.* TO 'root'@'%';
flush privileges;

卸装MySql

1
2
3
rpm -qa|grep mysql  // 查询已安装的包
rpm -e package --nodeps // 卸装包
find / -name mysql // 查找临时文件