How to find out the MySQL root password

by

thanks to @thusharaK I could reset the root password without knowing the old password.

On ubuntu I did the following:

sudo service mysql stop
sudo mysqld_safe --skip-grant-tables --skip-syslog --skip-networking

Then run mysql in a new terminal:

mysql -u root

And run the following queries to change the password:

UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE User="root";
FLUSH PRIVILEGES;

In MySQL 5.7, the password field in mysql.user table field was removed, now the field name is ‘authentication_string’.

Quit the mysql safe mode and start mysql service by:

mysqladmin shutdown
sudo service mysql start

More Related Contents:

  1. How do I store large no.of small entries in Mysql?
  2. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  3. 1052: Column ‘id’ in field list is ambiguous
  4. How to do a batch insert in MySQL
  5. Count the occurrences of DISTINCT values
  6. Codeigniter – multiple database connections
  7. Location of my.cnf file on macOS
  8. Maximum number of records in a MySQL database table
  9. Swapping column values in MySQL
  10. JOIN queries vs multiple queries
  11. Is the primary key automatically indexed in MySQL?
  12. Storing Data in MySQL as JSON
  13. MySql: MyISAM vs. Inno DB! [closed]
  14. MySQL: Cloning a MySQL database on the same MySql instance
  15. DOs and DONTs for Indexes [closed]
  16. How to change the default port of mysql from 3306 to 3360
  17. Meaning of “n:m” and “1:n” in database design
  18. How to set a MySQL row to READ-ONLY?
  19. MySQL: LAST_INSERT_ID() returns 0
  20. mySQL – Create a New Table Using Data and Columns from Three Tables
  21. Calculating a Moving Average MySQL?
  22. Case Sensitive collation in MySQL
  23. Can I launch a trigger on select statement in mysql?
  24. Can’t import database through phpmyadmin file size too large
  25. How do you write a case insensitive query for both MySQL and Postgres?
  26. What is the best way to do incremental backups in MySQL?
  27. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  28. WooCommerce: Finding the products in database
  29. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
  30. Optimistic locking in MySQL

Leave a Comment