ubuntu16.04 安装lnmp后，mysql启动报错 ，拜托了！谢谢大神

lzm2494239

这个是安装日志：http://139.196.101.133:8116/lnmp-install.log   
拜托了！

lzm2494239

这个是启动查询到的： Unit mysql.service has begun starting up.
Dec 27 12:10:25 hostcacc mysql[15800]: Starting MySQL. * Manager of pid-file quit without updating file.
Dec 27 12:10:25 hostcacc systemd[1]: mysql.service: Control process exited, code=exited status=1
Dec 27 12:10:25 hostcacc systemd[1]: Failed to start LSB: start and stop MySQL.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Dec 27 12:10:25 hostcacc systemd[1]: mysql.service: Unit entered failed state.
Dec 27 12:10:25 hostcacc systemd[1]: mysql.service: Failed with result 'exit-code'.

lzm2494239

启动的mysql报错日志：191227 13:29:06  InnoDB: Started; log sequence number 0 44233
191227 13:29:06 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
191227 13:29:06 mysqld_safe mysqld from pid file /usr/local/mysql/var/hostcacc.pid ended

licess

Installing MySQL system tables...
ERROR: 1  Can't create/write to file '/usr/local/mysql/var/mysql/db.MYI' (Errcode: 13)
191227 11:20:53 [ERROR] Aborting

可能你数据库目录权限有问题，数据库表无法正常安装，可以尝试修改 lnmp.conf 中数据库目录的位置然后重新安装

lzm2494239

我是使用root用户安装的，需要安装前吧目录设置位777吗

licess

lzm2494239 发表于 2019-12-29 12:23
我是使用root用户安装的，需要安装前吧目录设置位777吗

一般不需要单独做设置，但是某些可能硬盘挂载有问题或虚拟机挂载ntfs或系统有问题可能会导致无法正常写入