查看镜像 docker search mysql 拉取镜像 docker pull mysql 查看当前拥有的镜像 docker images 实例化镜像并运行 docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root -d mysql 查看正在运行的docker docker ps
mysql Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
以下版本会出现连接ssl错误
1 2 3 4 5
GlarcydeMacBook-Pro:blog glarcy$ mysql -V mysql Ver 14.14 Distrib 5.7.26, for macos10.14 (x86_64) using EditLine wrapper GlarcydeMacBook-Pro:blog glarcy$ mysql -h 192.168.x.x -uroot -p Enter password: ERROR 2026 (HY000): SSL connection error: unknown error number
查看mysql中的ssl配置
1 2 3 4 5 6 7 8 9 10 11
mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed mysql> SHOW VARIABLES like '%ssl%'; +-------------------------------------+-----------------+ | Variable_name | Value | +-------------------------------------+-----------------+ | have_openssl | YES | | have_ssl | YES |
关闭ssl,修改/etc/mysql/my.cnf文件,添加如下配置
1 2
[mysqld] skip_ssl
重启docker,可以看到配置已被修改
1 2 3 4 5 6
mysql> SHOW VARIABLES like '%ssl%'; +-------------------------------------+----------+ | Variable_name | Value | +-------------------------------------+----------+ | have_openssl | DISABLED | | have_ssl | DISABLED |
评论