MAC MySQL Change password

If you know the password:

mysqladmin-u root-p Password New password

MySQL Database password forgotten:

1. In System Preferences, abort the MySQL service.;

2. Cd/usr/local/mysql-...../bin

sudo./mysqld_safe--skip-grant-tables

3. Log in to MySQL;

Mysql

4. The password of the root user;

mysql> Update mysql.user set password= ' whereuser= ' root ';
mysql> flush Privileges;
Mysql> quit

5. Restart the MySQL service,

6. Add password mysql> mysqladmin-u root-p password 123 password change to 123

MAC MySQL Change password