<span class="line">jacob<span class="variable">@JacobdeMacBook-<span class="constant">Pro<span class="symbol">:~<span class="variable">$ sudo mysqld_safe --skip-grant-tables<br /></span></span></span></span></span>
重新打开一个终端 进入MySQL控制台
<span class="line">1<br /><span class="line">2<br /><span class="line">3<br /><span class="line">4<br /><span class="line">5<br /><span class="line">6<br /><span class="line">7<br /><span class="line">8<br /><span class="line">9<br /><span class="line">10<br /><span class="line">11<br /><span class="line">12<br /></span></span></span></span></span></span></span></span></span></span></span></span> |
<span class="line">jacob@JacobdeMacBook-Pro:~$ mysql -u root<br /><span class="line">Welcome to the MySQ<span class="class">L monitor. Commands end with ;<span class="instruction"> or g.<br /><span class="line">Your MySQL connection id is 3<br /><span class="line">Server version: 5.7.7-rc MySQL Community Server<span class="function"> (GPL<span class="function">)<br /><span class="line"><br /><span class="line">Copyright<span class="function"> (c<span class="function">) 2000, 2015, Oracle<span class="instruction"> and/or its affiliates. All rights reserved.<br /><span class="line"><br /><span class="line">Oracle is a registered trademark of Oracle Corporation<span class="instruction"> and/or its<br /><span class="line">affiliates. Other names may be trademarks of their respective<br /><span class="line">owners.<br /><span class="line"><br /><span class="line">Type ‘help;‘<span class="instruction"> or ‘h‘ for help. Type ‘c‘ to clear the current input statement.<br /></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span> |
提示已经成功进入控制台
修改密码，sql语句
<span class="line">1<br /></span> |
<span class="line">mysql> update mysql.user <span class="built_in">set password=password(<span class="string">‘123456‘) <span class="built_in">where user=<span class="string">‘root‘;<br /></span></span></span></span></span> |
坑爹的地方来了，输入后报如下错误
<span class="line">1<br /></span> |
<span class="line"><span class="type">ERROR <span class="number">1054 (<span class="number">42S22): <span class="type">Unknown column <span class="symbol">‘password‘ <span class="keyword">in <span class="symbol">‘field list‘<br /></span></span></span></span></span></span></span></span> |
神马情况，‘password‘列不存在，这个地方花了好多时间，原因其实很简单啊啊。
MySQL 5.7 版本中 user表中的密码字段列名称变了，从password变成了authentication_string
可以直接看一下user表中的字段
<span class="line">1<br /><span class="line">2<br /></span></span> |
<span class="line">mysql> use mysql<span class="comment">;<br /><span class="line">mysql> desc user<span class="comment">;<br /></span></span></span></span> |
部分字段如下
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| Host | char(60) | NO | PRI | ||
| User | char(16) | NO | PRI | ||
| authentication_string | text | YES | NULL | ||
| password_expired | enum(‘N’,’Y’) | NO | N | ||
| password_last_changed | timestamp | YES | NULL | ||
| password_lifetime | smallint(5) unsigned | YES | NULL |
最后用如下如下语句修改
<span class="line">1<br /><span class="line">2<br /><span class="line">3<br /><span class="line">4<br /><span class="line">5<br /><span class="line">6<br /></span></span></span></span></span></span> |
<span class="line">mysql> update mysql<span class="built_in">.user <span class="built_in">set authentication_string=PASSWORD(<span class="string">‘123456‘) <span class="keyword">where user=<span class="string">‘root‘;<br /><span class="line">Query OK, <span class="number">1 row affected, <span class="number">1 warning (<span class="number">0.00 sec)<br /><span class="line"><span class="keyword">Rows matched: <span class="number">1 Changed: <span class="number">1 Warnings: <span class="number">1<br /><span class="line"><br /><span class="line">mysql> flush privileges;<br /><span class="line">Query OK, <span class="number">0 <span class="keyword">rows affected (<span class="number">0.00 sec)<br /></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span> |
修改成功，再次进入控制台
<span class="line">1<br /></span> |
<span class="line">mysql> show databases<span class="comment">;<br /></span></span> |
这次可以进去了，但是随便执行一条语句依然报错啊
<span class="line">1<br /></span> |
<span class="line">ERROR 1820 (HY000): You must <span class="operator"><span class="keyword">SET <span class="keyword">PASSWORD <span class="keyword">before executing this <span class="keyword">statement<br /></span></span></span></span></span></span> |
按照提示再次设置密码
<span class="line">1<br /><span class="line">2<br /></span></span> |
<span class="line">mysql> set password <span class="keyword">for root<span class="annotation">@localhost=password(<span class="string">‘12345‘);<br /><span class="line">Query OK, <span class="number">0 rows affected, <span class="number">1 <span class="keyword">warning (<span class="number">0.00 sec)<br /></span></span></span></span></span></span></span></span></span> |
便捷设置
为方便使用 MySQL
<code>cd /etc sudo chmod +w bashrc sudo vi bashrc #在bashrc最后添加下面两行 alias mysql=‘/usr/local/mysql/bin/mysql‘ alias mysqladmin=‘/usr/local/mysql/bin/mysqladmin‘ <br /></code>
Mac EI 10.11.3 MySQL5.7.11 .dmg 安装(便捷设置,密码重置,卸载)
标签：
本文系统来源：http://www.cnblogs.com/W-Kr/p/5522711.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！