[root@localhost ~]# wget -i -c https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
[root@localhost ~]# yum -y install mysql80-community-release-el7-1.noarch.rpm
[root@localhost ~]# yum -y install mysql-community-server
MySQL数据库设置
[root@localhost ~]# systemctl start mysqld.service
查看MySQL运行状态
[root@localhost ~]# systemctl status mysqld.service
要想进入MySQL还得先找出此时root用户的密码,通过如下命令可以在日志文件中找出密码:
[root@localhost ~]# grep "password" /var/log/mysqld.log
如下命令进入数据库:
root@localhost ~]# mysql -uroot -p
set global validate_password_policy=0;
set global validate_password_length=1;
ALTER USER 'root'@'localhost' IDENTIFIED BY ‘123456’;
Mysql允许外网访问设置的方法:
use mysql;
select user,host from user;
update user set host='%' where user='root';
flush privileges;