mysql問題発生記録

mysql
質問レコード:

service mysql start       ：

140207 14:30:33 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140207 14:30:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140207 14:30:33 InnoDB: The InnoDB memory heap is disabled
140207 14:30:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140207 14:30:33 InnoDB: Compressed tables use zlib 1.2.3.4
140207 14:30:33 InnoDB: Initializing buffer pool, size = 128.0M
140207 14:30:33 InnoDB: Completed initialization of buffer pool
140207 14:30:33  InnoDB: 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.

原因:

ubuntuではmysqlのデフォルトのデータベース格納パスは/var/lib/mysqlです.管理者は/etc/mysql/myです.cnfはdatadirを再定義したが/data/mysqlは正しい権限を設定せず、chown-R mysql:mysql/data/mysql権限をリセットすると、サービスは正常に起動する

注意:/etc/mysql/myが変更された場合.cnfの構成、/etc/apparmor.d/usr.sbin.mysqldにも対応する構成

が追加されています.

#datadir        = /var/lib/mysql
datadir         = /data/mysql

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

/var/log/mysql/ r,
/var/log/mysql/* rw,