Centos7.5 linux服务器环境搭建（四）Mysql8.0.19的安装和使用

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

yum -y install mysql80-community-release-el7-3.noarch.rpm

yum install mysql-community-server

mysqld --initialize

chown mysql:mysql /var/lib/mysql -R

service mysqld start

service mysqld status

systemctl enable mysqld

cat /var/log/mysqld.log | grep password

mysql -uroot -p

alter user 'root' @'localhost' identified with mysql_native_password by 'root';

exit

create user 'root'@'%' identified by 'root';

grant all privileges on *.* to 'root'@'%';

flush privileges;

alter user 'root' @'%' identified with mysql_native_password by 'root';

exit

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT