CentOS 6.5 mysql切换存储目录

1. mkdir /disk/mysql

2. /etc/my.cnf中的/var/lib/mysql 换成/disk/mysql

3. /etc/init.d/mysqld 中的/var/lib/mysql 换成/disk/mysql

4. /usr/bin/mysqld_safe中的/var/lib/mysql换成/disk/mysql

5. setenforce 0

6. 如果要外部访问，/etc/sysconfig/iptables中添加相应的端口

7.  mysql_install_db --user=mysql --datadir=/disk/mysql/

8. chown -R mysql:mysql /disk/mysql

设置远程访问

1.  GRANT all privileges ON *.* TO 'name'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

2. GRANT all privileges ON *.* TO 'name'@'machineName' IDENTIFIED BY 'password' WITH GRANT OPTION;