View Single Post
Old 5th October 2012, 13:35
destinedjagold destinedjagold is offline
Junior Member
Join Date: Aug 2012
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
Default MySQL-related problem

I don't understand what happened. I haven't touched the server in a while, and when I typed the code
service mysqld start
CentOS 6.3 replies with an
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
I looked though the log files, and it gave me this...
121005 18:05:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121005 18:05:42 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
121005 18:05:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121005 18:05:42 InnoDB: The InnoDB memory heap is disabled
121005 18:05:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121005 18:05:42 InnoDB: Compressed tables use zlib 1.2.3
121005 18:05:42 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibwnGp95' (Errcode: 13)
121005 18:05:43  InnoDB: Error: unable to create temporary file; errno: 13
121005 18:05:43 [ERROR] Plugin 'InnoDB' init function returned error.
121005 18:05:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121005 18:05:43 [ERROR] Unknown/unsupported storage engine: InnoDB
121005 18:05:43 [ERROR] Aborting
I have been searching around Google for a day now, and every single solution I land upon, it didn't help me with my problem.

Additional note...
- typing mysql_upgrade results in this...
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
Another note...
- the latest version of MySQL is version 5.5.28. Is there a way to let CentOS download and install MySQL version 5.5.25* ?

Any help would be greatly appreciated. Thank you.
Reply With Quote
Sponsored Links