mysql 无论如何都启动不了

This topic created in 2072 days ago, the information mentioned may be changed or developed.

200907 17:36:42 [Note] Plugin 'FEDERATED' is disabled.
/www/server/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
200907 17:36:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
200907 17:36:42 InnoDB: The InnoDB memory heap is disabled
200907 17:36:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200907 17:36:42 InnoDB: Compressed tables use zlib 1.2.11
200907 17:36:42 InnoDB: Initializing buffer pool, size = 256.0M
20090717:36:42 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /www/server/data/ibdata1 did not exist:
InnoDB: a new database to be created!
200907 17:36:42 InnoDB: Setting file /www/server/data/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
200907 17:36:42 InnoDB: Log file /www/server/data/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /www/server/data/ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
200907 17:36:42 InnoDB: Log file /www/server/data/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /www/server/data/ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
200907 17:36:42 InnoDB: Waiting for the background threads to start
200907 17:36:43 InnoDB: 5.5.62 started; log sequence number 0
200907 17:36:43 [Note] Recovering after a crash using mysql-bin
200907 17:36:43 [Note] Starting crash recovery...
200907 17:36:43 [Note] Crash recovery finished.
200907 17:36:43 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
200907 17:36:43 [Note] - '0.0.0.0' resolves to '0.0.0.0';
200907 17:36:43 [Note] Server socket created on IP: '0.0.0.0'.
200907 17:36:43 [Warning] Insecure configuration for --pid-file: Location '/www/server/data' in the path is accessible to all OS users. Consider choosing a different directory.
200907 17:36:43 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

不知道这是什么情况啊
google 里面的都试过了
还是不行啊

innodb

17:36:42

17:36:43

Server

10 replies 2020-09-08 09:35:29 +08:00

wa8n

Sep 8, 2020 via iPhone

Please run mysql_upgrade to create it.

singerll

Sep 8, 2020 via Android

mysql_upgrade 好像是只有数据库启动后才能执行吧，把 plugin，host 表从别的库拷过来扔到数据目录，权限改正确，启动一下试试。

singerll

Sep 8, 2020 via Android

再不行就把 mysql 这个库的所有表都拷过来。记得好像是个 bug，数据目录本身是存在这个表的，但就是读不到。。。。启动成功后 drop 掉，再执行建表语句创建（ mysql 安装文件中有这几个语句）

vicnicLight007

Sep 8, 2020 via iPhone

服务器内存够不够。以前碰到这种，用的 docker

monkeydev

Sep 8, 2020

root@ubuntu:~# mysql_upgrade

Command 'mysql_upgrade' not found, but can be installed with:

apt install mysql-server-core-5.7
apt install mariadb-server-core-10.1
apt install percona-server-server-5.6
apt install percona-xtradb-cluster-server-5.7

@wangsongyan
@singerll
@singerll

dzdh

Sep 8, 2020

200907 17:36:43 [Warning] Insecure configuration for --pid-file: Location '/www/server/data' in the path is accessible to all OS users. Consider choosing a different directory.

--

--pid-file 制定的文件的路径中的位置是所有操作系统用户都可以访问的。考虑选择一个不同的目录

nutting

Sep 8, 2020

文件权限问题方向看看

steptodream

Sep 8, 2020

@monkeydev 从错误的路径看看样子你根本不是用 apt-get 安装的数据库你很可能用的一键包啥的

不是 apt-get 安装的 mysql 的命令很可能不在默认 PATH 里你可以试试 /www/server/mysql/bin/mysql_upgrade

594duck

Sep 8, 2020

加一个 skip-grant-tables 重启一下，先把 mysql 启动起来，再把数据备份了，再重新初始化一下 mysql

monkeydev

Sep 8, 2020

@steptodream
root@ubuntu:~# /www/server/mysql/bin/mysql_upgrade
Looking for 'mysql' as: /www/server/mysql/bin/mysql
Looking for 'mysqlcheck' as: /www/server/mysql/bin/mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed

报错误