Docker mysql容器修改配置文件后无法启动

阳光穿透心脏的1/2处 2022-08-28 15:57 734阅读 0赞

情景复现:  
在docker中修改了mysql容器的配置文件/etc/mysql/my.cnf , 修改后发现mysql容器无法启动了,想要修改回来,提示容器未启动,怎么办呢?  
1.使用`docker logs mysql(容器名)` 命令查看日志

2021-09-11  3:28:33 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    2021-09-11  3:28:33 0 [Note] Server socket created on IP: '0.0.0.0'.
    2021-09-11  3:28:33 0 [Note] Server socket created on IP: '::'.
    2021-09-11  3:28:33 0 [Warning] 'proxies_priv' entry '@% root@dd5900c854cc' ignored in --skip-name-resolve mode.
    2021-09-11  3:28:33 0 [Note] InnoDB: Buffer pool(s) load completed at 210911  3:28:33
    2021-09-11  3:28:33 0 [Note] mysqld: ready for connections. Version: '10.6.1-MariaDB-1:10.6.1+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
    2021-09-11  3:42:41 0 [Note] mysqld (initiated by: unknown): Normal shutdown
    2021-09-11  3:42:41 0 [Note] InnoDB: FTS optimize thread exiting.
    2021-09-11  3:42:41 0 [Note] InnoDB: Starting shutdown...
    2021-09-11  3:42:41 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
    2021-09-11  3:42:41 0 [Note] InnoDB: Buffer pool(s) dump completed at 210911  3:42:41
    2021-09-11  3:42:41 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
    2021-09-11  3:42:41 0 [Note] InnoDB: Shutdown completed; log sequence number 50479152; transaction id 88220
    2021-09-11  3:42:41 0 [Note] mysqld: Shutdown complete
    
    2021-09-11 03:42:42+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.1+maria~focal started.
    2021-09-11 03:42:42+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
            command was: mysqld --verbose --help --log-bin-index=/tmp/tmp.IRcuAM2GSh
            Warning: World-writable config file '/etc/mysql/mariadb.conf.d/50-server.cnf' is ignored
    2021-09-11  3:42:42 0 [ERROR] The server option 'lower_case_table_names' is configured to use case sensitive table names but the data directory resides on a case-insensitive file system. Please use a case sensitive file system for your data directory or switch to a case-insensitive table name mode.
    2021-09-11 03:44:44+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.1+maria~focal started.
    2021-09-11 03:44:44+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
            command was: mysqld --verbose --help --log-bin-index=/tmp/tmp.Llk7rI0bON
            Warning: World-writable config file '/etc/mysql/mariadb.conf.d/50-server.cnf' is ignored
    2021-09-11  3:44:44 0 [ERROR] The server option 'lower_case_table_names' is configured to use case sensitive table names but the data directory resides on a case-insensitive file system. Please use a case sensitive file system for your data directory or switch to a case-insensitive table name mode.

这里是由于我改了`lower_case_table_names`参数 启动报错了所以没有启动成功

1.  解决方案:  
    将mysql.cnf复制到本地,修改后再覆盖原文件

docker cp mysql:/etc/mysql/my.cnf D:/my.cnf //因为我这里是在windows环境下用的composer 所以是D盘,如果在服务器就自定义其他路径就ok

如果提示`docker A required privilege is not held by the client.` 之类的错误,可以用powershell以管理员身份运行  
![在这里插入图片描述][95f8a2a6e7f842beb666f8883cb237c5.png_pic_center]  
复制过来后发现是个link类型文件并且无法编辑,经过比对其他文件内容发现这个文件指向的是mariadb.cnf,那就复制mariadb.cnf

docker cp mysql:/etc/mysql/mariadb.cnf D:/mariadb.cnf

![在这里插入图片描述][5665b5adc7ea4ccb992642a5d1d31a0a.png_pic_center]

复制完成后的文件是可以编辑的,打开mariadb.cnf 发现确实有之前mysql.cnf修改的内容,修改完成后再复制回去

docker cp D:\mariadb.cnf mysql:/etc/mysql/mariadb.cnf

替换完成后再次尝试启动mysql容器

docker restart mysql  //重启mysql
    docker ps //查看当前运行容器

发现启动成功了,大功告成

[95f8a2a6e7f842beb666f8883cb237c5.png_pic_center]: /images/20220828/714b994458964510bfff7454daf5cb5e.png
[5665b5adc7ea4ccb992642a5d1d31a0a.png_pic_center]: /images/20220828/9be8bd6c66234870a321a1a2e973c943.png