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> | <code sql> | ||
- | GRANT USAGE ON * . * | + | GRANT USAGE ON *.* TO ' |
- | TO ' | + | FLUSH PRIVILEGES; |
- | IDENTIFIED BY ' | + | </ |
+ | |||
+ | Or you can alternatively use the following: | ||
+ | |||
+ | <code sql> | ||
+ | UPDATE mysql.user SET Password=PASSWORD(' | ||
+ | FLUSH PRIVILEGES; | ||
</ | </ | ||
{{tag> | {{tag> |