Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » SMS User Support

Post new topic   Reply to topic
MySQL fails to start
View previous topic :: View next topic  
Author Message
Busta
-{ D.O.N.A.T.O.R. }-


Joined: 13 Aug 2007
Posts: 81

PostPosted: Tue Jun 19, 2012 3:37 am    Post subject: MySQL fails to start Reply with quote

This issue started after the update to MySQL ; mysql-5.5.25-i486-1sms

InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120618 20:29:39 InnoDB: Waiting for the background threads to start
120618 20:29:40 InnoDB: 1.1.8 started; log sequence number 1589339
120618 20:29:40 [Note] Recovering after a crash using mysql-bin
120618 20:29:40 [Note] Starting crash recovery...
120618 20:29:40 [Note] Crash recovery finished.
120618 20:29:40 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it
120618 20:29:40 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
120618 20:26:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it

I have uninstalled and reinstalled both mysql and mysql-data, but did not fix. Could this be a upgrade issue?
Back to top
View user's profile Send private message
Busta
-{ D.O.N.A.T.O.R. }-


Joined: 13 Aug 2007
Posts: 81

PostPosted: Tue Jun 19, 2012 4:06 am    Post subject: Reply with quote

never mind, found another post of another user having same issue. Remove user.MYI , user.MYD, and tables_priv.MY* and reinstalled mysql_data fixed the issue
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional