mysql 8.0 云服务器安装（centos7）y与远程连接

1. 在线安装MySQL数据库

• 替换yum源

  curl -o /etc/yum.repos.d/CentOS-Base.repo mirrors.163.com/.help/CentOS7-Base-163.repo
  

  yum clean all 
  yum makecache 
  

• 下载rpm文件

  yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
  

• 安装MySQL数据库

  yum install mysql-community-server -y
  

2.数据库操作

• 修改MySQL目录权限

  chmod -R 777 /var/lib/mysql/
  

• 初始化MySQL

  mysqld --initialize
  chmod -R 777 /var/lib/mysql/*
  

• 启动MySQL

  systemctl start mysqld.service  
  

• 查看初始密码

  grep 'temporary password' /var/log/mysqld.log
  

• 登陆数据库之后，修改默认密码

  mysql -u root -p
  alter user user() identified by "abc123456"; 
  

• 允许远程使用root帐户

  select host,user from user;
  UPDATE user SET host = '%' WHERE user ='root';
  FLUSH PRIVILEGES;
  

• 允许远程访问MySQL数据库（/etc/my.cnf）

  character_set_server = utf8
  bind-address = 0.0.0.0
  

• 开启防火墙3360端口

  firewall-cmd --zone=public --add-port=3306/tcp --permanent
  firewall-cmd --reload
  

注意：云服务器注意开放3306端口