Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Last revision Both sides next revision | ||
|
mysql [2015/04/02 14:59] 진보넷 [계정] |
mysql [2015/04/02 14:59] 진보넷 [계정] |
||
|---|---|---|---|
| Line 90: | Line 90: | ||
| <code mysql> | <code mysql> | ||
| SET PASSWORD FOR 'USER'@'localhost' = PASSWORD('NEWPASSWORD'); | SET PASSWORD FOR 'USER'@'localhost' = PASSWORD('NEWPASSWORD'); | ||
| + | FLUSH PRIVILEGES; | ||
| - 또는 - | - 또는 - | ||
| UPDATE mysql.user SET Password=PASSWORD('NEWPASSWORD') WHERE User='USER' AND Host='localhost'; | UPDATE mysql.user SET Password=PASSWORD('NEWPASSWORD') WHERE User='USER' AND Host='localhost'; | ||
| + | FLUSH PRIVILEGES; | ||
| </code> | </code> | ||