Linux下MySQL启动失败的解决一例

Linux下MySQL启动失败的解决一例:当敲mysql命令时
Can"t connect to local MySQL server through socket "/var/lib/mysql/mysql.sock"当敲service mysqld start命令时，或者/etc/init.d/mysqld startTimeout error occurred trying to start MySQL Daemon.查看log日志命令less /var/log/mysqld.log看看你是什么错误，我的是：
071119 23:09:04 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created！
071119 23:09:05 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
071119 23:09:05 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
071119 23:09:05 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
071119 23:09:06 InnoDB: Started; log sequence number 0 0
071119 23:09:06 [Note] /usr/libexec/mysqld: ready for connections.
Version: "5.0.22" socket: "/var/lib/mysql/mysql.sock" port: 3306 Source distribution
InnoDB: Error: trying to create a MySQL system table mysql/user of type InnoDB.
InnoDB: MySQL system tables must be of the MyISAM type！
071129 17:08:42 [Note] /usr/libexec/mysqld: Normal shutdown071129 17:08:42 InnoDB: Starting shutdown...
071129 17:08:46 InnoDB: Shutdown completed; log sequence number 0 2566023
071129 17:08:46 [Note] /usr/libexec/mysqld: Shutdown complete071129 17:08:46 mysqld ended071201 12:09:10 mysqld started
071201 12:09:11 InnoDB: Started; log sequence number 0 2566023
071201 12:09:11 [ERROR] Fatal error: Can"t open and lock privilege tables: Table "mysql.user" doesn"t exist
071201 12:09:11 mysqld ended071201 12:10:49 mysqld started
071201 12:10:49 InnoDB: Started; log sequence number 0 2566023
071201 12:10:49 [ERROR] Fatal error: Can"t open and lock privilege tables: Table "mysql.user" doesn"t exist
071201 12:10:49 mysqld ended071201 12:12:34 mysqld started
071201 12:12:34 InnoDB: Started; log sequence number 0 2566023
071201 12:12:34 [ERROR] Fatal error: Can"t open and lock privilege tables: Table "mysql.user" doesn"t exist
071201 12:12:34 mysqld ended071201 12:14:51 mysqld started
071201 12:14:51 InnoDB: Started; log sequence number 0 2566023
071201 12:14:51 [ERROR] Fatal error: Can"t open and lock privilege tables: Table "mysql.user" doesn"t exist
071201 12:14:51 mysqld ended

linux启动mysql服务Linux下用python连接Mysql相关资讯 mysql Linux知识

时光总是太匆匆！Linux已经诞生23 （08/29/2014 14:12:03）
MySQL Administrator连接VMWare下（05/24/2013 09:20:58）
MySQL 5.1.68 发布（02/05/2013 08:37:47）

数据库服务器 MySQL （08/15/2013 06:50:23）
MySQL 5.6 GA 及逃亡潮（02/08/2013 14:36:35）
MySQL 5.5.22、5.1.62、5.0.96全线（03/22/2012 19:03:49）

本文评论查看全部评论（0）