How To Reset the MySQL Password : Ubuntu 7.10
I found myself toying with one of my test servers the other nite and realized that I didn’t know what the root password was for my MySQL database. After a quick bit of Google searching I found a very easy solution. Granted this may be limited to recent releases of Ubuntu (tested on Ubuntu 7.10), but other solutions did not work for me.
Resetting the Password
To reset the MySQL root password on Ubuntu we can simply reconfigure the installed package, which prompts for the root user password setting at installation.
sudo dpkg-reconfigure mysql-server-5.0
This should display a dialog box asking for a new root user password. Enter a new password and it’s reset. Can’t be much simpler than that.
If this article has been helpful, please consider linking to it.
without reconfiguring check this simple command to change mysql root password
http://www.ubuntugeek.com/reset-the-root-password-on-mysql.html
Or just use
# mysqladmin password NEWPASSWORD
As root
from the mysql docs
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
m
ysqld_safe –skip-grant-tables -u root &
Looks like the ‘reset-password’ function that a lot of other sites mention for this problem has been removed from the init.d script in ubuntu 7.10.
Thanks, this is just what I needed. I can stop cutting myself now.
This works great, thumbs up geezer. I read heaps of different methods etc infinitum, yours worked straight away
this works.. very thanks…
does the job – thanks
great tipp – thanks
Worked perfectly and faster than most methods which didn't work very well.
Justin’s instructions were very easy, just one line in Terminal!
# mysqladmin password NEWPASSWORD
As root
Works good! Thanks.
Hey,
thanks a lot of for your greatful help! It´s was very helpfull on my Ubuntu-System.
Regards
Tom
Thanks!!