Lost Root MySql Password

Recent Articles

Handling a Subversion Repository URL Change

Sunday, May 3, 2009

If your repository URL changes, you can use the following command to fix existing snapshots.

vfat Mounts Default to Lowercase Shortnames

Tuesday, April 21, 2009

I want a "this is brain-damage" quote from Linus for this mess.

VirtualBox or VMWare Virtual Machine at Login

Sunday, April 12, 2009

How to start a virtual machine in X when a user logs in.

Dialog Progress Bar Through Pipe

Sunday, April 12, 2009

How to use dialog to display a script progress bar and communicate progress to it through a named pipe.

Mount JFFS2 Image

Saturday, October 25, 2008

Example of how to mount a JFFS2 image using mtdblock.

Ottawa Linux Symposium 2008

Sunday, July 27, 2008

Here are some pictures from the 2008 Linux Symposium.

Linux Symposium 2008

Sunday, July 20, 2008

I'll be attending the Linux Symposium this year.

Clay Shirky: Institutions vs. collaboration

Monday, July 14, 2008

This is a rather interesting talk that takes some very foundational ideas from open source software development, P2P networks, and social networking and implies that these paradigms can apply to a lot more.

Computers don't solve problems, they execute solutions.

Sys Admin

Lost Root...

Lost Root MySql Password

Friday, December 31, 2004 by digitalpeer

Just follow these simple steps to reset the password. The trick here is you start the server and tell it not to use the grant tables. This allows you to reset the root password.

Stop the MySql server.
/usr/bin/mysqld_safe --skip-grant-tables &
mysql -h localhost
use mysql
update user set password = password('.......') where user = 'root' and host='localhost';
quit
Restart the server and run as normal.

Related Local Pages

vfat Mounts Default to Lowercase Shortnames
Linux NFS Root and PXE-Boot
Emacs Tips and Tricks
Embedded libc Options
X11 Config
MySql >= 4.1 Client does not support authentication protocol...
Securing your Wireless LAN
Stunnel - Universal SSL Wrapper
g4u Hard Drive Imaging
Home Network Layout

Comment Thursday, July 28, 2005 by anonymous

worked beautifully - cheers!

Comment Monday, June 25, 2007 by M Srinivasa Rao

excellent

Comment Tuesday, August 7, 2007 by by palash

i read this instruction,i am implemented your steps.it is really helpful for me.
thanks and regards
palash

Comment Friday, November 28, 2008 by anonymous

10x ! very usefull

Comment Monday, December 1, 2008 by anonymous

My MySQL server crashed. Apparently, some data were corrupted by the crash and I didn't have root access to mysql anymore.
Thanks to this tip, I got access back.

Comment Sunday, February 15, 2009 by by Chris Adams

Thank you so much - this is exactly what I needed.

Comment Wednesday, April 8, 2009 by anonymous

Thank you thank you thank you. This sure beats uninstalling and reinstalling mysql.