Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
mysql [2015/04/02 14:59] 진보넷 [계정] |
mysql [2015/04/02 15:31] (current) 진보넷 [계정] |
||
---|---|---|---|
Line 78: | Line 78: | ||
<code mysql> | <code mysql> | ||
CREATE USER 'USER'@'localhost' IDENTIFIED BY 'PASSWORD'; | CREATE USER 'USER'@'localhost' IDENTIFIED BY 'PASSWORD'; | ||
+ | FLUSH PRIVILEGES; | ||
</code> | </code> | ||
Line 84: | Line 85: | ||
<code mysql> | <code mysql> | ||
DROP USER 'USER'@'localhost'; | DROP USER 'USER'@'localhost'; | ||
+ | FLUSH PRIVILEGES; | ||
</code> | </code> | ||
Line 90: | Line 92: | ||
<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> | ||