User Tools

Site Tools


info:mysql:user:password

MySQL: Change Password

  • Replace {passwd} with the password of the user.
  • Replace {user} with the name of the user.
GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{passwd}';
FLUSH PRIVILEGES;

Or you can alternatively use the following:

UPDATE mysql.USER SET Password=PASSWORD('{passwd}') WHERE USER='{user}';
FLUSH PRIVILEGES;
info/mysql/user/password.txt · Last modified: 2013-12-17 10:09 by andunix