当前位置:论坛首页 > Linux面板 > 求助

MySQL服务无法正常启动

发表在 Linux面板2018-3-30 09:29 [复制链接] 2 1721

180330  9:28:37 [Note] Plugin 'FEDERATED' is disabled.
/www/server/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
180330  9:28:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
180330  9:28:37 InnoDB: The InnoDB memory heap is disabled
180330  9:28:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180330  9:28:37 InnoDB: Compressed tables use zlib 1.2.7
180330  9:28:37 InnoDB: Using Linux native AIO
180330  9:28:37 InnoDB: Initializing buffer pool, size = 256.0M
180330  9:28:37 InnoDB: Completed initialization of buffer pool
180330  9:28:37  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 /www/server/data/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.

以上是日志内容,请大咖帮忙看看到底怎么解决

使用道具 举报 只看该作者 回复
发表于 2018-3-30 09:35:36 | 显示全部楼层
尝试
>./scripts/mysql_install_db --user=mysql --datadir=/www/server/data
运行结果:
Installing MySQL system tables...
180330  9:33:47 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
180330  9:33:47 [Note] /www/server/mysql/bin/mysqld (mysqld 5.5.57-log) starting as process 23961 ...
ERROR: 1  Can't create/write to file '/www/server/data/mysql/db.MYI' (Errcode: 13)
180330  9:33:47 [ERROR] Aborting

180330  9:33:47 [Note] /www/server/mysql/bin/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/www/server/data for more information.

You can try to start the mysqld daemon with:

    shell> /www/server/mysql/bin/mysqld --skip-grant &

and use the command line tool /www/server/mysql/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /www/server/mysql/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /www/server/data that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before submitting a bug report
at http://bugs.mysql.com/

使用道具 举报 回复 支持 反对
发表于 2019-11-30 01:34:48 | 显示全部楼层
karlwu 发表于 2018-3-30 09:35
尝试
>./scripts/mysql_install_db --user=mysql --datadir=/www/server/data
运行结果:

最后怎么解决的
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

普通问题处理

论坛响应时间:72小时

问题处理方式:排队(仅解答)

工作时间:白班:9:00 - 18:00

紧急运维服务

响应时间:3分钟

问题处理方式:宝塔专家1对1服务

工作时间:工作日:9:00 - 18:30

宝塔专业团队为您解决服务器疑难问题

点击联系技术免费分析

工作时间:09:00至18:30

快速回复 返回顶部 返回列表