Centos 7 mysql 8.0 安装并做数据文件迁移 实测可用

安装mysql并自定义数据文件存放目录

下载tar包 https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar

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

逐个安装，命令如下：

【必须安装】

rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm

【非必须安装】

rpm -ivh mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-embedded-compat-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-devel-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-test-8.0.16-2.el7.x86_64.rpm

安装完成后

创建存放数据文件的目录

mkdir -p /mysqldata/mysql

chown -R mysql:mysql /mysqldata

修改my.cnf配置文件

vi /etc/my.cnf

datadir=/mysqldata/mysql
socket=/mysqldata/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[client]
socket = /mysqldata/mysql/mysql.sock
[mysql]
socket = /mysqldata/mysql/mysql.sock

初始化mysql配置

mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql

启动mysql

systemctl start mysqld

启动mysql时权限不够可以使用：setenforce 0

查看临时密码

cat /var/log/mysqld.log | grep password

登陆数据库

mysql -u root -p

登陆后修改root密码

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

授权远程连接

CREATE USER 'root'@'%' IDENTIFIED with mysql_native_password  BY '123456';

flush privileges;

--启动mysql 权限不够的问题

这一步很重要

vi /etc/selinux/config 

在找解决办法的时候看到也可以不重启系统的办法：

可以用setenforce 0临时关闭selinux

开机自启：systemctl enable mysqld.service