Eric Wilson's Blog

Experiments in engineering, life and the pursuit of a better hammer.

Eric Wilson's blog discussing Product Development and Software Engineering.

  • Blog
  • Snippets
  • About
  • Contact
  • Search

Set MySQL root password to NULL

April 10, 2013 by Eric Wilson in operations

​Not recommended but if needed...

From the command line

sudo service mysql stop
sudo mysqld_safe --skip-grant-tables --skip-networking &
mysql -uroot

From MySQL

use mysql;
update user set password=null where User='root';
flush privileges;
quit;
April 10, 2013 /Eric Wilson
database, mysql, password
operations
  • Newer
  • Older
This work is licensed under a Creative Commons License and is the private blog of Eric Wilson.
The opinions are my own and are not endorsed by my current or former employers or colleagues.
Creative Commons License