Blog-boxcorea
Simple is Beautiful!
RedHat 9.0에서 MRTG 구축하기 실습
WRT-54G 펌웨어 관련글
1월 11
기억력이 나빠서.. 할때마다 문서찾기..
그냥 적어 놓으련다.
mysql> CREATE database 디비; Query OK, 0 rows affected (0.00 sec) mysql> GRANT all privileges on 디비.* TO 사용자@localhost > IDENTIFIED BY ‘패스워드’; Query OK, 0 rows affected (0.00 sec)
mysql> CREATE database 디비; Query OK, 0 rows affected (0.00 sec)
mysql> GRANT all privileges on 디비.* TO 사용자@localhost > IDENTIFIED BY ‘패스워드’; Query OK, 0 rows affected (0.00 sec)
아래와 같은 오류가 나는 경우
mysql> grant all privileges on scanner.* to scanner@localhost identified by ‘scanner’; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
validate_password를 제거하고 설정해도 된다.
mysql> uninstall plugin validate_password; Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on scanner.* to scanner@localhost identified by ‘scanner’; Query OK, 0 rows affected, 1 warning (0.01 sec)
Your email address will not be published.
Notify me of follow-up comments by email.
Notify me of new posts by email.
Δ
1 comment
아래와 같은 오류가 나는 경우
mysql> grant all privileges on scanner.* to scanner@localhost identified by ‘scanner’;
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
validate_password를 제거하고 설정해도 된다.
mysql> uninstall plugin validate_password;
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on scanner.* to scanner@localhost identified by ‘scanner’;
Query OK, 0 rows affected, 1 warning (0.01 sec)