centos 安装Mysql8.0.12

链接：https://blog.csdn.net/qq_38591756/article/details/82958333

安装在home下,进入home文件下

cd /

cd home/
#安装源文件
wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

yum localinstall mysql80-community-release-el7-1.noarch.rpm
#检查安装是否成功
yum repolist enabled | grep "mysql.*-community.*"

#安装
yum install mysql-community-server

#启动服务
systemctl start mysqld

#查看服务是否启动
systemctl status mysqld

#设置开机启用
systemctl enable mysqld
systemctl daemon-reload

#查看密码
grep 'temporary password' /var/log/mysqld.log

#修改密码 建议复杂一点  大小写字母 字符
ALTER USER 'root'@'localhost' IDENTIFIED BY '**************';


#添加远程用户
use mysql;

select host, user from user;

#可能报错
GRANT ALL ON *.* TO 'root'@'%';

#报错则使用
update user set host='%' where user ='root';

#刷新
flush privileges;

若是服务器则需要放行端口：3306

下面是腾讯云：

https://console.cloud.tencent.com/vpc/securitygroup?rid=4&rid=4

安全组->修改规则->点击一键放通->按下图添加3306的端口