Field 'ssl_cipher' doesn't have a default value

mysql 에러

#1364 - Field 'ssl_cipher' doesn't have a default value

 

ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value

 

ERROR 1364 (HY000): Field 'authentication_string' doesn't have a default value

mysql 버전이 높아지면서 사용자 추가시 ssl_cipher, x509_issuer, x509_subject, authentication_string 를 입력 해 주어야 합니다.

 

예)

insert into user (Host, User, Password, ssl_cipher, x509_issuer, x509_subject, authentication_string) values('localhost','사용자명', password('비밀번호'),'','','','');