mysql 修改 pid 路径_修改MySQL的数据目录

环境：CentOS Linux release 7.1.1503 (Core)

1. 安装MYSQL

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpmyum install mysql-community-server

serivce mysqld start

此时查看数据目录，是/var/lib/mysql

2. 修改配置

2.1 修改安全限制

vim /etc/selinux/config

将内容修改如下：

# SELINUX=enforcing

SELINUX=permissive

2.2 修改数据库配置

首先停用MySQL。

1. 复制数据目录

cp -R /var/lib/mysql /data/

chown -R mysql:mysql /data/mysql

2. 修改配置

备份/etc/my.cnf

cp /etc/my.cnf /etc/my.cnf-bk

修改/etc/my.cnf为

[mysqld_safe]

log-error=/var/log/mysqld.log

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

[mysqld]

log_error= /var/log/mysql-error.log

user=mysql

datadir= /data/mysql

socket= /data/mysql/mysql.sock

[mysql]

socket= /data/mysql/mysql.sock

user= mysql

3. 验证

重启mysql服务，mysql客户端登录，查看datadir

mysql> show variables like '%dir%';+-----------------------------------------+----------------------------+

| Variable_name | Value |

+-----------------------------------------+----------------------------+

| basedir | /usr |

| binlog_direct_non_transactional_updates | OFF |

| character_sets_dir | /usr/share/mysql/charsets/ |

| datadir | /data/mysql/ |

| ignore_db_dirs | |

| innodb_data_home_dir | |

| innodb_log_group_home_dir | ./ |

| innodb_max_dirty_pages_pct | 75 |

| innodb_max_dirty_pages_pct_lwm | 0 |

| innodb_undo_directory | . |

| lc_messages_dir | /usr/share/mysql/ |

| plugin_dir | /usr/lib64/mysql/plugin/ |

| slave_load_tmpdir | /tmp |

| tmpdir | /tmp |

+-----------------------------------------+----------------------------+

14 rows in set (0.03 sec)

配置成功！！！