[root@localhost log]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [失败]
我是看这里的教程http://help.dedecms.com/environment/2011/0614/73.html配置的。然后不行我就删了又重装的mysql 难道只能是重装linux系统了?这是日志:InnoDB: Log scan progressed past the checkpoint lsn 0 37356
130829 11:55:43 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...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
130829 11:55:43 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
130829 11:55:44 InnoDB: Started; log sequence number 0 44233
130829 11:55:44 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130829 11:55:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130829 12:03:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130829 12:03:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130829 12:03:33 InnoDB: Initializing buffer pool, size = 8.0M
130829 12:03:33 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
130829 12:03:33 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...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
130829 12:03:33 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
130829 12:03:33 InnoDB: Started; log sequence number 0 44233
130829 12:03:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130829 12:03:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130829 12:10:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130829 12:10:38 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130829 12:10:38 InnoDB: Initializing buffer pool, size = 8.0M
130829 12:10:38 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
130829 12:10:38 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...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
130829 12:10:38 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
130829 12:10:38 InnoDB: Started; log sequence number 0 44233
130829 12:10:38 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130829 12:10:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130829 12:29:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
"/var/log/mysqld.log" 86L, 6476C
MySQL Daemon failed to start.
Starting mysqld: [失败]
我是看这里的教程http://help.dedecms.com/environment/2011/0614/73.html配置的。然后不行我就删了又重装的mysql 难道只能是重装linux系统了?这是日志:InnoDB: Log scan progressed past the checkpoint lsn 0 37356
130829 11:55:43 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...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
130829 11:55:43 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
130829 11:55:44 InnoDB: Started; log sequence number 0 44233
130829 11:55:44 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130829 11:55:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130829 12:03:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130829 12:03:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130829 12:03:33 InnoDB: Initializing buffer pool, size = 8.0M
130829 12:03:33 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
130829 12:03:33 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...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
130829 12:03:33 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
130829 12:03:33 InnoDB: Started; log sequence number 0 44233
130829 12:03:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130829 12:03:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130829 12:10:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130829 12:10:38 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130829 12:10:38 InnoDB: Initializing buffer pool, size = 8.0M
130829 12:10:38 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
130829 12:10:38 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...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
130829 12:10:38 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
130829 12:10:38 InnoDB: Started; log sequence number 0 44233
130829 12:10:38 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130829 12:10:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130829 12:29:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
"/var/log/mysqld.log" 86L, 6476C
解决方案 »
- 求教如何找出没有使用索引的语句
- 如何减缓服务器对数据库操作的压力???
- 查询同一个字段,值相同的数据
- 一样简单的查询,不一样的速度!
- JSP网页里是charset=UTF-8,Mysql5的数据库也设成了UTF-8,可为啥通过JSP网页存取数据库,中文还是乱码?
- mysqldump 如何忽略表中的一些记录?
- ERROR 1044: Access denied for user: ''@'localhost' to database 'testdb'
- MYSQL不支持汉字???必给分,在线等待!
- MYSQL在建表时如何实现多表关联?
- 一个大批量数据更新的问题
- 为什么MYSQL使用视图查询2w条数据中其中1天的数据都要1S呢?
- 再问随机选取记录
host.frm
host.MYD
host.MYI
导致到别的mysql安装目录下拷贝后就可以了吧?