Change password for particular user: Unterschied zwischen den Versionen
Aus WikiStar
Vkl (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „<syntaxhighlight lang="sql" style="font-size:9pt;"> UPDATE user SET Password = PASSWORD('FILL-PASSWORD') WHERE User = 'root'; FLUSH PRIVILEGES; </syntaxhighlig…“) |
Jre (Diskussion | Beiträge) |
||
| Zeile 1: | Zeile 1: | ||
| + | Needed in case a old password needs to be set or if the password is working anymore after a change to a higher PHP Verion. (Changes in the hashing as of PHP 5.4) | ||
| + | |||
<syntaxhighlight lang="sql" style="font-size:9pt;"> | <syntaxhighlight lang="sql" style="font-size:9pt;"> | ||
| − | UPDATE user SET Password = PASSWORD('FILL-PASSWORD') WHERE User = ' | + | UPDATE user SET Password = PASSWORD('FILL-PASSWORD') WHERE User = 'webXYZ'; |
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
Aktuelle Version vom 30. Oktober 2014, 13:23 Uhr
Needed in case a old password needs to be set or if the password is working anymore after a change to a higher PHP Verion. (Changes in the hashing as of PHP 5.4)
UPDATE USER SET Password = PASSWORD('FILL-PASSWORD') WHERE USER = 'webXYZ'; FLUSH PRIVILEGES;
