- 先到mysql官網(wǎng)上下載dmg格式安裝包，進(jìn)行安裝。
- 安裝完后汉嗽，命別名：
vim ~/.bash_profile
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin
- 修改MySQL密碼（版本5.7.x）
通過 –skip-grant-tables的方式啟動(dòng)mysqld_safe 蜈膨，這個(gè)模式可以繞過mysql授權(quán)。
sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
之后進(jìn)入mysql：
sudo /usr/local/mysql/bin/mysql -u root
在mysql.user中以前版本會(huì)有一個(gè)字段password丧叽，但是現(xiàn)在替換成了authentication_string
進(jìn)入mysql之后：
mysql> update mysql.user set authentication_string=PASSWORD('123') where user=’root’;
Query OK, 1 row affected, 1 warning (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql> quit
這時(shí)候Myqsl密碼已經(jīng)修改完了，我們把上面的mysqld進(jìn)程干掉公你，通過正常途徑起Mysqld服務(wù)
mysql -u root -p
mysql>
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>
mysql> set password for root@localhost=password(‘123');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| mysql |
| performance_schema |
| sys |
+——————–+
4 rows in set (0.01 sec)
mysql>
