mysql修改local inflie_mysql修改数据存储路径报错处理

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

解决?: >>>

vim /etc/my.cnf

>>>

[client]

default-character-set=utf8

socket=/storage/db/mysql/mysql.sock

[mysql]

default-character-set=utf8

socket=/storage/db/mysql/mysql.sock

2019-06-27T09:08:24.769172Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2019-06-27T09:08:24.769304Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.

2019-06-27T09:08:24.769322Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.

2019-06-27T09:08:24.769333Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.

2019-06-27T09:08:24.769342Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.

2019-06-27T09:08:24.769364Z 0 [ERROR] InnoDB: Cannot open datafile './ibtmp1'

2019-06-27T09:08:24.769374Z 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary

2019-06-27T09:08:24.769384Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file

2019-06-27T09:08:25.370277Z 0 [ERROR] Plugin 'InnoDB' init function returned error.

2019-06-27T09:08:25.370330Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2019-06-27T09:08:25.370341Z 0 [ERROR] Failed to initialize builtin plugins.

2019-06-27T09:08:25.370349Z 0 [ERROR] Aborting

解决?: >>> setenforce 0 #临时关闭selinux模式

#或永久解决

vim /etc/selinux/config

>>>

SELINUX=disabled

如果安装了apparmor

vim /etc/apparmor.d/usr.sbin.mysqld

## 有这两行，规定了mysql使用的数据文件路径权限

/var/lib/mysql/ r,

/var/lib/mysql/** rwk,

改 >>>

/data/mysql/ r,

/data/mysql/** rwk,

## 重启:

sudo service apparmor restart