Billymayday,
I finally got around to try it but I don't have any luck. Getting "Timeout error occurred trying to start MySQL Daemon."
selinux is off
[root@centos53a ~]# ls -dZ /var/lib/mysql
drwxr-xr-x mysql mysql system_u
bject_r:mysqld_db_t:s0 /var/lib/mysql
[root@centos53a ~]# ls -dZ /u03
drwxr-xr-x mysql mysql /u03
*** I did the command you suggested below, /u03 is the new location of mysql in my.cnf file ***
[root@centos53a ~]# chcon system_u
bject_r:mysqld_db_t:s0 /u03
[root@centos53a ~]# ls -dZ /u03
drwxr-xr-x mysql mysql system_u
bject_r:mysqld_db_t:s0 /u03
selinux is on
reboot
*** after reboot, it shows the following***
[root@centos53a /]# ls -dZ /var/lib/mysql
drwxr-xr-x mysql mysql system_u
bject_r:mysqld_db_t /var/lib/mysql
[root@centos53a /]# ls -dZ /u03
drwxr-xr-x mysql mysql system_u
bject_r:mysqld_db_t /u03
-John