今天进mysql看里面表太多了,一时手贱,删了很多,包括mysql和test,所以现在mysql服务启动不了了。
下面是错误日志:
120222 14:15:42 [Note] Event Scheduler: Purging the queue. 0 events
120222 14:15:51 InnoDB: Starting shutdown...
120222 14:16:01 InnoDB: Shutdown completed; log sequence number 0 311261446
120222 14:16:02 [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
120222 14:17:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120222 14:17:16 InnoDB: Started; log sequence number 0 311261446
120222 14:17:16 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
下面是错误日志:
120222 14:15:42 [Note] Event Scheduler: Purging the queue. 0 events
120222 14:15:51 InnoDB: Starting shutdown...
120222 14:16:01 InnoDB: Shutdown completed; log sequence number 0 311261446
120222 14:16:02 [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
120222 14:17:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120222 14:17:16 InnoDB: Started; log sequence number 0 311261446
120222 14:17:16 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
解决方案 »
- 才开始学mysql,为什么创建存储过程老提示stored routine?
- MYSQL多表查询的问题
- 比较同一表内数据差异
- mysql管理工具还有什么,sqlyog老是导错库
- [MySQL]如何在不破坏原有数据的情况下增加一个字段的长度?
- java连接mysql4.1的问题
- 语法问题????
- 安装mysql5.6.10 在cmd中输入net start mysql提示服务名无效
- 请大神指教这个MYSQL语句的错误,关于触发器的
- Variable 'innodb_lock_wait_timeout' is a read only variable
- mysql怎么打补丁啊?
- linux安装mysql问题
如果没有备份的话就另外找一个MySQL把MySQL这个库拷贝过来看看。