centos7安装mysql8

准备

• 关闭SELinux

  • 编辑文件

    vi /etc/selinux/config
    

  • 设置 SELINUX=disabled，重启系统

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数据库

• 把git工程里共享的MySQL本地安装文件上传到Linux主机的/root/mysql目录

• 执行解压缩

  tar xvf mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar
  

• 安装依赖的程序包

  yum install perl -y
  yum install net-tools -y
  

• 卸载mariadb程序包

  rpm -qa|grep mariadb
  rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps
  

• 安装MySQL程序包

  rpm -ivh mysql-community-common-8.0.11-1.el7.x86_64.rpm 
  rpm -ivh mysql-community-libs-8.0.11-1.el7.x86_64.rpm 
  rpm -ivh mysql-community-client-8.0.11-1.el7.x86_64.rpm 
  rpm -ivh mysql-community-server-8.0.11-1.el7.x86_64.rpm 
  

• 修改MySQL目录权限

  chmod -R 777 /var/lib/mysql/
  

• 初始化MySQL

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

• 启动MySQL

  service mysqld start
  

• 查看初始密码

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

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

  alter user user() identified by "abc123456"; 
  

• 选择mysql数据库后，允许远程使用root帐户

  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
  

• 重启mysql: mysqld service restart

mysqld service restart

node连接失败需要更改密码验证方式

• 登陆数据库
• 更改密码验证方式

use mysql;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';