ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

MySQL/문제해결 2013.07.02 22:06

<ins id="aswift_0_anchor" style="display: block; border: none; height: 60px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 468px; background-color: transparent;"><iframe width="468" height="60" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allowfullscreen="true" id="aswift_0" name="aswift_0" style="left: 0px; top: 0px;"></iframe></ins>

 

MySQL 설치 후 첫 접속 시 다음과 같은 에러에 직면할 수 있다.

mysql> show databases;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql>

다음과 같이 루트 (root) 암호 (password)를 설정해주면 된다.

mysql> SET PASSWORD=PASSWORD('dlawjdanr1');
Query OK, 0 rows affected (0.06 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.05 sec)

mysql>

암호 설정 후 문제없이 수행됨을 확인할 수 있다.

Reference:
http://mysqlyogi.blogspot.kr/2013/03/error-1820-hy000-you-must-set-password.html

MySQL Yogi: ERROR 1820 (HY000): You must SET PASSWORD befo...

mysqlyogi.blogspot.kr