CentOS7安装MySQL8

1.下载并安装mysql官方的 yum repository

[root@sweetbaby ~]# wget -i -c  https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

[root@sweetbaby ~]# yum -y install mysql80-community-release-el7-1.noarch.rpm

[root@sweetbaby ~]# yum -y install mysql-community-server

2.mysql数据库设置

启动mysql

[root@sweetbaby ~]# systemctl start mysqld.service

查找mysql的默认密码

[root@sweetbaby ~]# grep "password" /var/log/mysqld.log

 

 进入数据库

[root@sweetbaby ~]# mysql -u root -p

输入初始密码，如下命令修改密码

mysql> alter user 'root'@'localhost' identified by 'new password';

此时还有一个问题，之前安装了yum repository，以后每次yum操作都会自动更新，需要把这个卸载掉

[root@sweetbaby ~]# yum -y remove mysql57-community-release-el7-10.noarch

进入数据库允许远程连接

mysql> use mysql;

mysql> update user set host = '%' where user = 'root';

mysql> flush privileges;

退出数据库

mysql> quit;

ok，就这样！

欲买桂花同载酒，终不似，少年游