docker-compose部署mysql8的登录问题

标签：compose 登录 mysql8 -- location docker

之前docker-compose部署mysql8的时候密码设置好，第一次启动容器，登录密码不对，需要登录容器跳过密码，重新修改密码启动，就研究了以下 ，就几个问题就弄好了

docker-compose.yaml文件中

environment:
MYSQL_ROOT_PASSWORD: 123456

#不能是MYSQL_ROOT_PASSWORD=123456，意思是不能是等于，估计涉及到底层逻辑，有研究的老哥可以说下。

command:

#这个参数一定要有，其他看需求

      --default-authentication-plugin=mysql_native_password

      --character-set-server=utf8mb4

      --collation-server=utf8mb4_general_ci

      --explicit_defaults_for_timestamp=true

      --lower_case_table_names=1

      --sql_mode="STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"

 

这样就可以配置好，就可以直接远程登录。

TRANSLATE with x English

Arabic	Hebrew	Polish
Bulgarian	Hindi	Portuguese
Catalan	Hmong Daw	Romanian
Chinese Simplified	Hungarian	Russian
Chinese Traditional	Indonesian	Slovak
Czech	Italian	Slovenian
Danish	Japanese	Spanish
Dutch	Klingon	Swedish
English	Korean	Thai
Estonian	Latvian	Turkish
Finnish	Lithuanian	Ukrainian
French	Malay	Urdu
German	Maltese	Vietnamese
Greek	Norwegian	Welsh
Haitian Creole	Persian

  TRANSLATE with COPY THE URL BELOW Back EMBED THE SNIPPET BELOW IN YOUR SITE Enable collaborative features and customize widget: Bing Webmaster Portal Back

标签：compose,登录,mysql8,--,location,docker
From： https://www.cnblogs.com/renjianle/p/17192523.html