Differences

This shows you the differences between two versions of the page.

--- mysql_updatepass [2015/04/04 13:56] – created luke7858
+++ mysql_updatepass [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 2: / Line 2: @@
 <sxh bash>
-UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='user' AND Host='x.x.x.x';
+UPDATE mysql.user set Password=PASSWORD('newpassword') WHERE User='user' AND Host='x.x.x.x';
+</sxh>
+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:
+<sxh bash>
+update mysql.user set password=PASSWORD('newpassword') where User='luke';
 </sxh>