mysql启动问题

/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2017-09-14 09:02:25 21605 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-09-14 09:02:25 21605 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-09-14 09:02:25 21605 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-14 09:02:25 21605 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-14 09:02:25 21605 [Note] InnoDB: Memory barrier is not used
2017-09-14 09:02:25 21605 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-09-14 09:02:25 21605 [Note] InnoDB: Using CPU crc32 instructions
2017-09-14 09:02:25 21605 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
2017-09-14 09:02:25 21605 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2017-09-14 09:02:25 21605 [ERROR] Plugin 'InnoDB' init function returned error.
Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
主要是权限不足引起的,进入mysql数据库
cd /usr/local/mysql/data/mysql

添加权限

chown mysql *
chgrp mysql *
chmod ug+rwx *

重新启动数据库服务。

posted @ 2017-09-14 09:15  liter7  阅读(220)  评论(0编辑  收藏  举报