Mysql password expired. Can’t connect

by

So I finally found the solution myself.

Firstly I went into terminal and typed:

mysql -u root -p

This asked for my current password which I typed in and it gave me access to provide more mysql commands. Anything I tried from here gave this error:

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

This is confusing because I couldn’t actually see a way of resetting the password using ALTER USER statement, but I did find another simple solution:

SET PASSWORD = PASSWORD('xxxxxxxx');

More Related Contents:

  1. CakePHP Database connection “Mysql” is missing, or could not be created
  2. PHP PDO and Mysql [closed]
  3. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  4. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  5. strange character encoding of stored data , old script is showing them fine new one doesn’t
  6. How to loop through a mysql result set
  7. MySQL/PHP Error:[2002] Only one usage of each socket address (protocol/network address/port) is normally permitted
  8. How to use multiple databases dynamically for one model in CakePHP
  9. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  10. Laravel 5.5 Error Base table or view already exists: 1050 Table ‘users’ already exists
  11. PDOException “could not find driver” in php
  12. Error while using PDO prepared statements and LIMIT in query [duplicate]
  13. PDO prepared statement fetch() returning double results
  14. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  15. How do I get database column names in Laravel?
  16. Select mySQL based only on month and year
  17. Mysql InnoDB engine in Laravel
  18. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  19. Update query PHP MySQL [duplicate]
  20. Do I have to use mysql_real_escape_string if I bind parameters?
  21. how to execute mysql command DELIMITER
  22. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  23. How to get a list of databases?
  24. PDO and MySQL ‘between’
  25. MySQL: Group by two columns and sum
  26. PHP add up two time variables
  27. SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’
  28. How to sort MYSQL fulltext search results by relevancy
  29. Which MySQL datatype to use for an IP address? [duplicate]
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment