blocks|key|263391|text|当您登录到MySQL终端时，尝试命令FLUSH+PRIVILEGES。如果这不起作用，那么在MySQL终端中尝试执行以下命令集|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|263392|$+mysql+-u+root
mysql>+USE+mysql;
mysql>+UPDATE+user+SET+password=PASSWORD("NEWPASSWORD")+WHERE+User='root';
mysql>+FLUSH+PRIVILEGES;
mysql>+quit|code-block|syntax|javascript|263393|将NEWPASSWORD更改为您想要的任何密码。应该都设置好了！|263394|更新：从MySQL+5.7开始，password字段已重命名为authentication_string。更改密码时，请使用以下查询更改密码。所有其他命令保持不变：|BOLD|263395|mysql>+UPDATE+user+SET+authentication_string=PASSWORD("NEWPASSWORD")+WHERE+User='root';|263396|更新口令:在8.0.15+(可能在该版本之前)上，()函数不起作用，如下面的评论所述。你必须使用：|263397|UPDATE+mysql.user+SET+authentication_string='password'+WHERE+User='root';|263398|entityMap^0|I|G|0|0|0|0|2|G|8|V|L|0|0|0|P|0|0|21|0^^$0|@$1|2|3|4|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|10|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|11|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|12|8|@$9|13|A|14|B|O]|$9|15|A|16|B|C]|$9|17|A|18|B|C]]|D|@]|E|$]]|$1|P|3|Q|5|H|7|19|8|@]|D|@]|E|$I|J]]|$1|R|3|S|5|6|7|1A|8|@$9|1B|A|1C|B|O]]|D|@]|E|$]]|$1|T|3|U|5|6|7|1D|8|@$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|V|3|-4|5|6|7|1G|8|@]|D|@]|E|$]]]|W|$]]

Try the command <code>FLUSH PRIVILEGES</code> when you log into the MySQL terminal. If that doesn't work, try the following set of commands while in the MySQL terminal

<pre><code>$ mysql -u root
mysql&gt; USE mysql;
mysql&gt; UPDATE user SET password=PASSWORD("NEWPASSWORD") WHERE User='root';
mysql&gt; FLUSH PRIVILEGES;
mysql&gt; quit
</code></pre>

Change out NEWPASSWORD with whatever password you want. Should be all set!

Update: As of MySQL 5.7, the <code>password</code> field has been renamed <code>authentication_string</code>. When changing the password, use the following query to change the password. All other commands remain the same:

<pre><code>mysql&gt; UPDATE user SET authentication_string=PASSWORD("NEWPASSWORD") WHERE User='root';
</code></pre>

Update: On 8.0.15 (maybe already before that version) the PASSWORD() function does not work, as mentioned in the comments below. You have to use:

<code>UPDATE mysql.user SET authentication_string='password' WHERE User='root';</code>

blocks|key|3169937|text|一旦您安装了MySQL，您将需要建立“根”密码。如果您没有建立root密码，那么就没有root密码，并且您不需要密码即可登录。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3169938|因此，也就是说，您需要建立一个root密码。|3169939|使用终端输入以下内容：|3169940|安装:设置root用户密码：|3169941|/usr/local/mysql/bin/mysqladmin+-u+root+password+NEW_PASSWORD_HERE|code-block|syntax|javascript|3169942|如果您犯了错误，或者需要更改root密码，请使用以下命令：|3169943|更改超级用户密码：|3169944|cd+/usr/local/mysql/bin/
./mysql+-u+root+-p
>+Enter+password:+[type+old+password+invisibly]

use+mysql;
update+user+set+password=PASSWORD("NEW_PASSWORD_HERE")+where+User='root';
flush+privileges;
quit|3169945|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|X|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|J|7|11|8|@]|9|@]|A|$K|L]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

Once you've installed MySQL, you'll need to establish the "root" password. If you don't establish a root password, then, well, there is no root password, and you don't need a password to log in.

So, that being said, you need to establish a root password.

Using terminal enter the following:

<h2>Installation: Set root user password:</h2>

<pre><code>/usr/local/mysql/bin/mysqladmin -u root password NEW_PASSWORD_HERE
</code></pre>

If you've made a mistake, or need to change the root password use the following:

<h2>Change root password:</h2>

<pre><code>cd /usr/local/mysql/bin/
./mysql -u root -p
&gt; Enter password: [type old password invisibly]

use mysql;
update user set password=PASSWORD("NEW_PASSWORD_HERE") where User='root';
flush privileges;
quit
</code></pre>

blocks|key|2955922|text|如果您不记得为root设置的密码，需要重置密码，请执行以下步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2955923|2955924|停止mysqld服务器，这一点因安装而异|ordered-list-item|2955925|在安全模式下使用特权绕过|2955926|运行服务器|2955927|sudo+mysqld_safe+--skip-grant-tables;|offset|length|style|CODE|2955928|在新窗口中的|2955929|连接到数据库，设置新密码并刷新权限并退出：|2955930|2955931|mysql+-u+root|2955932|对于早于MySQL+5.7的MySQL，请使用：|2955933|UPDATE+mysql.user+SET+Password=PASSWORD('your-password')+WHERE+User='root';|2955934|对于MySQL+5.7%2B使用：|2955935|USE+mysql;|2955936|UPDATE+mysql.user+SET+authentication_string=PASSWORD("your-password")+WHERE+User='root';|2955937|刷新并退出：|2955938|FLUSH+PRIVILEGES;|2955939|\q|2955940|2955941|停止安全模式服务器，然后重新启动常规服务器。新密码现在应该可以工作了。对我来说很有吸引力:)|2955942|2955943|entityMap^0|0|0|0|0|0|0|11|0|0|0|0|0|D|0|0|0|23|0|0|0|A|0|0|2G|0|0|0|H|0|0|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1K|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|1L|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1M|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1N|8|@$L|1O|M|1P|N|O]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|R|3|S|5|E|7|1R|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1T|8|@$L|1U|M|1V|N|O]]|9|@]|A|$]]|$1|W|3|X|5|6|7|1W|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1X|8|@$L|1Y|M|1Z|N|O]]|9|@]|A|$]]|$1|10|3|11|5|6|7|20|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|21|8|@$L|22|M|23|N|O]]|9|@]|A|$]]|$1|14|3|15|5|6|7|24|8|@$L|25|M|26|N|O]]|9|@]|A|$]]|$1|16|3|17|5|6|7|27|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|28|8|@$L|29|M|2A|N|O]]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|2B|8|@$L|2C|M|2D|N|O]]|9|@]|A|$]]|$1|1C|3|-4|5|6|7|2E|8|@]|9|@]|A|$]]|$1|1D|3|1E|5|E|7|2F|8|@]|9|@]|A|$]]|$1|1F|3|-4|5|6|7|2G|8|@]|9|@]|A|$]]|$1|1G|3|-4|5|6|7|2H|8|@]|9|@]|A|$]]]|1H|$]]

If you don't remember the password you set for root and need to reset it, follow these steps:

<ol>
<li>Stop the mysqld server, this varies per install</li>
<li>Run the server in safe mode with privilege bypass</li>
</ol>

<code>sudo mysqld_safe --skip-grant-tables;</code>

<ol start="3">
<li>In a new window connect to the database, set a new password and flush the permissions &amp; quit:</li>
</ol>

<code>mysql -u root</code>

For MySQL older than MySQL 5.7 use:

<code>UPDATE mysql.user SET Password=PASSWORD('your-password') WHERE User='root';</code>

For MySQL 5.7+ use:

<code>USE mysql;</code>

<code>UPDATE mysql.user SET authentication_string=PASSWORD("your-password") WHERE User='root';</code>

Refresh and quit:

<code>FLUSH PRIVILEGES;</code>

<code>\q</code>

<ol start="4">
<li>Stop the safe mode server and start your regular server back. The new password should work now. Worked like a charm for me :)</li>
</ol>

blocks|key|265065|text|当我安装OS+X+Yosemite时，我遇到了Mysql的问题。我尝试了很多方法，但都不管用。实际上，我找到了一种非常简单的方法。试试这个。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|265066|265067|首先使用su权限登录终端。|ordered-list-item|265068|265069|sudo+su|offset|length|style|CODE|265070|265071|停止mysql|265072|265073|sudo+/usr/local/mysql/support-files/mysql.server+stop|265074|在安全模式下启动|265075|：|265076|265077|sudo+mysqld_safe+--skip-grant-tables|265078|265079|打开另一个终端，以su权限登录，不使用密码|265080|登录mysql|265081|mysql+-u+root|265082|265083|更改|265084|的密码|265085|UPDATE+mysql.user+SET+Password=PASSWORD('new_password')+WHERE+User='root';|265086|265087|刷新权限|265088|265089|FLUSH+PRIVILEGES;|265090|265091|You+are+done+now|265092|265093|entityMap^0|0|0|0|0|0|7|0|0|0|0|0|1H|0|0|0|0|0|10|0|0|0|0|0|D|0|0|0|0|0|22|0|0|0|0|0|H|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1P|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1R|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1T|8|@$I|1U|J|1V|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|1X|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1Z|8|@$I|20|J|21|K|L]]|9|@]|A|$]]|$1|S|3|T|5|6|7|22|8|@]|9|@]|A|$]]|$1|U|3|V|5|E|7|23|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|24|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|25|8|@$I|26|J|27|K|L]]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|28|8|@]|9|@]|A|$]]|$1|10|3|11|5|E|7|29|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|2A|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|2B|8|@$I|2C|J|2D|K|L]]|9|@]|A|$]]|$1|16|3|-4|5|6|7|2E|8|@]|9|@]|A|$]]|$1|17|3|18|5|E|7|2F|8|@]|9|@]|A|$]]|$1|19|3|1A|5|6|7|2G|8|@]|9|@]|A|$]]|$1|1B|3|1C|5|6|7|2H|8|@$I|2I|J|2J|K|L]]|9|@]|A|$]]|$1|1D|3|-4|5|6|7|2K|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|E|7|2L|8|@]|9|@]|A|$]]|$1|1G|3|-4|5|6|7|2M|8|@]|9|@]|A|$]]|$1|1H|3|1I|5|6|7|2N|8|@$I|2O|J|2P|K|L]]|9|@]|A|$]]|$1|1J|3|-4|5|6|7|2Q|8|@]|9|@]|A|$]]|$1|1K|3|1L|5|E|7|2R|8|@]|9|@]|A|$]]|$1|1M|3|-4|5|6|7|2S|8|@]|9|@]|A|$]]|$1|1N|3|-4|5|6|7|2T|8|@]|9|@]|A|$]]]|1O|$]]

When I installed OS X Yosemite,I got problem with Mysql. I tried lot of methods but none worked. I actually found a quite easy way. Try this out.

<ol>
<li>First log in terminal from su privileges.</li>
</ol>

<code>sudo su</code>

<ol start="2">
<li>stop mysql</li>
</ol>

<code>sudo /usr/local/mysql/support-files/mysql.server stop</code>

<ol start="3">
<li>start in safe mode:</li>
</ol>

<code>sudo mysqld_safe --skip-grant-tables</code>

<ol start="4">
<li>open another terminal, log in as su privileges than, log in mysql without password</li>
</ol>

<code>mysql -u root</code>

<ol start="5">
<li>change the password</li>
</ol>

<code>UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root';</code>

<ol start="6">
<li>flush privileges</li>
</ol>

<code>FLUSH PRIVILEGES;</code>

<ol start="7">
<li>You are done now</li>
</ol>

blocks|key|2955992|text|如果您忘记了MySQL超级用户密码，则无法记住或想要进入…。。您可以在Linux或OS+X中从命令行重置mysql数据库密码，前提是您知道所在计算机的root用户密码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2955993|(1)停止MySQL|2955994|sudo+/usr/local/mysql/support-files/mysql.server+stop|code-block|syntax|javascript|2955995|(2)以安全模式启动：|2955996|sudo+mysqld_safe+--skip-grant-tables|2955997|(3)这将是一个持续的命令，直到该过程完成为止。因此，打开另一个外壳/终端窗口，不使用密码登录：|2955998|mysql+-u+root

UPDATE+mysql.user+SET+Password=PASSWORD('password')+WHERE+User='root';|2955999|在上面的更新命令中，只需将'+password‘替换为您自己的新密码，请确保保留引号|2956000|(4)节俭而宁静|2956001|FLUSH+PRIVILEGES;

\q|2956002|(5)启动MySQL|2956003|sudo+/usr/local/mysql/support-files/mysql.server+start|2956004|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|15|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|16|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|17|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|18|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|19|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1A|8|@]|9|@]|A|$]]|$1|U|3|V|5|F|7|1B|8|@]|9|@]|A|$G|H]]|$1|W|3|X|5|6|7|1C|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1D|8|@]|9|@]|A|$G|H]]|$1|10|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|11|$]]

If you have forgot the MySQL root password, can’t remember or want to break in….. you can reset the mysql database password from the command line in either Linux or OS X as long as you know the root user password of the box you are on:

(1) Stop MySQL

<pre><code>sudo /usr/local/mysql/support-files/mysql.server stop
</code></pre>

(2) Start it in safe mode:

<pre><code>sudo mysqld_safe --skip-grant-tables
</code></pre>

(3) This will be an ongoing command until the process is finished so open another shell/terminal window, log in without a password:

<pre><code>mysql -u root

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
</code></pre>

In the UPDATE command above just replace the 'password' with your own new password, make sure to keep the quotation marks

(4) Save and quite

<pre><code>FLUSH PRIVILEGES;

\q
</code></pre>

(5) Start MySQL

<pre><code>sudo /usr/local/mysql/support-files/mysql.server start
</code></pre>

blocks|key|265095|text|在终端中，编写mysql+-u+root+-p并按回车键。输入您必须记下的当前mysql密码。并设置口令SET+PASSWORD+=+PASSWORD('new_password');|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|265096|有关更多详细信息，请参阅此文档here。|265097|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.6/en/alter-user.html^0|7|G|1G|14|0|F|4|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@]|D|@$9|V|A|W|1|X]]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

In the terminal, write <code>mysql -u root -p</code>and hit Return.
Enter the current mysql password that you must have noted down.
And set the password
<code>SET PASSWORD = PASSWORD('new_password');</code> 

Please refer to this documentation <a href="https://dev.mysql.com/doc/refman/5.6/en/alter-user.html" rel="noreferrer">here</a> for more details.

blocks|key|265099|text|mysql网站提供的说明比上面提到的更清楚|type|unstyled|depth|inlineStyleRanges|entityRanges|data|265100|265101|$+sudo+/usr/local/mysql/support-files/mysql.server+stop|ordered-list-item|offset|length|style|CODE|265102|$+sudo+/usr/local/mysql/support-files/mysql.server+start+--skip-grant-tables|265103|/usr/local/mysql/bin/mysql|265104|mysql>+FLUSH+PRIVILEGES;|265105|mysql>+ALTER+USER‘'MyNewPass';|265106|mysql>’@‘localhost’(由根主机或Ctrl+%2Bz标识的根用户)刷新新密码，即MyNewPass|265107|265108|参考：http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html|265109|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html^0|0|0|0|1J|0|0|24|0|0|Q|0|0|0|0|0|3|1T|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|16|8|@$F|17|G|18|H|I]]|9|@]|A|$]]|$1|J|3|K|5|E|7|19|8|@$F|1A|G|1B|H|I]]|9|@]|A|$]]|$1|L|3|M|5|E|7|1C|8|@$F|1D|G|1E|H|I]]|9|@]|A|$]]|$1|N|3|O|5|E|7|1F|8|@]|9|@]|A|$]]|$1|P|3|Q|5|E|7|1G|8|@]|9|@]|A|$]]|$1|R|3|S|5|E|7|1H|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1J|8|@]|9|@$F|1K|G|1L|1|1M]]|A|$]]|$1|W|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

The instructions provided in the mysql website is so clear, than the above mentioned

<ol>
<li><code>$ sudo /usr/local/mysql/support-files/mysql.server stop</code></li>
<li><code>$ sudo /usr/local/mysql/support-files/mysql.server start --skip-grant-tables</code></li>
<li><code>/usr/local/mysql/bin/mysql</code></li>
<li>mysql> FLUSH PRIVILEGES;</li>
<li>mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';</li>
<li>mysql> <code>exit</code> or Ctrl + z </li>
<li><code>$ sudo /usr/local/mysql/support-files/mysql.server stop</code></li>
<li><code>$ sudo /usr/local/mysql/support-files/mysql.server start</code></li>
<li><code>/usr/local/mysql/support-files/mysql -u root -p</code></li>
<li>Enter the new password i.e MyNewPass</li>
</ol>

Reference: <a href="http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html</a>

blocks|key|261114|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|261115|停止mysqld服务器。|ordered-list-item|261116|261117|-+**Mac+OSX:**+`System+Preferences`+>+`MySQL`+>+`Stop+MySQL+Server`
-+**Linux+(From+Terminal):**+`sudo+systemctl+stop+mysqld.service`|code-block|syntax|javascript|261118|​|261119|261120|使用特权绕过|261121|在安全模式下启动服务器|261122|-+**From+Terminal:**+`sudo+/usr/local/mysql/bin/mysqld_safe+--skip-grant-tables`|261123|261124|新终端窗口中的|offset|length|style|BOLD|261125|：|261126|261127|-+`sudo+/usr/local/mysql/bin/mysql+-u+root`|261128|261129|261130|这将打开mysql命令行。从这里进入：|261131|261132|-+`UPDATE+mysql.user+SET+authentication_string=PASSWORD('NewPassword')+WHERE+User='root';`
-+`FLUSH+PRIVILEGES;`
-+`quit`|261133|261134|261135|再次停止mysqld服务器，然后以正常模式重新启动它。|261136|261137|-+**Mac+OSX+(From+Terminal):**+`sudo+/usr/local/mysql/support-files/mysql.server+restart`
-+**Linux+Terminal:**+`sudo+systemctl+restart+mysqld`|261138|261139|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|1L|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|1M|7|@]|8|@]|9|$]]|$1|D|3|-4|4|5|6|1N|7|@]|8|@]|9|$]]|$1|E|3|F|4|G|6|1O|7|@]|8|@]|9|$H|I]]|$1|J|3|K|4|5|6|1P|7|@]|8|@]|9|$]]|$1|L|3|-4|4|5|6|1Q|7|@]|8|@]|9|$]]|$1|M|3|N|4|C|6|1R|7|@]|8|@]|9|$]]|$1|O|3|P|4|5|6|1S|7|@]|8|@]|9|$]]|$1|Q|3|R|4|G|6|1T|7|@]|8|@]|9|$H|I]]|$1|S|3|K|4|5|6|1U|7|@]|8|@]|9|$]]|$1|T|3|U|4|5|6|1V|7|@$V|1W|W|1X|X|Y]]|8|@]|9|$]]|$1|Z|3|10|4|C|6|1Y|7|@]|8|@]|9|$]]|$1|11|3|-4|4|5|6|1Z|7|@]|8|@]|9|$]]|$1|12|3|13|4|G|6|20|7|@]|8|@]|9|$H|I]]|$1|14|3|K|4|5|6|21|7|@]|8|@]|9|$]]|$1|15|3|-4|4|5|6|22|7|@]|8|@]|9|$]]|$1|16|3|17|4|C|6|23|7|@]|8|@]|9|$]]|$1|18|3|-4|4|5|6|24|7|@]|8|@]|9|$]]|$1|19|3|1A|4|G|6|25|7|@]|8|@]|9|$H|I]]|$1|1B|3|K|4|5|6|26|7|@]|8|@]|9|$]]|$1|1C|3|-4|4|5|6|27|7|@]|8|@]|9|$]]|$1|1D|3|1E|4|C|6|28|7|@]|8|@]|9|$]]|$1|1F|3|-4|4|5|6|29|7|@]|8|@]|9|$]]|$1|1G|3|1H|4|G|6|2A|7|@]|8|@]|9|$H|I]]|$1|1I|3|K|4|5|6|2B|7|@]|8|@]|9|$]]|$1|1J|3|-4|4|5|6|2C|7|@]|8|@]|9|$]]]|1K|$]]

<ol>
<li>Stop the mysqld server.

<ul>
<li>Mac OSX: <code>System Preferences</code> > <code>MySQL</code> > <code>Stop MySQL Server</code></li>
<li>Linux (From Terminal): <code>sudo systemctl stop mysqld.service</code></li>
</ul></li>
<li>Start the server in safe mode with privilege bypass

<ul>
<li>From Terminal: <code>sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables</code></li>
</ul></li>
<li>In a new terminal window:

<ul>
<li><code>sudo /usr/local/mysql/bin/mysql -u root</code></li>
</ul></li>
<li>This will open the mysql command line. From here enter:

<ul>
<li><code>UPDATE mysql.user SET authentication_string=PASSWORD('NewPassword') WHERE User='root';</code></li>
<li><code>FLUSH PRIVILEGES;</code></li>
<li><code>quit</code></li>
</ul></li>
<li>Stop the mysqld server again and restart it in normal mode.

<ul>
<li>Mac OSX (From Terminal): <code>sudo /usr/local/mysql/support-files/mysql.server restart</code></li>
<li>Linux Terminal: <code>sudo systemctl restart mysqld</code></li>
</ul></li>
</ol>

blocks|key|2956034|text|对于新的MySQL5.7，由于某种原因，Mysql的bin命令没有附加到shell上，您必须这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2956035|2956036|在安装后重新启动Mac。|ordered-list-item|2956037|2956038|2956039|启动Mysql：|2956040|2956041|系统首选项>+Mysql+>开始按钮|2956042|2956043|进入终端的Mysql安装文件夹：|2956044|2956045|$+cd+/usr/local/mysql/bin/|offset|length|style|CODE|2956046|2956047|访问Mysql：|2956048|2956049|$+./mysql+-u+root+-p|2956050|并输入为安装提供的初始密码。|2956051|2956052|在Mysql终端修改密码：|2956053|2956054|mysql>+ALTER+USER+'root'@'localhost'+IDENTIFIED+BY+'MyNewPassword';|2956055|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|Q|0|0|0|0|0|K|0|0|0|0|0|0|1V|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1E|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|1H|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1J|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|1L|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1N|8|@$S|1O|T|1P|U|V]]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|X|3|Y|5|E|7|1R|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1T|8|@$S|1U|T|1V|U|V]]|9|@]|A|$]]|$1|12|3|13|5|6|7|1W|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]|$1|15|3|16|5|E|7|1Y|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|20|8|@$S|21|T|22|U|V]]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|23|8|@]|9|@]|A|$]]]|1B|$]]

For the new Mysql 5.7, for some reason the bin commands of Mysql aren't attached to the shell, you have to do:
<ol>
<li>Restart the Mac after the installation.
</li>
<li>Start Mysql:
System Preferences &gt; Mysql &gt; Start button
</li>
<li>Go to Mysql install folder in the terminal:
<code>$ cd /usr/local/mysql/bin/</code>
</li>
<li>Access to Mysql:
<code>$ ./mysql -u root -p</code>
</li>
</ol>
and enter the initial password given to the installation.
<ol start="4">
<li>In Mysql terminal change password:
<code>mysql&gt; ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPassword';</code>
</li>
</ol>

blocks|key|3170064|text|如果您忘记了密码或想要将其更改为您的mysql：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3170065|3170066|启动终端并输入：|ordered-list-item|3170067|3170068|3170069|+sudo+su|blockquote|3170070|3170071|3170072|3170073|Enter+pass+for+you+system|3170074|停止您的mysql:|3170075|3170076|3170077|+sudo+/usr/local/mysql/support-files/mysql.server停止|3170078|3170079|3170080|3170081|保持此窗口打开，运行第二个终端窗口并进入此处：|3170082|3170083|3170084|+mysql+-u根目录|3170085|3170086|3170087|3170088|并更改您的mysql密码：|3170089|3170090|3170091|+UPDATE+User+SET+User+authentication_string=PASSWORD('new_password')+=‘mysql.user’；|3170092|3170093|3170094|"new_password“-你的新通行证。您不需要mysql的旧pass。|3170095|3170096|刷新，退出并检查您的新通行证：|3170097|3170098|3170099|刷新权限；|3170100|3170101|3170102|3170103|关闭所有窗口并检查您的mysql新通行证。祝你好运。|3170104|3170105|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1Y|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|20|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|21|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|22|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|23|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|24|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|25|8|@]|9|@]|A|$]]|$1|P|3|Q|5|E|7|26|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|27|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|28|8|@]|9|@]|A|$]]|$1|T|3|U|5|J|7|29|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|2A|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|2B|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|2C|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|E|7|2D|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|2E|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|2F|8|@]|9|@]|A|$]]|$1|12|3|13|5|J|7|2G|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|2H|8|@]|9|@]|A|$]]|$1|15|3|-4|5|6|7|2I|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|2J|8|@]|9|@]|A|$]]|$1|17|3|18|5|E|7|2K|8|@]|9|@]|A|$]]|$1|19|3|-4|5|6|7|2L|8|@]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|2M|8|@]|9|@]|A|$]]|$1|1B|3|1C|5|J|7|2N|8|@]|9|@]|A|$]]|$1|1D|3|-4|5|6|7|2O|8|@]|9|@]|A|$]]|$1|1E|3|-4|5|6|7|2P|8|@]|9|@]|A|$]]|$1|1F|3|1G|5|6|7|2Q|8|@]|9|@]|A|$]]|$1|1H|3|-4|5|6|7|2R|8|@]|9|@]|A|$]]|$1|1I|3|1J|5|E|7|2S|8|@]|9|@]|A|$]]|$1|1K|3|-4|5|6|7|2T|8|@]|9|@]|A|$]]|$1|1L|3|-4|5|6|7|2U|8|@]|9|@]|A|$]]|$1|1M|3|1N|5|J|7|2V|8|@]|9|@]|A|$]]|$1|1O|3|-4|5|6|7|2W|8|@]|9|@]|A|$]]|$1|1P|3|-4|5|6|7|2X|8|@]|9|@]|A|$]]|$1|1Q|3|-4|5|6|7|2Y|8|@]|9|@]|A|$]]|$1|1R|3|1S|5|E|7|2Z|8|@]|9|@]|A|$]]|$1|1T|3|-4|5|6|7|30|8|@]|9|@]|A|$]]|$1|1U|3|-4|5|6|7|31|8|@]|9|@]|A|$]]]|1V|$]]

If you forgot your password or want to change it to your mysql:

<ol>
<li>start your terminal and enter:</li>
</ol>

<blockquote>
<pre><code>sudo su
</code></pre>
</blockquote>

<ol start="2">
<li>Enter pass for you system</li>
<li>Stop your mysql:</li>
</ol>

<blockquote>
<pre><code>sudo /usr/local/mysql/support-files/mysql.server stop
</code></pre>
</blockquote>

<ol start="4">
<li>Leave this window OPEN, run second terminal window and enter here:</li>
</ol>

<blockquote>
<pre><code>mysql -u root
</code></pre>
</blockquote>

<ol start="5">
<li>And change your password for mysql:</li>
</ol>

<blockquote>
<pre><code>UPDATE mysql.user SET authentication_string=PASSWORD('new_password') WHERE User='root';
</code></pre>
</blockquote>

where "new_password" - your new pass. You don't need old pass for mysql.

<ol start="6">
<li>Flush, quit and check your new pass:</li>
</ol>

<blockquote>
<pre><code>FLUSH PRIVILEGES;
</code></pre>
</blockquote>

<ol start="7">
<li>Close all windows and check your new pass for mysql.
Good luck.</li>
</ol>

blocks|key|2956106|text|如果你不记得你的密码，除了我用的set+up+MySQL+using+brew，@radtek's+answer对我很有效，这意味着他的答案中的第一步和第二步必须改为：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2956107|2956108|/usr/local/bin/mysql.server+stop|ordered-list-item|style|CODE|2956109|/usr/local/bin/mysqld_safe+--skip-grant-tables|2956110|2956111|注意：+sudo的缺失。|BOLD|2956112|entityMap|0|LINK|mutability|MUTABLE|url|https://gist.github.com/nrollr/3f57fc15ded7dddddcc4e82fe137b58e|1|https://stackoverflow.com/a/22851247/5274109^0|G|N|0|14|G|1|0|0|0|W|0|0|1A|0|0|4|8|4|4|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]|$A|13|B|14|1|15]]|C|$]]|$1|D|3|-4|5|6|7|16|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|17|8|@$A|18|B|19|H|I]]|9|@]|C|$]]|$1|J|3|K|5|G|7|1A|8|@$A|1B|B|1C|H|I]]|9|@]|C|$]]|$1|L|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|1E|8|@$A|1F|B|1G|H|O]|$A|1H|B|1I|H|I]]|9|@]|C|$]]|$1|P|3|-4|5|6|7|1J|8|@]|9|@]|C|$]]]|Q|$R|$5|S|T|U|C|$V|W]]|X|$5|S|T|U|C|$V|Y]]]]

If you can't remember your password, <a href="https://stackoverflow.com/a/22851247/5274109">@radtek's answer</a> worked for me except in my case I had <a href="https://gist.github.com/nrollr/3f57fc15ded7dddddcc4e82fe137b58e" rel="nofollow noreferrer">set up MySQL using brew</a> which meant that steps 1 and 2 of his answer had to be changed to:

<ol>
<li><code>/usr/local/bin/mysql.server stop</code></li>
<li><code>/usr/local/bin/mysqld_safe --skip-grant-tables</code></li>
</ol>

Note: the lack of <code>sudo</code>.

blocks|key|265149|text|停止MySQL服务器|type|unstyled|depth|inlineStyleRanges|entityRanges|data|265150|sudo+/usr/local/mysql/support-files/mysql.server+stop|offset|length|style|CODE|265151|在安全模式下启动MySQL|265152|sudo+/usr/local/mysql/bin/mysqld_safe+--skip-grant-tables+&|265153|更改root密码|265154|/usr/local/mysql/bin/mysql+-u+root|265155|use+mysql;
UPDATE+user+SET+authentication_string=PASSWORD('NEW_PASSWORD')+WHERE+user='root';
FLUSH+PRIVILEGES;
exit|code-block|syntax|javascript|265156|测试|265157|运行/usr/local/mysql/bin/mysql+-u+root|265158|现在输入新密码以开始使用MySQL。|265159|entityMap^0|0|0|1H|0|0|0|1N|0|0|0|Y|0|0|0|2|Y|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@$D|14|E|15|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|16|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|17|8|@$D|18|E|19|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1A|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1B|8|@$D|1C|E|1D|F|G]]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1E|8|@]|9|@]|A|$S|T]]|$1|U|3|V|5|6|7|1F|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1G|8|@$D|1H|E|1I|F|G]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1J|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|11|$]]

<h2>Stopping MySQL Server</h2>

<code>sudo /usr/local/mysql/support-files/mysql.server stop</code>

<h2>Starting MySQL in safe mode</h2>

<code>sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables &amp;</code>

<h2>Changing the root password</h2>

<code>/usr/local/mysql/bin/mysql -u root</code>

<pre><code>use mysql;
UPDATE user SET authentication_string=PASSWORD('NEW_PASSWORD') WHERE user='root';
FLUSH PRIVILEGES;
exit
</code></pre>

<h2>Testing</h2>

Run <code>/usr/local/mysql/bin/mysql -u root</code>

Now enter the new password to start using MySQL.

blocks|key|2956118|text|这就是对我有效的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2956119|2956120|确保没有其他MySQL进程是running.To检查，请执行以下操作：|ordered-list-item|2956121|2956122|删除终端，运行以下命令:+lsof+-i:3306如果返回任何PID，请使用a.From+-9+PID终止它b.转到系统首选项>+MySQL+>检查是否有MySQL实例正在运行，停止它们。|2956123|使用以下命令启动MySQL：|unordered-list-item|2956124|2956125|sudo+/usr/local/mysql/bin/mysqld_safe每个用户的--skip-grant-tables|2956126|The密码分别存储在mysql.user表的user和authentication_string列下。我们可以将该表更新为：|2956127|2956128|更新用户SET+authentication_string='your_password‘where+mysql.user+=’root‘|2956129|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|X|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|Z|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|10|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|12|8|@]|9|@]|A|$]]|$1|O|3|P|5|K|7|13|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|15|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|U|$]]

This is what exactly worked for me:

<ol>
<li>Make sure no other MySQL process is running.To check this do the 
following:

<pre><code> a.From the terminal, run this command:
 lsof -i:3306 
 If any PID is returned, kill it using kill -9 PID
 b. Go To System Preferences &gt; MySQL &gt; check if any MySQL instances 
 are running, stop them.
</code></pre></li>
<li>Start MySQL with the command:

<pre><code>sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
</code></pre></li>
<li>The password for every user is stored in the mysql.user table under 
columns User and authentication_string respectively. We can update the 
table as:

<pre><code>UPDATE mysql.user SET authentication_string='your_password' where User='root'
</code></pre></li>
</ol>

blocks|key|263497|text|MySQL+8有很多变化。我发现MySQL+8.0+"How+to+Reset+the+Root+Password"+documentation的以下修改可以在Mac上运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|263498|使用SQL创建临时文件$HOME/mysql.root.txt以更新超级用户密码：|style|CODE|263499|ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'<new-password>';|263500|这使用了mysql_native_password来避免Authentication+plugin+'caching_sha2_password'+cannot+be+loaded错误，如果我省略了这个选项，我就会得到这个错误。|263501|停止服务器，使用--init-file选项启动以设置超级用户密码，然后重新启动服务器：|263502|+`mysql.server+stop+++++mysql.server+start+--init-file=$HOME/mysql.root.txt+++++mysql.server+stop+++++mysql.server+start`|code-block|syntax|javascript|263503|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html|1|https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded^0|G|1K|0|0|B|K|0|0|2G|0|4|L|S|1Q|1|0|8|B|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|D|3|E|5|6|7|16|8|@$A|17|B|18|F|G]]|9|@]|C|$]]|$1|H|3|I|5|6|7|19|8|@$A|1A|B|1B|F|G]]|9|@]|C|$]]|$1|J|3|K|5|6|7|1C|8|@$A|1D|B|1E|F|G]]|9|@$A|1F|B|1G|1|1H]]|C|$]]|$1|L|3|M|5|6|7|1I|8|@$A|1J|B|1K|F|G]]|9|@]|C|$]]|$1|N|3|O|5|P|7|1L|8|@]|9|@]|C|$Q|R]]|$1|S|3|-4|5|6|7|1M|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]|10|$5|V|W|X|C|$Y|11]]]]

Much has changed for MySQL 8. I've found the following modification of the <a href="https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html" rel="nofollow noreferrer">MySQL 8.0 "How to Reset the Root Password" documentation</a> works with Mac OS X.

Create a temp file <code>$HOME/mysql.root.txt</code> with the SQL to update the root password:

<code>
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '&lt;new-password&gt;';
</code>

This uses <code>mysql_native_password</code> to avoid the <a href="https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded">Authentication plugin 'caching_sha2_password' cannot be loaded</a> error, which I get if I omit the option.

Stop the server, start with an <code>--init-file</code> option to set the root password, then restart the server:

<code>
 mysql.server stop
 mysql.server start --init-file=$HOME/mysql.root.txt
 mysql.server stop
 mysql.server start
</code>

blocks|key|266738|text|现有答案中提到的方法不适用于mysql+5.7.6或更高版本。根据mysql文档，这是推荐的方式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|266739|B.5.3.2.3重置超级用户密码:通用说明|offset|length|style|BOLD|266740|MySQL+5.7.6及更高版本：|266741|mysql>+ALTER+USER+'root'@'localhost'+IDENTIFIED+BY+'MyNewPass';|CODE|266742|参考：https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html|266743|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html^0|0|0|M|0|0|0|1R|0|3|1U|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|11|8|@$D|12|E|13|F|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|14|8|@]|9|@$D|15|E|16|1|17]]|A|$]]|$1|O|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

The methods mentioned in existing answers don't work for mysql 5.7.6 or later. According mysql documentation this is the recommended way.

B.5.3.2.3 Resetting the Root Password: Generic Instructions

MySQL 5.7.6 and later:

<code>mysql&gt; ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';</code>

Reference: <a href="https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html" rel="noreferrer">https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html</a>

blocks|key|261182|text|我认为这应该行得通：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|261183|ALTER+USER+'root'@'localhost'+IDENTIFIED+BY+'YOURNEWPASSWORD'|code-block|syntax|javascript|261184|(请注意，如果不是root，您可能应该将root替换为您的用户名)|261185|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I think this should work : 

<pre><code>ALTER USER 'root'@'localhost' IDENTIFIED BY 'YOURNEWPASSWORD'
</code></pre>

(Note that you should probably replace root with your username if it isn't root)

blocks|key|263508|text|macOS+10.14%2B+5.7.26是从macOS安装程序安装的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|263509|尝试使用其他用户发布的UPDATE命令时，会导致以下错误：|263510|错误1820+(HY000)：在执行此语句之前，必须使用ALTER+USER语句重置密码。|263511|复制安装程序打开的终端显示给您的密码，然后执行以下操作：|263512|mysql+-uroot+-p
ALTER+USER+'root'@'localhost'+IDENTIFIED+BY+'YOURPASSWORDHERE';|code-block|syntax|javascript|263513|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|R|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

macOS 10.14+ with 5.7.26 installed from Mac OSX DMG installer.

When attempting to use the UPDATE command posted by other users results in the following error:

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Copy the password that was presented to you by the Installer open terminal and do the following:

<pre><code>mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'YOURPASSWORDHERE';
</code></pre>

blocks|key|2956157|text|mysqld_safe+--skip-grant-tables
mysql+-u+root
UPDATE+mysql.user+SET+authentication_string='yourpasswd'+WHERE+User='root';
FLUSH+PRIVILEGES;
ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+caching_sha2_password+BY+'yourpasswd';|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2956158|不知怎么的，每次我的Macbook重启时，我都需要这样做。张贴这篇文章供个人参考，希望对其他人也有帮助。|unstyled|2956159|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>mysqld_safe --skip-grant-tables
mysql -u root
UPDATE mysql.user SET authentication_string='yourpasswd' WHERE User='root';
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';
</code></pre>

I somehow need to do this every time my Macbook restarts. Posting this for personal reference, hopefully it helps someone else as well.

blocks|key|2956161|text|在终端中尝试一下：/usr/local/bin/mysql_secure_installation|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2956162|entityMap^0|9|14|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Try this in terminal : 
<code>/usr/local/bin/mysql_secure_installation</code>

blocks|key|261204|text|让我们添加这个在我的笔记本电脑上工作的变通方法！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|261205|采用Osx+Mojave+10.14.5的Mac|261206|Mysql+8.0.17与自制软件一起安装|261207|261208|我运行以下命令来定位mysql的路径|unordered-list-item|261209|261210|brew+info+mysql|offset|length|style|CODE|261211|Once路径是已知的，我运行以下命令：|261212|261213|/usr/local/Cellar/mysql/8.0.17/bin/mysqld_safe+--skip-grant-table|261214|In我运行的另一个终端：|261215|261216|对该终端执行mysql+-u+root|261217|Inside操作时，我使用以下命令更改了超级用户密码：|261218|261219|update+mysql.user+set+authentication_string='NewPassword'+where+user='root';|261220|and要完成，我运行：|261221|261222|FLUSH+PRIVILEGES;|261223|瞧，密码被重置了。|261224|References+:|261225|entityMap|0|LINK|mutability|MUTABLE|url|https://gist.github.com/zubaer-ahammed/c81c9a0e37adc1cb9a6cdc61c4190f52^0|0|0|0|0|0|0|0|F|0|0|0|0|1T|0|0|0|6|D|0|0|0|0|24|0|0|0|0|H|0|0|0|C|0|0^^$0|@$1|2|3|4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1O|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|1Q|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1S|8|@$M|1T|N|1U|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|I|7|1V|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1X|8|@$M|1Y|N|1Z|O|P]]|9|@]|A|$]]|$1|V|3|W|5|I|7|20|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|21|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|22|8|@$M|23|N|24|O|P]]|9|@]|A|$]]|$1|10|3|11|5|I|7|25|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|26|8|@]|9|@]|A|$]]|$1|13|3|14|5|6|7|27|8|@$M|28|N|29|O|P]]|9|@]|A|$]]|$1|15|3|16|5|I|7|2A|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|2B|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|2C|8|@$M|2D|N|2E|O|P]]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|2F|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|2G|8|@]|9|@$M|2H|N|2I|1|2J]]|A|$]]|$1|1E|3|-4|5|6|7|2K|8|@]|9|@]|A|$]]]|1F|$1G|$5|1H|1I|1J|A|$1K|1L]]]]

Let us add this workaround that works on my laptop!

Mac with Osx Mojave 10.14.5

Mysql 8.0.17 was installed with homebrew

<ul>
<li>I run the following command to locate the path of mysql

<code>brew info mysql</code></li>
<li>Once the path is known, I run this :

<code>/usr/local/Cellar/mysql/8.0.17/bin/mysqld_safe --skip-grant-table</code></li>
<li>In another terminal I run :

<code>mysql -u root</code></li>
<li>Inside that terminal, I changed the root password using :

<code>update mysql.user set authentication_string='NewPassword' where user='root';</code></li>
<li>and to finish I run :

<code>FLUSH PRIVILEGES;</code></li>
</ul>

And voila the password was reset.

<a href="https://gist.github.com/zubaer-ahammed/c81c9a0e37adc1cb9a6cdc61c4190f52" rel="nofollow noreferrer">References :</a>

blocks|key|266753|text|要引用MySQL+8.0.15+%2B，密码()函数不可用。使用下面的命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|266754|请善意使用|266755|UPDATE+mysql.user+SET+authentication_string='password'+WHERE+User='root';|code-block|syntax|javascript|266756|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

To reference MySQL 8.0.15 + , the password() function is not available. Use the command below.

Kindly use 

<pre><code>UPDATE mysql.user SET authentication_string='password' WHERE User='root';
</code></pre>

blocks|key|265181|text|你可以在苹果电脑上手动关闭mysql，方法是点击苹果菜单并打开系统偏好设置。选择“MySQL”首选项面板，然后单击“停止MySQL服务器”按钮停止MySQL服务器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|265182|在停止mysql之后，您需要遵循以下步骤。|265183|265184|你需要在跳过授权表模式下启动mysql+|unordered-list-item|265185|265186|265187|+$+sudo+/usr/local/mysql/support-files/mysql.server+start+--跳过授权表|blockquote|265188|265189|265190|265191|在终端本身中，输入此命令以刷新现有权限|265192|265193|265194|+/usr/local/mysql/bin/mysql+mysql>刷新权限；|265195|265196|265197|265198|现在您需要更改用户密码|265199|265200|265201|+mysql>更改由‘newpassword’标识的用户'root'@'localhost‘；|265202|265203|mysql>退出|265204|265205|然后你可以进入苹果菜单，打开系统偏好设置。选择“MySQL”首选项面板，然后单击“停止MySQL服务器”按钮停止MySQL服务器。|265206|最后，你可以再次进入苹果菜单，打开系统偏好设置。选择“MySQL”首选项面板，然后单击“启动MySQL服务器”按钮启动MySQL服务器。|265207|希望这能有所帮助|265208|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1H|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|1J|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1M|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]|$1|P|3|Q|5|G|7|1Q|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|T|3|U|5|L|7|1T|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1V|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|G|7|1X|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|12|3|13|5|L|7|20|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|21|8|@]|9|@]|A|$]]|$1|15|3|16|5|6|7|22|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|23|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|24|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|25|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|26|8|@]|9|@]|A|$]]|$1|1E|3|-4|5|6|7|27|8|@]|9|@]|A|$]]]|1F|$]]

You can manually turn-off mysql on Mac, by clicking on  Apple menu and open System Preferences. Choose the “MySQL” preference panel, then click on the “Stop MySQL Server” button to stop MySQL Server on Mac.

After you stop your mysql you'll need to follow these steps.

<ul>
<li>You'll need to start mysql in skip-grant-tables mode</li>
</ul>

<blockquote>
 $ sudo /usr/local/mysql/support-files/mysql.server start --skip-grant-tables 
</blockquote>

<ul>
<li>In your terminal itself, enter this command to FLUSH existing PRIVILEGES</li>
</ul>

<blockquote>
 /usr/local/mysql/bin/mysql mysql> FLUSH PRIVILEGES; 
</blockquote>

<ul>
<li>Now you need to alter the user password</li>
</ul>

<blockquote>
 mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword'; 
 
 mysql> exit 
</blockquote>

Then you can go to  Apple menu and open System Preferences. Choose the “MySQL” preference panel, then click on the “Stop MySQL Server” button to stop MySQL Server on Mac.

Finally you can again go to  Apple menu and open System Preferences. Choose the “MySQL” preference panel, then click on the “Start MySQL Server” button to start MySQL Server on Mac.

Hope that helps

blocks|key|3170255|text|之前的评论都没有解决我Mac上的问题。我使用了下面的命令，它起作用了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3170256|$+brew+services+stop+mysql
$+pkill+mysqld
$+rm+-rf+/usr/local/var/mysql/+#+NOTE:+this+will+delete+your+existing+database!!!
$+brew+postinstall+mysql
$+brew+services+restart+mysql
$+mysql+-u+root|code-block|syntax|javascript|3170257|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

None of the previous comments solve the issue on my Mac.
I used the commands below and it worked. 

<pre><code>$ brew services stop mysql
$ pkill mysqld
$ rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!!
$ brew postinstall mysql
$ brew services restart mysql
$ mysql -u root
</code></pre>

blocks|key|261258|text|我通过以下方式解决了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|261259|mysql.server+stop|offset|length|style|CODE|261260|Running服务器关闭我的服务器：mysqld_safe+--skip-grant-tables|unordered-list-item|261261|
|261262|In+|261263|+in+safe+mode：mysqld_safe+--skip-grant-tables|ordered-list-item|261264|In另一个终端，使用mysql+-u+root|261265|In登录同一个终端，运行UPDATE+mysql.user+SET+authentication_string=null+WHERE+User='root';，然后运行FLUSH+PRIVILEGES;，然后使用exit;|261266|Stop退出带有mysql.server+stop的安全模式服务器，然后启动正常的服务器；mysql.server+start|261267|261268|261269|现在，您可以使用以下命令设置新密码|261270|ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+caching_sha2_password+BY+'yourpasswd';|code-block|syntax|javascript|261271|entityMap^0|0|0|H|0|I|V|0|0|0|E|V|0|A|D|0|C|1V|2C|H|2Y|5|0|8|H|19|I|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@$D|1A|E|1B|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1C|8|@$D|1D|E|1E|F|G]]|9|@]|A|$]]|$1|K|3|L|5|6|7|1F|8|@]|9|@]|A|$]]|$1|M|3|N|5|J|7|1G|8|@]|9|@]|A|$]]|$1|O|3|P|5|Q|7|1H|8|@$D|1I|E|1J|F|G]]|9|@]|A|$]]|$1|R|3|S|5|Q|7|1K|8|@$D|1L|E|1M|F|G]]|9|@]|A|$]]|$1|T|3|U|5|Q|7|1N|8|@$D|1O|E|1P|F|G]|$D|1Q|E|1R|F|G]|$D|1S|E|1T|F|G]]|9|@]|A|$]]|$1|V|3|W|5|Q|7|1U|8|@$D|1V|E|1W|F|G]|$D|1X|E|1Y|F|G]]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|20|8|@]|9|@]|A|$]]|$1|Z|3|10|5|6|7|21|8|@]|9|@]|A|$]]|$1|11|3|12|5|13|7|22|8|@]|9|@]|A|$14|15]]|$1|16|3|-4|5|6|7|23|8|@]|9|@]|A|$]]]|17|$]]

I solved this by:
<ol>
<li>Shutting down my MySQL server: <code>mysql.server stop</code></li>
<li>Running MySQL in safe mode: <code>mysqld_safe --skip-grant-tables</code></li>
<li>In another terminal, login with <code>mysql -u root</code></li>
<li>In the same terminal, run <code>UPDATE mysql.user SET authentication_string=null WHERE User='root';</code>, then <code>FLUSH PRIVILEGES; </code> and then exit with <code>exit;</code></li>
<li>Stop the safe mode server with <code>mysql.server stop</code> and then start the normal one; <code>mysql.server start</code></li>
</ol>
Now you can set your new password with
<pre><code>ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';
</code></pre>

I just installed MySQL on Mac OS X. The next step was setting the root user password, so I did this next:

<ol>
<li>Launch the terminal app to access the Unix command line.</li>
<li>Under the Unix prompt I executed these commands:

<pre><code>$ cd /usr/local/mysql/bin
$ ./mysqladmin -u root password 'password'
</code></pre></li>
</ol>

But, when I execute the command

<code>$ ./mysql -u root</code>, this is the answer:

<pre><code>Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 224
Server version: 5.5.13 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql&gt;
</code></pre>

I can get into the <code>mysql</code> command line without any password!

Why is this?

Setting the MySQL root user password on OS X

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我刚刚在Mac上安装了MySQL。下一步是设置根用户密码，所以我接下来这样做：启动终端应用程序以访问Unix命令行。在Unix提示符下执行以下命令：$ cd /usr/local/mysql/bin $ ./mysqladmin -u根密码' password '但是，当我执行以下命令时$ ./mysql -u roo...

问在OS X上设置MySQL根用户密码
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在OS X上设置MySQL根用户密码EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在OS X上设置MySQL根用户密码
EN