Please note, that this is an old archived version of this site. Check out the new version at andunix.net!

Differences

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

--- info:mysql:user:password [2013-03-01 20:50]
andunix created
+++ info:mysql:user:password [2013-12-17 09:09] (current)
andunix
@@ Line 5: / Line 5: @@
 <code sql>
-GRANT USAGE ON * . *
+GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{passwd}';
-TO '{user}'@'%'
+FLUSH PRIVILEGES;
-IDENTIFIED BY '{passwd}' ;
+</code>
+Or you can alternatively use the following:
+<code sql>
+UPDATE mysql.user SET Password=PASSWORD('{passwd}') WHERE User='{user}';
+FLUSH PRIVILEGES;
 </code>
 {{tag>admin database mysql password sql}}

andunix.net