Mysql修改datadir导致无法启动问题解决方法
centos6.2,停止mysqld然后修改/etc/my.cnfdatadir的位置,启动mysqld提示FAILED,查看日志
12060911:31:31mysqld_safemysqldfrompidfile/var/run/mysqld/mysqld.pidended 12060911:35:12mysqld_safeStartingmysqlddaemonwithdatabasesfrom/mnt/hgfs/mysql_data 12060911:35:13[Warning]Can'tcreatetestfile/mnt/hgfs/mysql_data/data.lower-test 12060911:35:13[Warning]Can'tcreatetestfile/mnt/hgfs/mysql_data/data.lower-test /usr/libexec/mysqld:Can'tchangedirto'/mnt/hgfs/mysql_data/'(Errcode:13) 12060911:35:13[ERROR]Aborting
12060911:35:13[Note]/usr/libexec/mysqld:Shutdowncomplete
12060911:35:13mysqld_safemysqldfrompidfile/var/run/mysqld/mysqld.pidended