A solution for MySQL startup failure in Linux

An example of how to solve MySQL startup failure in Linux:

When you press the mysql command
Can't connect to local MySQL server through socket '/var/lib/mysql. sock'

When you press the service mysqld start command, or/etc/init. d/mysqld start

Timeout error occurred trying to start MySQL Daemon.

View log command less/var/log/mysqld. log

Let's see what is wrong with you. Mine is:
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. 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 shutdown

071129 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 complete

071129 17:08:46 mysqld ended

071201 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 ended

071201 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 ended

071201 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 ended

071201 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

1 2 Next Page