在linux下用安装的mysql 总是启动不了。日志如下。。。这是杂回呈啊
[root@localhost log]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [失败]
我是看这里的教程http://help.dedecms.com/environment/2011/0614/73.html配置的。然后不行我就删了又重装的mysql
难道只能是重装linux系统了?
这是日志:
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服务启动不了解决方案
最近在Windows 2003上的MySQL出现过多次正常运行时无法连接数据库故障,现象是无法连接数据库,也无法停止MySQL或重启MYSQL,由于每次都是草草尝试各种方法搞定即可本文将详细介绍解决方法
Linux环境下MySQL安装与日志管理实战指南
本文还有配套的精品资源,点击获取 简介:本文详细介绍了在Linux系统中安装MySQL的完整过程,并涵盖了对MySQL日志的配置与分析。提供了一些重要的MySQL日志文件类型,如错误日志、查询日志、慢查询日志,并说明了它们的设置和作用。此外,还包括了如何使用内置工具和第三方工具对日志进行分析,并指导如何定期清理日志以保持系统的良好性能。教程最后还提到了如何查看MySQL的历...
Linux安装mysql5.7详细步骤
Linux安装mysql5.7详细步骤,经实践可用。
linux 安装 Mysql
linux 安装mysql
mysql linux版安装包
mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz,用于安装mysql linux版本,放心可用


