Home >Database >Mysql Tutorial >MySQL修改密码的各种方法,yc整理_MySQL

MySQL修改密码的各种方法,yc整理_MySQL

WBOY
WBOYOriginal
2016-06-01 13:02:021230browse

转载请注明出处http://blog.csdn.net/yc7369

MySQL修改密码的各种方法

整理了以下四种在MySQL中修改root密码的方法,可能对大家有所帮助!

方法1: 用SET PASSWORD命令

  mysql -uroot

  mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

方法2:用mysqladmin

  mysqladmin-u root password "newpass"

  如果root已经设置过密码,采用如下方法

  mysqladmin-u root password oldpass "newpass"

方法3: 用UPDATE直接编辑user表

  mysql -uroot

  mysql>use mysql;

  mysql>UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';

  mysql>FLUSH PRIVILEGES;

在丢失root密码的时候,可以这样

  mysqld_safe--skip-grant-tables&

  mysql -uroot mysql

  mysql>UPDATE user SET password=PASSWORD("new password") WHERE user='root';

  mysql>FLUSH PRIVILEGES;

以下语句在mysql 5.6中亲测可用,其他版本应该都差不多的

转载请注明出处http://blog.csdn.net/yc7369

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