blocks|key|2894231|text|密码过期是MySQL+5.6或5.7中的新功能。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2894232|答案很明确:使用能够更改过期密码的客户端(我认为Sequel+Pro可以做到这一点)。|2894233|MySQLi库显然无法更改过期的密码。|2894234|如果您对localhost的访问权限有限，并且只有一个控制台客户端，那么标准的mysql客户端可以做到这一点。|2894235|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

The password expiration is a new feature in MySQL 5.6 or 5.7.

The answer is clear: Use a client which is capable of expired password changing (I think Sequel Pro can do it).

MySQLi library obviously isnt able to change the expired password.

If you have limited access to localhost and you only have a console client, the standard mysql client can do it.

blocks|key|2682322|text|使用--skip-grant-tables选项重新启动MySQL服务器，然后设置新的超级用户密码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2682323|$+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|2682324|现在，如果需要，可以更新mysql.user表(字段password_expired='N')，使密码不过期。|2682325|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|$]]

restart MySQL server with --skip-grant-tables option
And then set a new root password

<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>

Now if you need, you can update mysql.user table(field password_expired='N') not to expire the password.

blocks|key|126285|text|所以我最终自己找到了解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|126286|首先，我进入终端并输入：|126287|mysql+-u+root+-p|offset|length|style|CODE|126288|这会询问我当前的密码，我输入了密码，它给了我提供更多mysql命令的权限。我在这里尝试的任何东西都显示以下错误：|126289|ERROR+1820+(HY000):+You+must+reset+your+password+using+ALTER+USER+statement+before+executing+this+statement.|126290|这很令人困惑，因为我实际上看不到使用ALTER+USER语句重置密码的方法，但我找到了另一个简单的解决方案：|126291|SET+PASSWORD+=+PASSWORD('xxxxxxxx');|126292|entityMap^0|0|0|0|G|0|0|0|30|0|I|A|0|0|10|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@$F|W|G|X|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|Z|8|@$F|10|G|11|H|I]]|9|@]|A|$]]|$1|N|3|O|5|6|7|12|8|@$F|13|G|14|H|I]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|15|8|@$F|16|G|17|H|I]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|S|$]]

So I finally found the solution myself.

Firstly I went into terminal and typed:

<code>mysql -u root -p</code>

This asked for my current password which I typed in and it gave me access to provide more mysql commands. Anything I tried from here gave this error:

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

This is confusing because I couldn't actually see a way of resetting the password using <code>ALTER USER</code> statement, but I did find another simple solution:

<code>SET PASSWORD = PASSWORD('xxxxxxxx');</code>

blocks|key|2682371|text|我最近在mac+os+x+capitan上安装mysql时遇到了同样的问题。我在这里没有找到正确的答案，所以添加这个答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2682372|mysql在当前版本中，安装MySql时会生成一个临时密码。使用此密码通过mysqladmin工具设置新密码，如下所示；|2682373|2682374|+/usr/local/mysql/bin/mysqladmin+p+'‘-u’‘|blockquote|2682375|2682376|2682377|希望能对你和其他人有所帮助。|2682378|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|Q|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|S|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|T|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|M|$]]

I went through the same issue recently while installing mysql on mac os x capitan.
I did not find the correct answer here, so adding this answer.

MySql in current versions, generates a temporary password when you install mysql. Use this password to set a new password using the mysqladmin utility as below;

<blockquote>
 /usr/local/mysql/bin/mysqladmin -u root -p'&lt;your temp password&gt;' password '&lt;your new password&gt;'
</blockquote>

Hope it helps you and others.

blocks|key|126819|text|在OS+Capitan和MySQL+5.7.12社区服务器上，mysqladmin+-u+[username]+-p+password为我工作。示例：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|126820|$+/usr/local/mysql/bin/mysqladmin+-u+root+-p+password
Enter+password:
New+password:
Confirm+new+password:
Warning:+Since+password+will+be+sent+to+server+in+plain+text,+use+ssl+connection+to+ensure+password+safety.|code-block|syntax|javascript|126821|这与pavan+sachi的答案类似，但带有密码提示。|126822|我的错误是"#1862+-您的密码已过期。要登录，您必须使用支持过期密码的客户端进行更改。“第一次出现在phpMyAdmin登录屏幕。|126823|entityMap^0|V|10|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|V|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

<code>mysqladmin -u [username] -p password</code> worked for me on OS X El Capitan and MySQL 5.7.12 Community Server. Example: 

<pre><code>$ /usr/local/mysql/bin/mysqladmin -u root -p password
Enter password:
New password:
Confirm new password:
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
</code></pre>

This is similar to pavan sachi's answer, but with password prompts.

My error was "#1862 - Your password has expired. To log in you must change it using a client that supports expired passwords." at phpMyAdmin login screen first time.

blocks|key|2682384|text|只需下载MySQL工作台即可登录。它将提示您立即自动更改密码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2682385|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|$]]

Just download MySQL workbench to log in. It will prompt you to change the password immediately and automatically.

blocks|key|2682387|text|首先，我使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2682388|+mysql+-u+root+-p|code-block|syntax|javascript|2682389|为“root”提供我当前的密码。接下来：|2682390|mysql>+ALTER+USER+`root`@`localhost`+IDENTIFIED+BY+'new_password',
+++++++`root`@`localhost`+PASSWORD+EXPIRE+NEVER;|2682391|将'new_password'更改为用户“root”的新密码。|offset|length|style|CODE|2682392|它解决了我的问题。|2682393|entityMap^0|0|0|0|0|1|E|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@$M|Z|N|10|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

First, I use:

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

Giving my current password for the 'root'.
Next:

<pre><code>mysql&gt; ALTER USER `root`@`localhost` IDENTIFIED BY 'new_password',
 `root`@`localhost` PASSWORD EXPIRE NEVER;
</code></pre>

Change <code>'new_password'</code> to a new password for the user 'root'. 
It solved my problem.

blocks|key|2682399|text|MySQL密码过期|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2682400|重置密码只能暂时解决问题。从MySQL+5.7.4到5.7.10+(为了鼓励更好的安全性-请参阅MySQL:+Password+Expiration+Policy)，默认的default_password_lifetime变量值是360+(1年左右)。对于这些版本，如果您不更改此变量(或单个用户帐户)，则所有密码将在360天后过期。|offset|length|style|CODE|2682401|因此，您可能会从脚本中得到这样的消息：“您的密码已过期。要登录，您必须使用支持过期密码的客户端进行更改。”|2682402|要停止自动密码过期，请以根用户身份(mysql+-u+root+-p)登录，然后，对于自动连接到服务器的客户端(例如脚本)。更改密码过期设置：|2682403|ALTER+USER+'script'@'localhost'+PASSWORD+EXPIRE+NEVER;|2682404|或者，您可以为所有用户禁用自动密码过期|2682405|SET+GLOBAL+default_password_lifetime+=+0;|2682406|正如Mertaydin在注释中指出的，要使其永久存在，请将以下行添加到MySQL在启动时读取的[mysqld]设置组下的my.cnf文件中。my.cnf的位置取决于您的设置(例如，Windows、OS+X上的Homebrew或安装程序)，以及您是希望在Unix上还是全局上执行以下每个用户的操作：|2682407|mysqld+default_password_lifetime+=+0+(这里可能还有其他设置...)|2682408|请参阅MySQL+docs+on+configuration+files。|2682409|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html|1|https://dev.mysql.com/doc/refman/5.7/en/option-files.html^0|0|2E|P|1C|X|0|0|0|I|G|0|0|1I|0|0|0|15|0|1B|8|1O|6|1Y|6|0|7|T|0|3|X|1|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|18|8|@$D|19|E|1A|F|G]]|9|@$D|1B|E|1C|1|1D]]|A|$]]|$1|H|3|I|5|6|7|1E|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1F|8|@$D|1G|E|1H|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1I|8|@$D|1J|E|1K|F|G]]|9|@]|A|$]]|$1|N|3|O|5|6|7|1L|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1M|8|@$D|1N|E|1O|F|G]]|9|@]|A|$]]|$1|R|3|S|5|6|7|1P|8|@$D|1Q|E|1R|F|G]|$D|1S|E|1T|F|G]|$D|1U|E|1V|F|G]]|9|@]|A|$]]|$1|T|3|U|5|6|7|1W|8|@$D|1X|E|1Y|F|G]]|9|@]|A|$]]|$1|V|3|W|5|6|7|1Z|8|@]|9|@$D|20|E|21|1|22]]|A|$]]|$1|X|3|-4|5|6|7|23|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14]]|15|$5|10|11|12|A|$13|16]]]]

<h2>MySQL password expiry</h2>

Resetting the password will only solve the problem temporarily. From MySQL 5.7.4 to 5.7.10 (to encourage better security - see <a href="https://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html" rel="noreferrer">MySQL: Password Expiration Policy</a>) the default <code>default_password_lifetime</code> variable value is 360 (1 year-ish). For those versions, if you make no changes to this variable (or to individual user accounts) all passwords expire after 360 days.

So from a script you might get the message: "Your password has expired. To log in you must change it using a client that supports expired passwords."

To stop automatic password expiry, log in as root (<code>mysql -u root -p</code>), then, for clients that automatically connect to the server (e.g. scripts.) change password expiration settings:

<code>ALTER USER 'script'@'localhost' PASSWORD EXPIRE NEVER;</code>

OR you can disable automatic password expiration for all users:

<code>SET GLOBAL default_password_lifetime = 0;</code>

As pointed out by Mertaydin in the comments, to make this permanent add the following line to a <code>my.cnf</code> file MySQL reads on startup, under the <code>[mysqld]</code> group of settings. The location of <code>my.cnf</code> depends on your setup (e.g. Windows, or Homebrew on OS X, or an installer), and whether you want this per-user on Unix or global:

[mysqld]
<code>default_password_lifetime = 0</code>
(There may be other settings here too...)

See the <a href="https://dev.mysql.com/doc/refman/5.7/en/option-files.html" rel="noreferrer">MySQL docs on configuration files</a>.

blocks|key|2682411|text|在安全模式下启动MYSQL|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2682412|mysqld_safe+--skip-grant-tables+&|code-block|syntax|javascript|2682413|连接到MYSQL服务器|2682414|mysql+-u+root|2682415|运行SQL命令以重置密码：|2682416|use+mysql;
SET+GLOBAL+default_password_lifetime+=+0;
SET+PASSWORD+=+PASSWORD('new_password');|2682417|最后一步，重新启动mysql服务|2682418|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

start MYSQL in safe mode

<pre><code>mysqld_safe --skip-grant-tables &amp;
</code></pre>

Connect to MYSQL server

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

run SQL commands to reset password:

<pre><code>use mysql;
SET GLOBAL default_password_lifetime = 0;
SET PASSWORD = PASSWORD('new_password');
</code></pre>

Last step, restart your mysql service

blocks|key|123805|text|所有这些答案都是使用Linux控制台访问MySQL。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|123806|如果您使用的是WAMP，您可以从打开MySQL控制台(click+WAMP+icon->MySQL->MySQL+console)开始。|offset|length|style|CODE|123807|然后它会要求您输入当前密码，请输入。|123808|然后键入SET+PASSWORD+=+PASSWORD('some_pass');|123809|entityMap^0|0|R|11|0|0|4|11|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

All of these answers are using Linux consoles to access MySQL.

If you are on Windows and are using WAMP, you can start by opening the MySQL console (<code>click WAMP icon-&gt;MySQL-&gt;MySQL console</code>).

Then it will request you to enter your current password, enter it.

And then type <code>SET PASSWORD = PASSWORD('some_pass');</code>

blocks|key|126357|text|最简单的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|126358|[PATH+MYSQL]/bin/mysql+-u+root
[Enter+password]
SET+GLOBAL+default_password_lifetime+=+0;|code-block|syntax|javascript|126359|然后工作得很好。|126360|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|$]]

best easy solution: 

<pre><code>[PATH MYSQL]/bin/mysql -u root
[Enter password]
SET GLOBAL default_password_lifetime = 0;
</code></pre>

and then works fine.

blocks|key|124928|text|打开MySQL控制台，键入SET+PASSWORD+=+'your+password'；然后按ENTER键，这将为根用户设置您定义的密码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|124929|您只能写入SET+PASSWORD+=+''；这会将root用户的密码设置为空。|124930|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|$]]

Open MySQL console and type SET PASSWORD = 'your password'; 
and then press ENTER Key which will set your defined password for user root.

You can only write SET PASSWORD = '';
which will set password as blank for root user.

blocks|key|2894322|text|我几天前就遇到过这个问题。要获得5.7版本mysql的最佳解决方案，请登录您的mysql控制台并使用以下命令更改您的密码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2894323|ALTER+USER+`root`@`localhost`+IDENTIFIED+BY+'new_password',+`root`@`localhost`+PASSWORD+EXPIRE+NEVER;|code-block|syntax|javascript|2894324|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|$]]

i have faced this issue few days ago. For best solution for 5.7 version of MySQL; login your mysql console and alter your password with the following command:

<pre><code>ALTER USER `root`@`localhost` IDENTIFIED BY 'new_password', `root`@`localhost` PASSWORD EXPIRE NEVER;
</code></pre>

blocks|key|2894326|text|这对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2894327|ALTER+USER+'root'@'localhost'+IDENTIFIED+BY+'yourpassword','root'@'localhost'+PASSWORD+EXPIRE+NEVER;|code-block|syntax|javascript|2894328|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|$]]

This worked for me:

<pre><code>ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpassword','root'@'localhost' PASSWORD EXPIRE NEVER;
</code></pre>

blocks|key|2894330|text|警告:这将允许任何用户登录|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2894331|我不得不尝试其他的方法。因为我的root密码过期了，而且不能更改，因为|2894332|Column+count+of+mysql.user+is+wrong.+Expected+45,+found+46.+The+table+is+probably+corrupted|CODE|2894333|临时将skip-grant-tables添加到my.cnf中的[mysqld]下，然后重新启动mysql就行了|2894334|entityMap^0|0|D|0|0|0|2J|0|3|H|N|6|V|8|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|S|8|@$9|T|A|U|B|J]]|D|@]|E|$]]|$1|K|3|L|5|6|7|V|8|@$9|W|A|X|B|J]|$9|Y|A|Z|B|J]|$9|10|A|11|B|J]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$]]

WARNING: this will allow any user to login

I had to try something else. Since my root password expired and altering was not an option because 

<code>Column count of mysql.user is wrong. Expected 45, found 46. The table is probably corrupted</code>

temporarly adding <code>skip-grant-tables</code> under <code>[mysqld]</code> in <code>my.cnf</code> and restarting mysql did the trick

blocks|key|2682453|text|在Windows的phpmyadmin中，查看变量:+default_password_lifetime，并将其切换为0(而不是360)，享受。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2682454|这可能比mySQL再花360天，所以加上my.ini：|2682455|[mysqld]
default_password_lifetime=0|code-block|syntax|javascript|2682456|然后重启mysql。|2682457|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

On Windows in phpmyadmin look in Variables: default_password_lifetime, and switch it to 0 (instead of 360), enjoy.

Its possible than mySQL take again 360 days, so add in my.ini :

<pre><code>[mysqld]
default_password_lifetime=0
</code></pre>

And restart mysql.

blocks|key|126386|text|这对我来说很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|126387|来源：https://www.diariodeunprogramador.net/fallo-al-conectar-mysql-your-password-expired/|offset|length|126388|以root用户身份登录：|126389|mysql+-u+root+-p|code-block|syntax|javascript|126390|然后停用所有用户的密码自动过期：|126391|SET+GLOBAL+default_password_lifetime+=+0;|126392|entityMap|0|LINK|mutability|MUTABLE|url|https://www.diariodeunprogramador.net/fallo-al-conectar-mysql-your-password-expired/^0|0|3|2C|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@$D|10|E|11|1|12]]|A|$]]|$1|F|3|G|5|6|7|13|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|14|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|15|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|16|8|@]|9|@]|A|$K|L]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

This work for me: 

Source: <a href="https://www.diariodeunprogramador.net/fallo-al-conectar-mysql-your-password-expired/" rel="nofollow noreferrer">https://www.diariodeunprogramador.net/fallo-al-conectar-mysql-your-password-expired/</a> 

Login as root:

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

and then you deactivate the automatic expiration of passwords of all the users:

<pre><code>SET GLOBAL default_password_lifetime = 0;
</code></pre>

blocks|key|126394|text|我做了这样的事情。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|126395|UPDATE+mysql.user+SET+authentication_string+=+PASSWORD(''),+password_expired+=+'N'+WHERE+User+=+'root'+AND+Host+=+'localhost';|code-block|syntax|javascript|126396|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|$]]

I did something like this. 

<pre><code>UPDATE mysql.user SET authentication_string = PASSWORD(''), password_expired = 'N' WHERE User = 'root' AND Host = 'localhost';
</code></pre>

blocks|key|124953|text|只需打开MySQL工作台，选择实例启动/关闭，然后单击启动服务器。这对我很管用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|124954|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|$]]

Just open MySQL Workbench and choose [Instance] Startup/Shutdown and click on start server.
It worked for me

blocks|key|2894453|text|在DBeaver上，编辑Connection+->+Driver+Properties+->+disable+disconnectOnExpiredPasswords：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2894454|📷|atomic|offset|length|2894455|​|2894456|重新连接并执行以下操作：|2894457|2894458|2894459|并执行：|2894460|SET+PASSWORD+FOR+'user-name'@'localhost'+=+PASSWORD('NEW_USER_PASSWORD');
FLUSH+PRIVILEGES;|code-block|syntax|javascript|2894461|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/81dfe9b23ded3b400c02c84e74c6d2e3.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/a164d528be65425856c2bac4b927f10b.png^0|0|0|1|0|0|0|0|0|1|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@$E|16|F|17|1|18]]|A|$]]|$1|G|3|H|5|6|7|19|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1A|8|@]|9|@]|A|$]]|$1|K|3|C|5|D|7|1B|8|@]|9|@$E|1C|F|1D|1|1E]]|A|$]]|$1|L|3|H|5|6|7|1F|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1G|8|@]|9|@]|A|$]]|$1|O|3|P|5|Q|7|1H|8|@]|9|@]|A|$R|S]]|$1|T|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|U|$V|$5|W|X|Y|A|$Z|10|11|-4]]|12|$5|W|X|Y|A|$Z|13|11|-4]]]]

On DBeaver, Edit Connection -&gt; Driver Properties -&gt; disable disconnectOnExpiredPasswords:
<a href="https://i.stack.imgur.com/dhxad.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dhxad.png" alt="enter image description here" /></a>
Reconnect and:
<a href="https://i.stack.imgur.com/cp3ax.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cp3ax.png" alt="enter image description here" /></a>
And execute:
<pre><code>SET PASSWORD FOR 'user-name'@'localhost' = PASSWORD('NEW_USER_PASSWORD');
FLUSH PRIVILEGES;
</code></pre>

I just wiped my Mac and did a fresh install of El Capitan. I'm struggling to connect to Mysql now. Having gone through a web server setup process, I've created a simple PHP test file:

<pre><code>&lt;?php
 $conn = new mysqli("127.0.0.1", "root", "xxxxxxxx");
 if ($conn-&gt;connect_error) echo "Connection failed: " . $conn-&gt;connect_error; 
 else echo "Connected successfully";
 phpinfo();
?&gt;
</code></pre>

When I run it, I get this error:

<pre><code>Warning: mysqli::mysqli(): (HY000/1862): Your password has expired. To log in you must change it using a client that supports expired passwords. in /Users/rich/Documents/DESIGN/test/index.php on line 3
Connection failed: Your password has expired. To log in you must change it using a client that supports expired passwords.
</code></pre>

I've never seen that response from a connection before. How do I fix it if I can't connect?

EDIT

In terminal I entered the command:

<code>mysql -u root -p</code>

This asked me for my password (current one) which I put in. I now have access to mysql commands but anything I try results in this error:

<pre><code>ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
</code></pre>

How do I reset the password using <code>ALTER USER</code>?

Mysql password expired. Can't connect

服务器

Windows

MySQL

Linux

Unix

我刚刚擦除了我的Mac，并重新安装了El Capitan。我现在正在努力连接到Mysql。在完成web服务器设置过程之后，我创建了一个简单的PHP测试文件：<?php $conn = new mysqli("127.0.0.1", "root", "xxxxxxxx"); if ($conn->connect_er...

问Mysql密码已过期。无法连接
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Mysql密码已过期。无法连接EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Mysql密码已过期。无法连接
EN