Setting the MySQL root user password on OS X

by

Try the command FLUSH PRIVILEGES when you log into the MySQL terminal. If that doesn’t work, try the following set of commands while in the MySQL terminal

mysql -u root

mysql> USE mysql;
mysql> UPDATE user SET password=PASSWORD("NEWPASSWORD") WHERE User="root";
mysql> FLUSH PRIVILEGES;
mysql> quit

Change out NEWPASSWORD with whatever password you want. Should be all set!

Update: As of MySQL 5.7, the password field has been renamed authentication_string. When changing the password, use the following query to change the password. All other commands remain the same:

mysql> UPDATE user SET authentication_string=PASSWORD("NEWPASSWORD") WHERE User="root";

for MySQL 8.0+ Don’t use

mysql> UPDATE mysql.user SET authentication_string='password' WHERE User="root";

as it overwrites the authentication_string, which is supposed to be a hash and not plain text, instead use:

mysql> `ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';`

More Related Contents:

  1. MySQL user DB does not have password columns – Installing MySQL on OSX
  2. What data type to use for hashed password field and what length?
  3. Location of my.cnf file on macOS
  4. brew install mysql on macOS
  5. MySQL – ERROR 1045 – Access denied
  6. How do you uninstall MySQL from Mac OS X?
  7. Restoring deleted ‘root’ user and password for MySQL
  8. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  9. Resetting ROOT password in MySQL 5.6
  10. Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
  11. MySQL Install: ERROR: Failed to build gem native extension
  12. mysql root password forgotten
  13. MySQL password function
  14. How to reset the root password in MySQL 8.0.11?
  15. libmysqlclient15-dev on macs?
  16. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  17. Connect to Docker MySQL container from localhost?
  18. How to change the mysql root password
  19. How do you stop MySQL on a Mac OS install?
  20. Reset MySQL root password using ALTER USER statement after install on Mac
  21. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  22. PID error on mysql.server start?
  23. How to start MySQL server from command line on Mac OS Lion?
  24. How to auto-load MySQL on startup on OS X Yosemite / El Capitan
  25. OSX ld: library not found for -lssl
  26. How to get back Lost phpMyAdmin Password, XAMPP
  27. MySQL data directory location
  28. MySQL: Quick breakdown of the types of joins [duplicate]
  29. SELECT query return 1 row from each group
  30. Xampp-mysql – “Table doesn’t exist in engine” #1932

Leave a Comment