其他人都是不正確的

使用mysql容器鏡像可以很快速的運(yùn)行mysql，免去了傳統(tǒng)的虛擬機(jī)安裝方式的繁瑣配置。但是使用官方的mysql鏡像，你會(huì)遇到中文亂碼的問題，原因是官方鏡像的字符集默認(rèn)值不是utf8。這時(shí)候你去google，會(huì)找到一些文章，如這個(gè)哥們的，但是你按照他的做法，還是會(huì)亂碼，這時(shí)候你進(jìn)入mysql查看字符集，發(fā)現(xiàn)是這樣的：

show variables like "%character%";

+--------------------------+----------------------------------+

| Variable_name | Value |

+--------------------------+----------------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | latin1 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | latin1 |

| character_set_system | utf8 |

| character_sets_dir | /usr/local/mysqlarsets/ |

+--------------------------+----------------------------------+

8 rows in set (0.00 sec)

這里才是正確的

好吧，我費(fèi)了不少力氣，才找到正確方法。

首先查看官方鏡像說明，有關(guān)于utf8設(shè)置的參數(shù)：

Many configuration options can be passed as flags to mysqld. This will give you the flexibility to customize the container without needing a cnf file. For example, if you want to change the default encoding and collation for all tables to use UTF-8 (utf8mb4) just run the following:

$ docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

如果只是設(shè)置這兩個(gè)參數(shù)是不夠的，你會(huì)得到這樣的配置：

mysql> show variables like "%character%";

+--------------------------+----------------------------------+

| Variable_name | Value |

+--------------------------+----------------------------------+

| character_set_client | latin1 |

| character_set_connection | latin1 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | latin1 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | /usr/local/mysql/share/charsets/ |

+--------------------------+----------------------------------+

8 rows in set (0.00 sec)

你會(huì)發(fā)現(xiàn)上面那個(gè)哥們的與官方的這個(gè)指導(dǎo)取并集，就是正確的結(jié)果了，所以方法就很簡(jiǎn)單了。查看dockerfile。正確的配置：

mysql> show variables like "%character%";

+--------------------------+----------------------------------+

| Variable_name | Value |

+--------------------------+----------------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | /usr/local/mysql/share/charsets/ |

+--------------------------+----------------------------------+

8 rows in set (0.01 sec)

本文鏈接：http://www.yunweipai.com/23323.html

總結(jié)

以上是生活随笔為你收集整理的dokcer mysql修改编码_默认支持utf8编码的mysql docker镜像的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。