Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Closed Thread
Can a power cut corrupt a mysql root password?
Old 06-10-2010, 05:17 PM Can a power cut corrupt a mysql root password?
Experienced Talker

Posts: 41
Name: Conrad
Trades: 0
Had a power issue today. Server was down for a good 4 hours. When power was restored, I found I could not log into the MySQL database as root. All the other users appeared to be okay. Just root got corrupted (either that or it was compromised before the power cut O.o ). Is that normal? I've never known just the root password to get effed.
__________________

Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE
MakeFreeCashMan is offline
View Public Profile
 
 
Register now for full access!
Old 06-10-2010, 07:13 PM Re: Can a power cut corrupt a mysql root password?
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
It could.
Linux uses as much ram as it can as a buffer, so if files where modified, in the buffer, but not commited, you can loose the changes.

But it's not very probable, as almost every linux distro released in the last 5 years should use a journaled filesystem, which most promoted usage is that in case of a dirty shutdown, the journal is still there to be commited upon the next partition mount (ie: restart of the system).

Either you have someone that changed it, or you typed it wrong.
But the method to reset that password is well known, as long as you have a shell access to the server:
http://dev.mysql.com/doc/refman/5.0/...rmissions.html
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
View Public Profile Visit tripy's homepage!
 
Old 06-11-2010, 04:04 PM Re: Can a power cut corrupt a mysql root password?
Experienced Talker

Posts: 41
Name: Conrad
Trades: 0
Thanks buddy. Resetting it wasn't a problem.
__________________

Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE
MakeFreeCashMan is offline
View Public Profile
 
Old 06-11-2010, 04:34 PM Re: Can a power cut corrupt a mysql root password?
lynxus's Avatar
Awesomeo-Maximo

Posts: 1,618
Location: UK
Trades: 1
While its possible ( as noted above )

I wouldnt let it be...
Check you haven't been hacked. check your code and make sure your tables haven't been changed.
__________________

Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE


lynxus is offline
View Public Profile Visit lynxus's homepage!
 
Old 06-11-2010, 04:50 PM Re: Can a power cut corrupt a mysql root password?
Experienced Talker

Posts: 41
Name: Conrad
Trades: 0
I have had a good nose through, and can't see anything out of the ordinary. I have it all backed up anyway, so should be okay.
__________________

Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE
MakeFreeCashMan is offline
View Public Profile
 
Closed Thread     « Reply to Can a power cut corrupt a mysql root password?
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.58488 seconds with 12 queries