宝塔mysql5.6安装:Table 'mysql.user' doesn't exist

最近在某些Ubuntu 18.04 server 64bit服务器上安装宝塔6.0出现mysql无法启动的问题,出现以下报错

2020-02-04 20:32:31 30857 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144
/www/server/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist

2020-02-04 20:32:31 30857 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

2020-02-04 20:32:32 30857 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

单独在宝塔面板卸载mysql重新安装依旧报同样的错误 百度找资料看到以下文章

本来初始化配置是这样的
scripts/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data –user=mysql 出现了 [root@localhost mysql-5.6.14]# service mysql restart ERROR! MySQL server PID file could not be found! Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).
在日志中出现了如下错误： Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
后来采用了下面的语句就可以了： scripts/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data –user=mysql –ldata=/var/lib/mysql
————————————————
版权声明：本文为CSDN博主「roosterhpf」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。 原文链接：https://blog.csdn.net/dapeng0112/article/details/37053407

尝试后依旧报错 最终解决办法是

1.在宝塔面板启动一次mysql(启动失败)

2.在mysql安装目录执行

./scripts/mysql_install_db --user=mysql

3.再次启动mysql即可