Mysql启动问题

来源：百度知道编辑：UC知道时间：2024/06/30 12:45:55

[root@NO mysql]# ./bin/mysqld_safe --user=mysql &

[root@NO mysql]# Starting mysqld daemon with databases from /usr/local/web/mysql/var
STOPPING server from pid file /usr/local/web/mysql/var/NO.NUN.pid
080628 08:41:04 mysqld ended

[root@NO var]# vi NO.NUN.err
080628 08:41:04 mysqld started
080628 08:41:04 mysqld started
080628 8:41:04 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
080628 8:41:04 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
080628 8:41:04 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 2

系统是不是强行关闭过.还是强行停止过mysql进程.是你的数据库坏掉了用日志文件进行恢复.
这行.080628 8:41:04 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host'
找不到mysql库里的host表. mysql库是用户表,root也包含在里面.
像innodb是空间存储不像myisam文件形式存储出现这种错误除了用日志文件恢复外没其它办法了.
先想办法恢复用户库.
154651166愿意帮你.

启动MySQL的问题紧急求助！MySQL启动问题 MySQL问题 MySql问题 mysql问题 MYSQL问题~~~~~ mySQL问题为什么mysql不能启动？ MySql的服务启动失败 MYSQL无法启动，求解决办法！