How do I retrieve my MySQL username and password?

by

Stop the MySQL process.

Start the MySQL process with the –skip-grant-tables option.

Start the MySQL console client with the -u root option.

List all the users;

SELECT * FROM mysql.user;

Reset password;

UPDATE mysql.user SET Password=PASSWORD('[password]') WHERE User="[username]";

But DO NOT FORGET to

Stop the MySQL process

Start the MySQL Process normally (i.e. without the –skip-grant-tables option)

when you are finished. Otherwise, your database’s security could be compromised.

More Related Contents:

  1. Calculate date range between two rows
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. String concatenation in MySQL
  5. MySQL: How to allow remote connection to mysql
  6. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  7. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  8. MySQL error code: 1175 during UPDATE in MySQL Workbench
  9. Cannot connect to Database server (mysql workbench)
  10. How to connect mysql workbench to running mysql inside docker?
  11. MySQL Workbench: How to keep the connection alive
  12. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found
  13. MySQL error 1022 when creating table
  14. Is there a naming convention for MySQL?
  15. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  16. MySQL Errno 150
  17. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  18. error code 1292 incorrect date value mysql
  19. Order by FIELD in MYSQL
  20. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  21. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  22. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  23. mySQL query to search all tables within a database for a string?
  24. Create a new database with MySQL Workbench
  25. Errno 121, duplicate key on write or update?
  26. How should I resolve –secure-file-priv in MySQL?
  27. MySQL server startup error ‘The server quit without updating PID file’
  28. Difference between Key, Primary Key, Unique Key and Index in MySQL
  29. When to use STRAIGHT_JOIN with MySQL
  30. Insert/ Update random date in MySQL

Leave a Comment