Ubuntu 服务器修改 MySQL 数据目录至 /var/lib/mysql3307,启动报错:
InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
ls -ld /var/lib/mysql3307
# drwx------ 4 mysql mysql 4096 Feb 18 15:09 /var/lib/mysql3307
属主 mysql:mysql、权限 700 看似无问题。
dmesg | grep -i apparmor
# type=1400 audit(1455768562.142:57): apparmor="DENIED" operation="mknod"
# profile="/usr/sbin/mysqld" name="/var/lib/mysql3307/ibdata1" pid=19775
AppArmor 强制访问控制 拦截了 mysqld 在新目录创建文件。
vi /etc/apparmor.d/usr.sbin.mysqld
# 在文件末尾添加
/var/lib/mysql3307/ r,
/var/lib/mysql3307/** rwk,
# 重载配置
/etc/init.d/apparmor restart
再次启动报错:
[ERROR] Can't start server: Bind on unix socket: Permission denied
dmesg: apparmor="DENIED" operation="mknod" name="/run/mysqld/mysqld3307.sock"
继续追加 Socket 目录权限:
/var/run/mysqld/mysqld3307.pid rw,
/var/run/mysqld/mysqld3307.sock w,
/run/mysqld/mysqld3307.pid rw,
/run/mysqld/mysqld3307.sock w,
重载 AppArmor 后再次启动。
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
新数据目录为空,缺少系统表。执行初始化:
mysql_install_db --defaults-file=/etc/mysql/my3307.cnf
mysqld_safe --defaults-file=/etc/mysql/my3307.cnf
# [Note] /usr/sbin/mysqld: ready for connections.
# Version: '5.5.46' socket: '/var/run/mysqld/mysqld3307.sock' port: 3307
mysql_install_db(5.7-)或 mysqld --initialize(5.7+)生成系统表。my.cnf(--defaults-file),避免端口、socket、datadir 冲突。