我是新手我在2003下装MYSQL5.1第一次装mysql,运行很正常,用phpMyAdmin可以连接,可以访问后来因为忘记密码,只好重装了问题是重装完毕后,mysql每次都启动不起来在WIN2003的服务里手动启动,总提示1067错误我后来检查MY,INI文件,好像是数据文件的位置不对,修改后,在数据文件夹下生成一个*.err的文件
我用记事本打开如下!大哥帮我分析下,错误在哪我重装了N次了,也在网上找了N多解决办法,MYSQL服务就是起不来,总是1067错误我都要崩溃了!
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table 'mysql.plugin' doesn't exist
090420 13:15:46 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090420 13:15:46 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 34 MB
InnoDB: Database physically writes the file full: wait...
090420 13:15:47 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 34 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Cannot initialize created log files because
InnoDB: data files are corrupt, or new data files were
InnoDB: created when the database was started previous
InnoDB: time but the database was not shut down
InnoDB: normally after that.
090420 13:15:48 [ERROR] Plugin 'InnoDB' init function returned error.
090420 13:15:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090420 13:15:48 [ERROR] Unknown/unsupported table type: INNODB
090420 13:15:48 [ERROR] Aborting090420 13:15:48 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown completeC:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table 'mysql.plugin' doesn't exist
090420 13:16:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
090420 13:16:10 [ERROR] Plugin 'InnoDB' init function returned error.
090420 13:16:10 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090420 13:16:10 [ERROR] Unknown/unsupported table type: INNODB
090420 13:16:10 [ERROR] Aborting090420 13:16:10 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
我用记事本打开如下!大哥帮我分析下,错误在哪我重装了N次了,也在网上找了N多解决办法,MYSQL服务就是起不来,总是1067错误我都要崩溃了!
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table 'mysql.plugin' doesn't exist
090420 13:15:46 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090420 13:15:46 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 34 MB
InnoDB: Database physically writes the file full: wait...
090420 13:15:47 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 34 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Cannot initialize created log files because
InnoDB: data files are corrupt, or new data files were
InnoDB: created when the database was started previous
InnoDB: time but the database was not shut down
InnoDB: normally after that.
090420 13:15:48 [ERROR] Plugin 'InnoDB' init function returned error.
090420 13:15:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090420 13:15:48 [ERROR] Unknown/unsupported table type: INNODB
090420 13:15:48 [ERROR] Aborting090420 13:15:48 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown completeC:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table 'mysql.plugin' doesn't exist
090420 13:16:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
090420 13:16:10 [ERROR] Plugin 'InnoDB' init function returned error.
090420 13:16:10 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090420 13:16:10 [ERROR] Unknown/unsupported table type: INNODB
090420 13:16:10 [ERROR] Aborting090420 13:16:10 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
解决方案 »
- mysql在命令符下如何用insert语句向数据库录入中文数据?????????
- mysql建方面的多对多的实例原理该如何理解?
- mysql存储过程查询赋值
- 用Mysql查询出A表中与掉B表相同的部分,并输出结果
- MySql 语句优化
- 组合框过滤相同项
- 如何判断一个mysql表的类型
- 用Delphi连接mysql有个奇怪的问题,急求帮助!!!!!!
- 怎样从mysql中随机提取一条记录?
- 用mm.mysql.jdbc连接mysql的user库,其中的Y/N都能显示出,但localhost不能显示?
- 数据库:MYSQL,在程序里用HQL语言,是否可以调用datediff来比较是否该数据为当天的数据
- 设置了auto_increment怎么添加数据?
090420 13:16:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade tocreate it.按照提示支持一下 mysql_upgrade.exe
或者重装mySQL