MySQL버전업 에러 error 1364 hy000 field ssl_cipher doesn t have a default value

Mysql 버전이 높아지면서 보안관련 인한 오류입니다. User 생성시 Host, User ,Password, ssl_cipher, x509_issuer, x509_subject 를 입력 해 주셔야 합니다. ssl_cipher, x509_issuer, x509_subject 값은 ” 빈값을 입력하세요. mysql >INSERT INTO user (host,user,password,ssl_cipher,x509_issuer,x509_subject) -> VALUES(‘localhost’,’user’,password(‘pass’),”,”,”); 아니면 왠지 모를 찝찝한 GRANT 처리 mysql >GRANT SELECT , INSERT , UPDATE , DELETE , DROP , CREATE -> ON database…

MySQL 캐릭터셋 변경

MySQL 접속테스트 [@localhost~]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may…