Setting the MySQL root user password on OS X

Question

I just installed MySQL on Mac OS X   The next step was setting the root user password  so I did this next    Launch the terminal app to access the Unix command line  Under the Unix prompt I executed these commands     cd  usr local mysql bin     mysqladmin -u root password  password     But  when I execute the command      mysql -u root  this is the answer   Welcome to the MySQL monitor   Commands end with   or  g  Your MySQL connection id is 224 Server version  5 5 13 MySQL Community Server  GPL   Copyright  c  2000  2010  Oracle and or its affiliates  All rights reserved   Oracle is a registered trademark of Oracle Corporation and or its affiliates  Other names may be trademarks of their respective owners   Type  help   or   h  for help  Type   c  to clear the current input statement   mysql gt    I can get into the mysql command line without any password   Why is this

User · Answer

Let us add this workaround that works on my laptop!

Mac with Osx Mojave 10.14.5

Mysql 8.0.17 was installed with homebrew

I run the following command to locate the path of mysql

brew info mysql
Once the path is known, I run this :

/usr/local/Cellar/mysql/8.0.17/bin/mysqld_safe --skip-grant-table
In another terminal I run :

mysql -u root
Inside that terminal, I changed the root password using :

update mysql.user set authentication_string='NewPassword' where user='root';
and to finish I run :

FLUSH PRIVILEGES;

And voila the password was reset.

References :

User · Answer

mysqld safe --skip-grant-tables mysql -u root UPDATE mysql user SET authentication string  yourpasswd  WHERE User  root   FLUSH PRIVILEGES  ALTER USER  root   localhost  IDENTIFIED WITH caching sha2 password BY  yourpasswd     I somehow need to do this every time my Macbook restarts  Posting this for personal reference  hopefully it helps someone else as well

User · Answer

Much has changed for MySQL 8  I ve found the following modification of the MySQL 8 0  How to Reset the Root Password  documentation works with Mac OS X   Create a temp file  HOME mysql root txt with the SQL to update the root password    ALTER USER  root   localhost  IDENTIFIED WITH mysql native password BY   lt new-password gt      This uses mysql native password to avoid the Authentication plugin  caching sha2 password  cannot be loaded error  which I get if I omit the option   Stop the server  start with an --init-file option to set the root password  then restart the server        mysql server stop     mysql server start --init-file  HOME mysql root txt     mysql server stop     mysql server start

User · Answer

In the terminal  write mysql -u root -pand hit Return  Enter the current mysql password that you must have noted down  And set the password SET PASSWORD   PASSWORD  new password      Please refer to this documentation here for more details

User · Answer

To reference MySQL 8 0 15     the password   function is not available  Use the command below   Kindly use   UPDATE mysql user SET authentication string  password  WHERE User  root

User · Answer

macOS 10 14  with 5 7 26 installed from Mac OSX DMG installer   When attempting to use the UPDATE command posted by other users results in the following error   ERROR 1820  HY000   You must reset your password using ALTER USER statement before executing this statement   Copy the password that was presented to you by the Installer open terminal and do the following   mysql -uroot -p ALTER USER  root   localhost  IDENTIFIED BY  YOURPASSWORDHERE

User · Answer

If you forgot your password or want to change it to your mysql    start your terminal and enter     sudo su     Enter pass for you system Stop your mysql     sudo  usr local mysql support-files mysql server stop     Leave this window OPEN  run second terminal window and enter here     mysql -u root     And change your password for mysql     UPDATE mysql user SET authentication string PASSWORD  new password   WHERE User  root      where  new password  - your new pass  You don t need old pass for mysql    Flush  quit and check your new pass     FLUSH PRIVILEGES      Close all windows and check your new pass for mysql  Good luck

User · Answer

The instructions provided in the mysql website is so clear  than the above mentioned     sudo  usr local mysql support-files mysql server stop   sudo  usr local mysql support-files mysql server start --skip-grant-tables  usr local mysql bin mysql mysql  FLUSH PRIVILEGES  mysql  ALTER USER  root   localhost  IDENTIFIED BY  MyNewPass   mysql  exit or Ctrl   z    sudo  usr local mysql support-files mysql server stop   sudo  usr local mysql support-files mysql server start  usr local mysql support-files mysql -u root -p Enter the new password i e MyNewPass   Reference  http   dev mysql com doc refman 5 7 en resetting-permissions html

User · Answer

None of the previous comments solve the issue on my Mac  I used the commands below and it worked      brew services stop mysql   pkill mysqld   rm -rf  usr local var mysql    NOTE  this will delete your existing database      brew postinstall mysql   brew services restart mysql   mysql -u root

User · Answer

If you can t remember your password   radtek s answer worked for me except in my case I had set up MySQL using brew which meant that steps 1 and 2 of his answer had to be changed to     usr local bin mysql server stop  usr local bin mysqld safe --skip-grant-tables   Note  the lack of sudo

User · Answer

I solved this by   Shutting down my MySQL server  mysql server stop Running MySQL in safe mode  mysqld safe --skip-grant-tables In another terminal  login with mysql -u root In the same terminal  run UPDATE mysql user SET authentication string null WHERE User  root    then FLUSH PRIVILEGES   and then exit with exit  Stop the safe mode server with mysql server stop and then start the normal one  mysql server start  Now you can set your new password with ALTER USER  root   localhost  IDENTIFIED WITH caching sha2 password BY  yourpasswd

User · Answer

Try this in terminal     usr local bin mysql secure installation

User · Answer

If you don t remember the password you set for root and need to reset it  follow these steps    Stop the mysqld server  this varies per install Run the server in safe mode with privilege bypass   sudo mysqld safe --skip-grant-tables    In a new window connect to the database  set a new password and flush the permissions  amp  quit    mysql -u root  For MySQL older than MySQL 5 7 use   UPDATE mysql user SET Password PASSWORD  your-password   WHERE User  root    For MySQL 5 7  use   USE mysql   UPDATE mysql user SET authentication string PASSWORD  your-password   WHERE User  root    Refresh and quit   FLUSH PRIVILEGES    q   Stop the safe mode server and start your regular server back  The new password should work now  Worked like a charm for me

User · Answer

The methods mentioned in existing answers don t work for mysql 5 7 6 or later  According mysql documentation this is the recommended way   B 5 3 2 3 Resetting the Root Password  Generic Instructions  MySQL 5 7 6 and later   mysql gt  ALTER USER  root   localhost  IDENTIFIED BY  MyNewPass    Reference  https   dev mysql com doc refman 5 7 en resetting-permissions html

User · Answer

You can manually turn-off mysql on Mac  by clicking on   Apple menu and open System Preferences  Choose the    MySQL    preference panel  then click on the    Stop MySQL Server    button to stop MySQL Server on Mac   After you stop your mysql you ll need to follow these steps    You ll need to start mysql in skip-grant-tables mode        sudo  usr local mysql support-files mysql server start --skip-grant-tables     In your terminal itself  enter this command to FLUSH existing PRIVILEGES       usr local mysql bin mysql mysql  FLUSH PRIVILEGES      Now you need to alter the user password      mysql  ALTER USER  root   localhost  IDENTIFIED BY  newpassword         mysql  exit    Then you can go to   Apple menu and open System Preferences  Choose the    MySQL    preference panel  then click on the    Stop MySQL Server    button to stop MySQL Server on Mac   Finally you can again go to   Apple menu and open System Preferences  Choose the    MySQL    preference panel  then click on the    Start MySQL Server    button to start MySQL Server on Mac   Hope that helps

User · Answer

Stop the mysqld server    Mac OSX  System Preferences   MySQL   Stop MySQL Server Linux  From Terminal   sudo systemctl stop mysqld service  Start the server in safe mode with privilege bypass   From Terminal  sudo  usr local mysql bin mysqld safe --skip-grant-tables  In a new terminal window    sudo  usr local mysql bin mysql -u root  This will open the mysql command line  From here enter    UPDATE mysql user SET authentication string PASSWORD  NewPassword   WHERE User  root   FLUSH PRIVILEGES  quit  Stop the mysqld server again and restart it in normal mode    Mac OSX  From Terminal   sudo  usr local mysql support-files mysql server restart Linux Terminal  sudo systemctl restart mysqld

User · Answer

I think this should work     ALTER USER  root   localhost  IDENTIFIED BY  YOURNEWPASSWORD     Note that you should probably replace root with your username if it isn t root

User · Answer

If you have forgot the MySQL root password  can   t remember or want to break in      you can reset the mysql database password from the command line in either Linux or OS X as long as you know the root user password of the box you are on    1  Stop MySQL  sudo  usr local mysql support-files mysql server stop    2  Start it in safe mode   sudo mysqld safe --skip-grant-tables    3  This will be an ongoing command until the process is finished so open another shell terminal window  log in without a password   mysql -u root  UPDATE mysql user SET Password PASSWORD  password   WHERE User  root     In the UPDATE command above just replace the  password  with your own new password  make sure to keep the quotation marks   4  Save and quite  FLUSH PRIVILEGES    q    5  Start MySQL  sudo  usr local mysql support-files mysql server start

User · Answer

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 gt  USE mysql  mysql gt  UPDATE user SET password PASSWORD  NEWPASSWORD   WHERE User  root   mysql gt  FLUSH PRIVILEGES  mysql gt  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 gt  UPDATE user SET authentication string PASSWORD  NEWPASSWORD   WHERE User  root     Update  On 8 0 15  maybe already before that version  the PASSWORD   function does not work  as mentioned in the comments below  You have to use   UPDATE mysql user SET authentication string  password  WHERE User  root

User · Answer

This is what exactly worked for me    Make sure no other MySQL process is running To check this do the  following    a From the terminal  run this command         lsof -i 3306     If any PID is returned  kill it using kill -9 PID  b  Go To System Preferences  gt  MySQL  gt  check if any MySQL instances      are running  stop them   Start MySQL with the command   sudo  usr local mysql bin mysqld safe --skip-grant-tables  The password for every user is stored in the mysql user table under  columns User and authentication string respectively  We can update the  table as   UPDATE mysql user SET authentication string  your password  where User  root

User · Answer

For new Mysql 5 7 for some reason bin commands of Mysql not attached to the shell    Restart the Mac after install  Start Mysql   System Preferences   Mysql   Start button Go to Mysql install folder in terminal     cd  usr local mysql bin  Access to Mysql       mysql -u root -p   and enter the initial password given to the installation    In Mysql terminal change password   mysql gt  ALTER USER  root   localhost  IDENTIFIED BY  MyNewPassword

User · Answer

Once you ve installed MySQL  you ll need to establish the  root  password  If you don t establish a root password  then  well  there is no root password  and you don t need a password to log in   So  that being said  you need to establish a root password   Using terminal enter the following   Installation  Set root user password    usr local mysql bin mysqladmin -u root password NEW PASSWORD HERE   If you ve made a mistake  or need to change the root password use the following   Change root password   cd  usr local mysql bin    mysql -u root -p  gt  Enter password   type old password invisibly   use mysql  update user set password PASSWORD  NEW PASSWORD HERE   where User  root   flush privileges  quit

User · Answer

Stopping MySQL Server  sudo  usr local mysql support-files mysql server stop  Starting MySQL in safe mode  sudo  usr local mysql bin mysqld safe --skip-grant-tables  amp   Changing the root password   usr local mysql bin mysql -u root  use mysql  UPDATE user SET authentication string PASSWORD  NEW PASSWORD   WHERE user  root   FLUSH PRIVILEGES  exit   Testing  Run  usr local mysql bin mysql -u root  Now enter the new password to start using MySQL

User · Answer

When I installed OS X Yosemite I got problem with Mysql  I tried lot of methods but none worked   I actually found a quite easy way  Try this out    First log in terminal from su privileges    sudo su   stop mysql   sudo  usr local mysql support-files mysql server stop   start in safe mode    sudo mysqld safe --skip-grant-tables   open another terminal  log in as su privileges than  log in mysql without password   mysql -u root   change the password   UPDATE mysql user SET Password PASSWORD  new password   WHERE User  root     flush privileges   FLUSH PRIVILEGES    You are done now

[mysql] Setting the MySQL root user password on OS X

Examples related to mysql

Examples related to macos

Examples related to passwords