blocks|key|4457376|text|如果您使用mysql+-u+root+-p启动mysql|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4457377|试试ALTER+USER+'root'@'localhost'+IDENTIFIED+BY+'MyNewPass';|4457378|来源：http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html|4457379|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html^0|5|G|0|2|1K|0|3|1T|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|X|8|@]|D|@$9|Y|A|Z|1|10]]|E|$]]|$1|J|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

If you started mysql using <code>mysql -u root -p</code>

Try <code>ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';</code>

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

blocks|key|4457292|text|我在Mac上也有同样的问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457293|首先，使用沙盒模式登录mysql|4457294|mysql+-u+<user>+-p+--connect-expired-password|code-block|syntax|javascript|4457295|然后，设置密码|4457296|SET+PASSWORD+FOR+'root'@'localhost'+=+PASSWORD('XXXX');

Query+OK,+0+rows+affected,+1+warning+(0.01+sec)|4457297|这对我很有效~|4457298|途径：https://dba.stackexchange.com/questions/118852/your-paswssword-has-expired-after-restart-mysql-when-updated-mysql-5-7-8-rcde|offset|length|4457299|entityMap|0|LINK|mutability|MUTABLE|url|https://dba.stackexchange.com/questions/118852/your-paswssword-has-expired-after-restart-mysql-when-updated-mysql-5-7-8-rcde^0|0|0|0|0|0|0|3|3G|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|13|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|15|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|16|8|@]|9|@$Q|17|R|18|1|19]]|A|$]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

I have same problem on Mac

First, log in mysql with sandbox mode

<pre><code>mysql -u &lt;user&gt; -p --connect-expired-password
</code></pre>

Then, set password

<pre><code>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('XXXX');

Query OK, 0 rows affected, 1 warning (0.01 sec)
</code></pre>

It works for me ~

via: <a href="https://dba.stackexchange.com/questions/118852/your-paswssword-has-expired-after-restart-mysql-when-updated-mysql-5-7-8-rcde">https://dba.stackexchange.com/questions/118852/your-paswssword-has-expired-after-restart-mysql-when-updated-mysql-5-7-8-rcde</a>

blocks|key|4457502|text|如果您使用的是MySQL+5.7.6及更高版本：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457503|ALTER+USER+'root'@'localhost'+IDENTIFIED+BY+'MyNewPass';|code-block|syntax|javascript|4457504|如果您使用的是MySQL+5.7.5及更早版本：|4457505|SET+PASSWORD+FOR+'root'@'localhost'+=+PASSWORD('MyNewPass');|4457506|MySQL+Documentation|offset|length|4457507|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html^0|0|0|0|0|0|J|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@]|9|@$M|11|N|12|1|13]]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

If you use MySQL 5.7.6 and later:

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

If you use MySQL 5.7.5 and earlier:

<pre><code>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
</code></pre>

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

blocks|key|4457582|text|在MySQL+5.7.x上，您需要切换到本地密码才能进行更改，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457583|ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'test';|code-block|syntax|javascript|4457584|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|$]]

On MySQL 5.7.x you need to switch to native password to be able to change it, like:

<pre><code>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test';
</code></pre>

blocks|key|4457261|text|运行以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457262|$+cd+/usr/local/mysql/bin
$+./mysqladmin+-u+root+password+'password'|code-block|syntax|javascript|4457263|然后运行|4457264|./mysql+-u+root|4457265|它应该会登录。现在运行FLUSH特权；|4457266|然后退出MySQL控制台并尝试登录。如果这不起作用，请运行以下命令：|4457267|$+mysql+-u+root
mysql>+USE+mysql;
mysql>+UPDATE+user+SET+authentication_string=PASSWORD("XXXXXXX")+WHERE+User='root';
mysql>+FLUSH+PRIVILEGES;
mysql>+quit|4457268|将xxxxxx更改为您的新密码。然后再次尝试登录。|4457269|更新。查看此http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html|offset|length|4457270|它应该能解决你的问题。|4457271|如果您使用的是oracle，请尝试以下内容|4457272|ALTER+USER+username+IDENTIFIED+BY+password|4457273|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html^0|0|0|0|0|0|0|0|0|6|1T|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1C|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1D|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|1E|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1F|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|1G|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|1H|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1I|8|@]|9|@$U|1J|V|1K|1|1L]]|A|$]]|$1|W|3|X|5|6|7|1M|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1N|8|@]|9|@]|A|$]]|$1|10|3|11|5|D|7|1O|8|@]|9|@]|A|$E|F]]|$1|12|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]]|13|$14|$5|15|16|17|A|$18|19]]]]

Run these:

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

Then run

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

It should log in. Now run
 FLUSH privileges;

Then exit the MySQL console and try logging in. If that doesn't work run these:

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

Change xxxxxx to ur new password. Then try logging in again.

Update.
See this <a href="http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html">http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html</a>

It should solve your problem. 

If you are on oracle try this

<pre><code>ALTER USER username IDENTIFIED BY password
</code></pre>

blocks|key|4457736|text|UPDATE+user+SET+authentication_string=PASSWORD("MyPassWord")+WHERE+User='root'；错误1064+(42000)：您的SQL语法有错误；请查看与您的MySQL服务器版本对应的手册，了解正确的语法，以便在第1行使用near+'("MyPassWord")+WHERE+User='root'‘|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457737|已解决|4457738|ALTER+USER+'root'@'localhost'+IDENTIFIED+BY+'MyNewPass';|code-block|syntax|javascript|4457739|参考资料来自下面的站点|4457740|https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html|offset|length|4457741|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|1U|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|X|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Y|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|Z|8|@]|9|@$M|10|N|11|1|12]]|A|$]]|$1|O|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|L]]]]

UPDATE user SET authentication_string=PASSWORD("MyPassWord") WHERE User='root';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '("MyPassWord") WHERE User='root'' at line 1

Resolved with

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

Reference from below site

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

blocks|key|4457240|text|也许可以试试这个？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457241|SET+PASSWORD+FOR+'root'@'localhost'+=+PASSWORD('XXX');|code-block|syntax|javascript|4457242|或|4457243|SET+PASSWORD+FOR+'root'@'%25'+=+PASSWORD('XXX');|4457244|这取决于您使用的访问方式。|4457245|(并且不确定您是否应该更改自己的字段名称...)|4457246|https://dev.mysql.com/doc/refman/5.0/en/set-password.html|offset|length|4457247|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|0|0|1L|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|11|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|13|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|14|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|15|8|@]|9|@$Q|16|R|17|1|18]]|A|$]]|$1|S|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|P]]]]

Maybe try that ?

<pre><code>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('XXX');
</code></pre>

or 

<pre><code>SET PASSWORD FOR 'root'@'%' = PASSWORD('XXX');
</code></pre>

Depending on which access you use.

(and not sure you should change yourself field names...)

<a href="https://dev.mysql.com/doc/refman/5.0/en/set-password.html" rel="noreferrer">https://dev.mysql.com/doc/refman/5.0/en/set-password.html</a>

blocks|key|4457540|text|更改由‘new_password’标识的用户'root'@'localhost‘；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457541|使用这行代码...|4457542|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

Use this line...

blocks|key|4457771|text|这就是我的工作方式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457772|mysql>+show+databases+;|offset|length|style|CODE|4457773|错误1820+(HY000)：在执行此语句之前，必须使用ALTER+USER语句重置密码。|4457774|mysql>+uninstall+plugin+validate_password;|4457775|错误1820+(HY000)：在执行此语句之前，必须使用ALTER+USER语句重置密码。|4457776|mysql>+alter+user+'root'@'localhost'+identified+by+'root';|4457777|查询正常，0行受影响(0.01秒)|4457778|mysql>+flush+privileges;|4457779|查询正常，0行受影响(0.03秒)|4457780|entityMap^0|0|7|G|0|0|7|Z|0|0|7|1F|0|0|7|H|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@$D|Z|E|10|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|12|8|@$D|13|E|14|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|15|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|16|8|@$D|17|E|18|F|G]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|19|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1A|8|@$D|1B|E|1C|F|G]]|9|@]|A|$]]|$1|T|3|U|5|6|7|1D|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|W|$]]

Here is the way works for me. 

mysql> <code>show databases ;</code>

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

mysql> <code>uninstall plugin validate_password;</code>

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

mysql> <code>alter user 'root'@'localhost' identified by 'root';</code>

Query OK, 0 rows affected (0.01 sec)

mysql> <code>flush privileges;</code>

Query OK, 0 rows affected (0.03 sec)

blocks|key|4457795|text|在5.7版本。“密码”字段已被删除。'authentication_string‘替换它|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457796|use+mysql;
update+user+set+authentication_string=password('123456')+where+user='root';
flush+privileges;|code-block|syntax|javascript|4457797|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|$]]

in 5.7 version. 'password' field has been deleted. 'authentication_string' replace it

<pre><code>use mysql;
update user set authentication_string=password('123456') where user='root';
flush privileges;
</code></pre>

blocks|key|4457377|text|我在MacOSX10.10.4(Yosemite)中也遇到了同样的问题，.SET密码适用于mysql的me.Alter密码-+mysql>设置密码=密码(‘your_password’)；查询正常，0行受影响，1个警告(0.01秒)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457378|在.bash_profile中设置Mysql环境路径变量，并添加以下行|4457379|export+PATH=$PATH:/usr/local/mysql/bin，然后运行以下命令:source+.bash_profile|4457380|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I also got the same problem in mac OS X 10.10.4(Yosemite).SET PASSWORD work for me.Alter password for mysql-
mysql> SET PASSWORD = PASSWORD('your_password');
Query OK, 0 rows affected, 1 warning (0.01 sec)

set your Mysql environment path variable in .bash_profile and add the below line 
export PATH=$PATH:/usr/local/mysql/bin,
after that, run the following command :source .bash_profile

blocks|key|4457448|text|我在安装mysql工作台和mysql社区服务器后遇到了这个问题。在服务器安装过程中获得了生成的密码。双击工作台中现有的本地实例会触发一个对话框，我可以在其中设置新密码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457449|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Had the problem after I installed mysql workbench and mysql community server. Got generated password during the server installation.
Double clicking on the exisiting local instance in workbench triggered a dialog where I could set the new password.

blocks|key|4457592|text|为我工作的mysql>+SET+PASSWORD+=+PASSWORD('your_new_password');。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4457593|entityMap^0|5|1G|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|$]]

<code>mysql&gt; SET PASSWORD = PASSWORD('your_new_password');</code>
That works for me.

blocks|key|4457664|text|记住版本5.7.23和更高版本-用户表没有列密码，而是身份验证字符串，所以下面在为用户重置密码时起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457665|update+user+set+authentication_string=password('root')+where+user='root';|code-block|syntax|javascript|4457666|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|$]]

remember versions 5.7.23 and up - the user table doesn't has column password instead authentication string so below works while resetting password for a user.

<pre><code>update user set authentication_string=password('root') where user='root';
</code></pre>

blocks|key|4457811|text|我也有同样的问题。拒绝访问..|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4457812|所以，我的解决方案是，|4457813|去|4457814|mysql>+USE+mysql;
mysql>+SELECT+User,+Host,+plugin+FROM+mysql.user;|code-block|syntax|javascript|4457815|您可以看到插件列名|4457816|我将插件从unix_socket+->更改为mysql_native_password|4457817|因此，请键入以下内容|4457818|mysql+>+use+mysql;
mysql>+update+user+set+plugin='mysql_native_password'+where+user='root';
mysql>+flush+privileges;|4457819|好了。我的版本是10.1.48+MariaDB+ubuntu+18|4457820|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|12|8|@]|9|@]|A|$]]|$1|Q|3|R|5|H|7|13|8|@]|9|@]|A|$I|J]]|$1|S|3|T|5|6|7|14|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

i had same problem. access denied..
so, my solution is,
go to
<pre><code>mysql&gt; USE mysql;
mysql&gt; SELECT User, Host, plugin FROM mysql.user;
</code></pre>
you can see plug in column name
i changed plugin from
unix_socket -&gt; to mysql_native_password
so, type this
<pre><code>mysql &gt; use mysql;
mysql&gt; update user set plugin='mysql_native_password' where user='root';
mysql&gt; flush privileges;
</code></pre>
done.
my version so 10.1.48 MariaDB ubuntu 18

I'm new to the whole Mac experience. I recently installed MySQL and it seems I have to reset the password after install. It won't let me do anything else.

Now I already reset the password the usual way: 

<pre><code>update user set password = password('XXX') where user = root;
</code></pre>

(BTW: took me ages to work out that MySQL for some bizarre reason has renamed the field 'password' to 'authentication_string'. I am quite upset about changes like that.)

Unfortunately it seems I need to change the password a different way that is unknown to me. Maybe someone here has already come across that problem?

Reset MySQL root password using ALTER USER statement after install on Mac

身份验证

服务器

MariaDB

MySQL

我对整个Mac体验都是新手。我最近安装了MySQL，似乎在安装后我必须重置密码。它不会让我做其他任何事。现在我已经用通常的方法重置了密码：update user set password = password('XXX') where user = root;(顺便说一句:我花了很长时间才弄明白，出于某种奇怪的原因，身份验证将“MySQL”字段重命名为“authentication_string”

问在MySQL上安装后使用ALTER USER语句重置Mac根密码
EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在MySQL上安装后使用ALTER USER语句重置Mac根密码EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在MySQL上安装后使用ALTER USER语句重置Mac根密码
EN