JIYIK CN >

This article teaches you how to change the MySQL user password on OS X. rootWe will be using XAMPP so that you can change the password using the MySQL console.

Installing XAMPP for OSX

First, download and install XAMPP for OSX from Apache Friends. After installing XAMPP, use the terminal to access the XAMPP installation directory.

Afterwards, log into MySQL using the following command:

mysql -u root -p

As it stands, rootthe user has no password. As a result, the preceding command will log into MySQL without a password prompt.

But before we change the password, let's make sure rootthere is no password.

Confirm rootUser has no password

To confirm that rootthe user has no password, switch to mysqlthe database with the following command:

USE mysql;

mysqlThe database has many tables, but the one we are interested in is userthe table. userA table has Userand Passwordcolumns.

The latter contains the user's password. Therefore, check the user's password with the following command root:

SELECT User, authentication_string from user;

Output (if rootno password):

+------------------+------------------------------------------------------------------------+
| User             | authentication_string                                                  |
+------------------+------------------------------------------------------------------------+
| debian-sys-maint | $A$005$Wv1MO|Uh1gezb+wKL5oU1hvgAp90tnMa9fTMbPNZtGAFSYC6dgziVVPAd0 |
| mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| root             |                                                                        |
| temp             | $A$005$)e>qXOK0S_d
                                       l(JVnBtaCRN8F8OFHnnWVFxXGM1kRPHMq/1kNQvGZQRiR5 |
+------------------+------------------------------------------------------------------------+
6 rows in set (0.01 sec)

If the root user does not have a password, your output should be the same as above. Now, let's change the password.

Use SQL ALTERstatements to change rootuser passwords

To change roota user's password, you will use a SQL ALTERstatement to assign a new password. Therefore, the following will rootchange the password to DelftStack:

ALTER USER root@localhost IDENTIFIED BY 'DelftStack'

Output:

Query OK, 0 rows affected (0.021 sec)

Now, confirm that rootyou have the password:

SELECT User, authentication_string from user;

Output (your code will be different):

+------+-------------------------------------------+
| User | Password                                  |
+------+-------------------------------------------+
| root | *D064C3894639CE84CBA931173B3A55263B736A7B |
| root |                                           |
| root |                                           |
| pma  |                                           |
+------+-------------------------------------------+
4 rows in set (0.001 sec)

To ensure that the password change takes effect the next time you log in, refresh the permissions:

FLUSH PRIVILEGES;

Log in with your new rootuser password

rootOnce the user has a password, you can log in with:

mysql -u root -p

After executing the previous command, MySQL will ask you to enter your password. If you enter the correct password, you will be logged in; otherwise, you will receive 拒绝访问a message. If this happens, double-check your password and try again.