mysql问题排查
系统删除了mysql用户，导致mysql重启报错，内容如下：161025 21:24:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
161025 21:24:55 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
161025 21:24:55InnoDB: Initializing buffer pool,> 161025 21:24:55InnoDB: Completed initialization of buffer pool
161025 21:24:55InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
161025 21:24:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
考虑到mysql服务使用mysql用户启动的，首先增加mysql用户，useradd -r mysql
修改目录权限：cd /var/lib/mysql
chown -R mysql.mysql *
启动还是报错，显示信息：
161025 21:57:47 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13)
161025 21:57:47 Can't start server: can't create PID file: Permission denied
这个很明显了，mysql.pid没有权限生成
赋予权限：chown -R mysql.mysql /var/run/mysqld/
启动mysql，成功。
页:
[1]