mysql修改密码

最新推荐文章于 2022-11-08 20:01:51 发布

book_xnlzh035

最新推荐文章于 2022-11-08 20:01:51 发布

阅读量98

点赞数

分类专栏：数据库文章标签： MySQL Java

52 篇文章 0 订阅

订阅专栏

在MySQL中修改一个用户（比如叫"username"）的密码.
一.方法1

mysql＞ UPDATE user SET password=PASSWORD("new password") WHERE user='username'; 
mysql＞ FLUSH PRIVILEGES;

 mysql> REPLACE INTO mysql.user (Host,User,Password) VALUES('%','username',PASSWORD('password')); 
mysql＞ FLUSH PRIVILEGES;

二.方法2

mysql＞ SET PASSWORD FOR username=PASSWORD('new password');

mysql＞ SET PASSWORD FOR username@"%" = PASSWORD('password');

三.方法3

使用命令mysqladmin

mysqladmin -u root -p password mypasswd

四.方法4
使用phpmyadmin，这是最简单的了，修改mysql库的user表,必须使用PASSWORD函数

五.增加用户

mysql> GRANT USAGE ON *.* TO username@"%" IDENTIFIED BY 'password';

mysql> GRANT RELOAD,PROCESS ON *.* TO username@localhost;

mysql>GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'something' WITH GRANT OPTION;

mysql>GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'something' WITH GRANT OPTION;

关注