mysql 5.5 默认安装在 /var/lib/mysql下，现在想将它改到 /opt/mysql5.5 下

[root@test-han mysql]# pwd
/var/lib/mysql
[root@test-han mysql]# mv * /opt/mysql5.5/

修改 /etc/my.cnf
socket          = /opt/mysql5.5/mysql.sock

修改 /etc/init.d/mysql
datadir=/opt/mysql5.5

[root@test-han mysql]# service mysql start
Starting MySQL..The server quit without updating PID file (/opt/mysql5.5/test-han.pid).[FAILED]
这里是因为目录的权限不对

[root@test-han lib]# ls -ld /var/lib/mysql
drwxr-xr-x 2 mysql mysql 4096 Dec 12 16:01 /var/lib/mysql

[root@test-han opt]# chown -R mysql.mysql mysql5.5/

[root@test-han lib]# service mysql start
Starting MySQL....[  OK  ]