安装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