password 썸네일형 리스트형 [Docker] Run Mysql Server container and setup # Make Data folders for mysql volumnmkdir /data # Run mysql container docker run \-p 3306:3306 \--name mysql_server \-v /data:/var/lib/mysql \-e MYSQL_ROOT_PASSWORD={{SERVER ROOT}} \-e MYSQL_USER={{USER_ID}} \-e MYSQL_PASSWORD={{USER_PASSWORD}}} \-e TZ='{{TIMEZONE}}' \-d mysql:8.0.13 # Got error with message "MySQL 8.0 - Client does not support authentication protocol requested by server; consid.. 더보기 [MySQL] root password 설정 mysqladmin -u root password '변경암호' mysqladmin -u root -p기존암호 password '변경암호' 더보기 [MySQL] Charset 설정 etc/my.cnf (또는 my.ini) 에서 캐릭터셋 수정 [client] #password = your_password default-character-set=utf8 [mysqld] init_connect=SET collation_connection = utf8_general_ci init_connect=SET NAMES utf8 character-set-server=utf8 collation-server=utf8_general_ci [mysql] default-character-set=utf8 더보기 이전 1 다음