CentOS offline 安装 MySQL8.0.12

CentOS offline 安装 MySQL8.0.12
1. 官网下载二进制安装包
2. 解压文件：
#tar -xJvf mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz -C /usr/local/
# mv /usr/local/mysql-8.0.12-linux-glibc2.12-x86_64/ /usr/local/mysql
3. 配置参数文件：
# vim /etc/my.cnf
[mysqld]
mysqlx_socket                  = /tmp/mysqlx.sock
datadir                        = /data/mysql
socket                         = /tmp/mysql.sock
pid-file                       = /tmp/mysqld.pid
log-error                      = error.log
default-authentication-plugin  =mysql_native_password
4. 创建目录授权并授权：
# groupadd mysql
# useradd mysql
# mkdir -p /data/mysql
# chown -R mysql:mysql /data/mysql/
# chmod -R 775 /data/mysql/
5. 初始化数据库：
#/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql --initialize
6. 设置启动文件和环境变量：
#cp /usr/local/mysql/support-files/mysql.server  /etc/init.d/mysql
7. 启动数据库：
# /etc/init.d/mysql start
# vim /etc/profile.d/mysql.sh
  export PATH=$PATH:/usr/local/mysql/bin
# source /etc/profile.d/mysql.sh 
# mysqld --version
# /usr/local/mysql/bin/mysql -p -S /tmp/mysql.sock
8. 设置可以远程登录的账号：
mysql> alter user root@'localhost' identified by 'oracle';
mysql> create user root@'%' identified by 'oracle';
mysql> grant all privileges on *.* to root@'%' with grant option;
mysql> flush privileges;