Prev Previous Post   Next Post Next
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


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL problem - Sometimes cann't connect to MySQL Ronniea Server Operation 2 16th July 2012 22:01
Sending mails: fine > recive: bad Moundy General 1 20th June 2012 00:40
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 11:49
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 02:05
Problem Installing Apache 2.2.8, MySQL 5.0 Client and PHP 5.2.5 On Fedora 8 (64-Bit) asyadiqin Installation/Configuration 5 10th April 2008 19:40

All times are GMT +2. The time now is 07:53.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.