Introduction to VPS and Web Technology Development

mysql 使用docker 安装后报以下错误的解决方案

自由vps 数据库
[root@localhost ~]# docker logs f3382f5c55ce
2023-03-30 22:35:58+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.27-1debian10 started.
2023-03-30 22:35:58+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-03-30 22:35:58+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.27-1debian10 started.
2023-03-30 22:35:59+00:00 [Note] [Entrypoint]: Initializing database files
2023-03-30T22:35:59.052584Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.27) initializing of server in progress as process 40
2023-03-30T22:35:59.059378Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-03-30T22:35:59.581185Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-03-30T22:36:00.762536Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2023-03-30T22:36:00.762556Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2023-03-30T22:36:00.831538Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2023-03-30 22:36:03+00:00 [Note] [Entrypoint]: Database files initialized
2023-03-30 22:36:03+00:00 [Note] [Entrypoint]: Starting temporary server
2023-03-30T22:36:04.224096Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27) starting as process 87
2023-03-30T22:36:04.299946Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-03-30T22:36:05.140880Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-03-30T22:36:05.692774Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2023-03-30T22:36:05.692811Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2023-03-30T22:36:05.693734Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-03-30T22:36:05.693800Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-03-30T22:36:05.694745Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2023-03-30T22:36:05.712603Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock





2023-03-30T22:36:05.712694Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.27'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
2023-03-30 22:36:05+00:00 [Note] [Entrypoint]: Temporary server started.
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.

2023-03-30 22:36:08+00:00 [Note] [Entrypoint]: Stopping temporary server
2023-03-30T22:36:08.110452Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.27).
2023-03-30T22:36:08.983119Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27)  MySQL Community Server - GPL.
2023-03-30 22:36:09+00:00 [Note] [Entrypoint]: Temporary server stopped

2023-03-30 22:36:09+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.

2023-03-30T22:36:09.379430Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27) starting as process 1
2023-03-30T22:36:09.397453Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-03-30T22:36:09.528448Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-03-30T22:36:09.684134Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2023-03-30T22:36:09.684156Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2023-03-30T22:36:09.685224Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-03-30T22:36:09.685292Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-03-30T22:36:09.686041Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2023-03-30T22:36:09.704495Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-03-30T22:36:09.704809Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.27'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2023-03-30T22:39:40.983764Z 11 [Warning] [MY-010604] [Repl] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=f3382f5c55ce-relay-bin' to avoid this problem.
2023-03-30T22:39:40.986971Z 11 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='mysql-master', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.



解决方案:


docker start 对应容器 强制启动

使用chatGPT寻求答案
标签: 暂无标签

免责声明:

本站提供的资源,都来自网络,版权争议与本站无关,所有内容及软件的文章仅限用于学习和研究目的。不得将上述内容用于商业或者非法用途,否则,一切后果请用户自负,我们不保证内容的长久可用性,通过使用本站内容随之而来的风险与本站无关,您必须在下载后的24个小时之内,从您的电脑/手机中彻底删除上述内容。如果您喜欢该程序,请支持正版软件,购买注册,得到更好的正版服务。侵删请致信E-mail:master@freevpsweb.com

同类推荐
评论列表