CentOS7 装mysql

看别人教程，又被坑了，自己记一下。

下载yum包

wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

安装

sudo rpm -Uvh mysql80-community-release-el7-1.noarch.rpm

安装server

yum install  -y  mysql-community-server

启动

service mysqld start

找临时密码

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

登陆

mysql -uroot -p

改密码

set global validate_password.POLICY=0;
ALTER USER USER() IDENTIFIED BY '12345678'；

之后改密码

use mysql;
alter user 'root'@'localhost' IDENTIFIED BY '12345678';

授权远程登陆

update user set host='%' where user='root';
GRANT ALL privileges ON *.* TO 'root'@'%';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'new passwd';