Linux to modify the MySQL database storage directory location

1. Set up a new storage path

Mkdir-p/data/mysql

2. Copy existing data

Cp-r/var/lib/mysql/*/data/mysql

3. Modify Permissions

Chown-r Mysql:mysql/data/mysql

4. Modify the configuration file

Vim/etc/mysql/my.cnf
DataDir =/data/mysql

5. Modify Startup file

Vim/etc/apparmor.d/usr.sbin.mysqld
#把

/var/lib/mysql R,
/var/lib/mysql/** Rwk,
#改成

/data/mysql R,
/data/mysql/** Rwk,

6. Restart Service

Restart AppArmor

/etc/init.d/apparmor restart
/etc/init.d/mysql restart

PS If it is a Windows server directly find the My.ini file, and then find Basedir can be modified, this is not introduced.