Today, because I need to restart the online server, when Sa told me that his side is OK, I started to restart MYSQL:/usr/local/MySQL/bin/mysqld_safe -- user = MySQL &
However, after reading the MySQL Error Log, we found the following error:
InnoDB: Error in opening./ibdata1
120412 13:38:09 InnoDB: operating system error number 11 in a file operation.
InnoDB: error number 11 means 'Resource temporarily unavailable '.
InnoDB: some operating system error numbers are described
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
120412 13:38:09 InnoDB: cocould not open or create data files.
120412 13:38:09 InnoDB: If you tried to add new data files, and it failed here,
120412 13:38:09 InnoDB: You shocould now edit innodb_data_file_path in my. CNF back
120412 13:38:09 InnoDB: to what it was, and remove the new ibdata files InnoDB created
120412 13:38:09 InnoDB: In this failed attempt. InnoDB only wrote those files full
120412 13:38:09 InnoDB: zeros, but did not yet use them in any way. But be careful: Do not
120412 13:38:09 InnoDB: remove old data files which contain your precious data!
120412 13:38:09 [Error] plugin 'innodb' init function returned error.
120412 13:38:09 [Error] plugin 'innodb' registry as a storage engine failed.
120412 13:38:09 [Error] Unknown/unsupported storage engine: InnoDB
120412 13:38:09 [Error] aborting
120412 13:38:09 [note]/usr/local/MySQL/bin/mysqld: shutdown complete
120412 13:38:09 mysqld_safe mysqld from PID file/data/mysql_db/mysql-b.pid ended
The following error is reported when connecting to MySQL:
Error 2002 (hy000): Can't connect to local MySQL server through socket '/tmp/MySQL. Sock' (2)
However, you can use IP links
Mysql-uroot-p127.0.0.1
After repeated tests. I finally found the problem, because MySQL was started by default when the system was restarted, and I started it again.