Home >Database >Mysql Tutorial >三种方法修改MySQL中一个用户的密码

三种方法修改MySQL中一个用户的密码

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 16:04:051574browse

在MySQL中修改一个用户(比如叫"hunte")的密码,可以用如下3个办法: #在控制台上输入 bash$ mysql -u root mysql #用mysql客户程序 mysql UPDATE user SET password=PASSWORD("new password") WHERE user='hunte'; mysql FLUSH PRIVILEGES; mysql QUIT #在

在MySQL中修改一个用户(比如叫"hunte")的密码,可以用如下3个办法:

#在控制台上输入
bash$ mysql -u root mysql
#用mysql客户程序
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='hunte';
mysql> FLUSH PRIVILEGES;
mysql> QUIT

#在控制台上输入
bash$ mysql -u root mysql
mysql> SET PASSWORD FOR hunte=PASSWORD('new password');
mysql> QUIT

#直接在控制台上输入
bash$ mysqladmin -u root "old password" "new password"


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn