更改root账户密码
http://blog.youkuaiyun.com/maijunjin/article/details/22283265
cd /usr/local/mysql-5.7.11-osx10.9-x86_64/bin
1)尝试以下方法修改密码,但是报错,说密码过期
./mysqladmin -u root -p 'oldpass' password ‘newpass'
参考:
http://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
2)然后按照以下方法修改成功
mysql> ALTER USER USER() IDENTIFIED BY 'newpass';
Query OK, 0 rows affected (0.01 sec)
参考:
http://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html
http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
http://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
3) 验证数据库状态正常
mysql> select 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
特别注意:
登录后的每句命令,结尾要符号 ; 可以enter换行,结尾写这个符号结束
mysql> select
-> 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)