MySQL修改密码

最新推荐文章于 2025-06-04 09:55:14 发布

转载最新推荐文章于 2025-06-04 09:55:14 发布 · 419 阅读

文章标签：

#mysql #密码

数据库专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了在MySQL中使用SET PASSWORD、UPDATE语句及mysqladmin命令线程客户端设置根账户密码的方法，包括对本地主机和远程主机账户的处理，并强调了密码更改后服务器需要刷新权限以应用新密码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

A root account password can be set several ways. The following discussion demonstrates three methods:

Use the SET PASSWORD statement
Use the UPDATE statement
Use the mysqladmin command-line client program

To assign passwords using SET PASSWORD, connect to the server as root and issue a SET PASSWORD statement for each root account listed in the mysql.user table.

For Unix, do this:

shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'::1' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');

You can also use a single statement that assigns a password to all root accounts by using UPDATE to modify themysql.user table directly. This method works on any platform:

shell> mysql -u root
mysql> UPDATE mysql.user SET Password = PASSWORD('newpwd')
    ->     WHERE User = 'root';
mysql> FLUSH PRIVILEGES;

The FLUSH statement causes the server to reread the grant tables. Without it, the password change remains unnoticed by the server until you restart it.

To assign passwords to the root accounts using mysqladmin, execute the following commands:

shell> mysqladmin -u root password "newpwd"
shell> mysqladmin -u root -h host_name password "newpwd"

Those commands apply both to Windows and to Unix. The double quotation marks around the password are not always necessary, but you should use them if the password contains spaces or other characters that are special to your command interpreter.

The mysqladmin method of setting the root account passwords does not work for the 'root'@'127.0.0.1' or 'root'@'::1' account. Use the SET PASSWORD method shown earlier.