Prev Previous Post   Next Post Next
  #1  
Old 5th October 2012, 12: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
Code:
service mysqld start
CentOS 6.3 replies with an
Code:
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
I looked though the log files, and it gave me this...
Code:
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...
Code:
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
 

Bookmarks

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 21:01
Sending mails: fine > recive: bad Moundy General 1 19th June 2012 23:40
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 01: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 18:40


All times are GMT +2. The time now is 01:13.


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