yum安装mysql目录结构
mysql目录 | 说明 |
---|
/var/lib/mysql | 数据目录 |
/etc/my.cnf | 配置文件目录 |
/var/log/mysqld.log | 日志文件路径 |
/usr/bin/mysql* | 二进制可执行文件 |
停止mysql
systemctl stop mysqld
创建数据目录
mkdir /home/data
chmod -R 777 /home/data
复制数据目录
mv /var/lib/mysql/ /home/data/
chown -R mysql:mysql /home/data
修改配置文件
vim /etc/my.cnf
添加配置:
datadir=/home/data/mysql
socket=/home/data/mysql.sock
log-error=/home/data/mysql/mysqld.log
启动
systemctl restart mysqld
systemctl enable mysqld
ps -ef | grep mysql
问题处理
- Mysql启动报错:InnoDB: Operating system error number 13 in a file operation
处理方法:
[root@localhost ~]
Enforcing
[root@localhost ~]
[root@localhost ~]
Permissive
[root@localhost ~]
[root@localhost ~]
tcp LISTEN 0 80 [::]:3306 [::]:* users:(("mysqld",pid=74057,fd=17))