[MySQL] password 변경

1. consol

update user set password=password('[change password]') where user='[user id]';

mysql> update user set password=password('xxxxxx') where user='root'; Query OK, 4 rows affected (0.05 sec) Rows matched: 4  Changed: 4  Warnings: 0 mysql> quit Bye [root@test /]# mysqladmin -u root -p reload Enter password: [root@test /]#

2. command

# mysqladmin -u [user id] -p password '[change password]'

[root@test /]# mysqladmin -u root -p password 'xxxxxx' Enter password: Warning: Using a password on the command line interface can be insecure. [root@test /]#