centos7安装mysql8.0版本

1.下载rpm包

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

2.安装rpm包

yum localinstall mysql80-community-release-el7-1.noarch.rpm

3.安装mysql

yum install mysql-community-server

4.设置无大小写敏感

vim /etc/my.cnf   //编辑my.cnf文件
在[mysqld]下面添加 
lower_case_table_names=1

5.设置开机启动

systemctl enable mysqld
systemctl daemon-reload
#启动
systemctl start mysqld
#重启
service mysqld restart

 

6.获取密码并且修改密码

#获取密码
grep 'temporary password' /var/log/mysqld.log
#进入mysql
mysql -u root -p
#修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Mozigame@123';

7.开启远程访问

use mysql;
update user set host='%' where user ='root';
flush privileges;

8.native无法访问远程mysql解决

ALTER USER 'root'@'%' IDENTIFIED BY 'Mozigame@123' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Mozigame@123';
FLUSH PRIVILEGES; #刷新权限

9.开启binlog日志，以防不测

server_id=2
log_bin = mysql-bin
binlog_format = ROW
expire_logs_days = 30