my sql 초기 비밀번호 설정

  222  2015-05-20_14:00:40 [CMD]: /etc/init.d/mysqld stop
  223  2015-05-20_14:00:46 [CMD]: /usr/local/mysql/bin/mysqld_safe --skip-grant &
  224  2015-05-20_14:01:00 [CMD]: mysql -u root -p

 use mysql;

> update user set password=password('P@ssw0rd') where user='root';
 flush privileges;
 create database onpice;
mysql> show databases;/ㄷㅅㅊ

mysql> GRANT ALL PRIVILEGES ON onpice.* TO onpice@localhost IDENTIFIED BY 'P@ssw0rd';

mysql> flush privileges;