Adam Palmer MBCS CITP, Linux, PHP Programmer, MySQL Developer, Embedded Hardware, Security Consultant
Did my blog help you? Please link to me!
Did my blog help you? Please link to me!
20 Jan 09 How to reset forgotton MySQL root password
As long as you have root access to your debian machine, you can do this as follows:
/etc/init.d/mysql stop #stop MySQL
/usr/bin/mysqld_safe –skip-grant-tables & #start MySQL with –skip-grant-tables
/usr/bin/mysql -u root mysql #connect to mysql as root, straight into the ‘mysql’ database. No password is required
UPDATE user SET password=PASSWORD(’newrootpassword’) WHERE user=’root’; #Do replace ‘newrootpassword’ with something that you’ll remember.
FLUSH PRIVILEGES;
\q #to quit
/etc/init.d/mysql stop #stop MySQL
/etc/init.d/mysql start #start MySQL
/usr/bin/mysqld_safe –skip-grant-tables & #start MySQL with –skip-grant-tables
/usr/bin/mysql -u root mysql #connect to mysql as root, straight into the ‘mysql’ database. No password is required
UPDATE user SET password=PASSWORD(’newrootpassword’) WHERE user=’root’; #Do replace ‘newrootpassword’ with something that you’ll remember.
FLUSH PRIVILEGES;
\q #to quit
/etc/init.d/mysql stop #stop MySQL
/etc/init.d/mysql start #start MySQL
You can now test with mysql -u root -p you’ll be prompted for your password and your ‘newrootpassword’ should now work!
Tags: --skip-grant-tables, debian, MySQL, mysqld, mysqld_safe, reset password, root, root password
Leave a Comment
|
I'm Adam Palmer, and I'm a Freelance Embedded Linux/Embedded Hardware enthusiast and Security Consultant. I run 'APNIC Solutions Ltd' and spend most of my time managing server clusters, and doing some PHP/MySQL development, whilst what little spare time I have is dedicated to playing with gadgets. I'm always happy to consult on or manage any Linux related, Web Application or Hosting project. Please get in touch with me! |
