mysql 초기 root 패스워드 설정
mysql을 처음 설치하게 되면 root 패스워드가 없고 그냥 엔터치면 들어가진다.
#mysql -uroot -p
mysql> use mysql
Database changed
mysql>update user set password=password('new_password') where user='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql>flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> use mysql
Database changed
mysql>update user set password=password('new_password') where user='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql>flush privileges;
Query OK, 0 rows affected (0.00 sec)
http://www.joon.pe.kr/blog/trackback/193
