Lost Root MySql Password

Recent Articles

Stop DNSMasq From Forwarding Local Hostnames

Saturday, September 25, 2010

Securing your Wireless LAN

Wednesday, August 18, 2010

Some tips and things you might not know about your wireless network.

Using Different Subversion Client Versions

Wednesday, August 18, 2010

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.

Controlling complexity is the essence of computer programming.
- Brian Kernigan

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

Securing your Wireless LAN
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...
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.

Comment Sunday, May 17, 2009 by umesh

my mysql setup has no "mysqld_safe" command, in that case what we do?

Comment Friday, November 13, 2009 by anonymous

mysql is one fag program and all thanks to that password shit

Comment Monday, February 1, 2010 by by mike

+1 "my mysql setup has no "mysqld_safe" command, in that case what we do?"

Comment Tuesday, February 2, 2010 by anonymous

thanks friend, you saved my ass :)

Comment Thursday, June 10, 2010 by Me

thanks it's exactly what I want!!!

Comment Monday, April 11, 2011 by Joy

When i write, "mysql stop", it is showing an Error " ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)"

Please give the solution !!