User Tools

Site Tools


mysql_updatepass

Changing a users password

UPDATE mysql.user set Password=PASSWORD('newpassword') WHERE User='user' AND Host='x.x.x.x';

You are also able to use the following command, this will change the password for ALL users with the matching username, so you do not have to declare the host:

update mysql.user set password=PASSWORD('newpassword') where User='luke';

mysql_updatepass.txt · Last modified: 2024/05/23 07:26 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki