在my.cnf中,设置如下:
[mysqld]
datadir=/home/mysql/data
socket=/home/mysql/data/mysql.sock
数据库启动时
[root@redlinux01 ~]# service mysql restart
Stopping mysqld: [ OK ]
2017-09-01T08:19:01.971002Z mysqld_safe Directory '/home/mysql/data' for UNIX socket file don't exists.
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
可是目录已经存在,而且权限也有,可是就是不成功
[mysql@redlinux01 ~]$ ls -trl
total 768
drwxrwxr-x. 2 mysql mysql 4096 Aug 15 18:17 logs
drwxrwxrwx. 5 mysql mysql 4096 Aug 31 02:47 data
[mysql@redlinux01 ~]$ pwd
/home/mysql
只有将数据库路径该为默认的
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
启动才能成功
[root@redlinux01 ~]# service mysql restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
初学mysql,请高手给指点一下,这是什么原因造成的?