Docker - MySQL Database is uninitialized and password option is not sp
问题形貌docker run --name=master -p 3306:3306 -d mysql 2022-11-11 08:03:05+00:00 : Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2022-11-11 08:03:05+00:00 : Switching to dedicated user 'mysql'
2022-11-11 08:03:05+00:00 : Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2022-11-11 08:03:05+00:00 : Database is uninitialized and password option is not specified
You need to specify one of the following as an environment variable:
- MYSQL_ROOT_PASSWORD
- MYSQL_ALLOW_EMPTY_PASSWORD
- MYSQL_RANDOM_ROOT_PASSWORD
原因分析
启动时候没有设置环境变量密码
解决方案
docker run --name=master -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql
[*]假如用的是 GUI 界面，可以在环境变量那里设置 KV
[*]启动乐成结果如下日记
2022-11-11 08:04:29+00:00 : Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2022-11-11 08:04:29+00:00 : Switching to dedicated user 'mysql'
2022-11-11 08:04:29+00:00 : Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2022-11-11 08:04:29+00:00 : Initializing database files
2022-11-11T08:04:29.772339Z 0 The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2022-11-11T08:04:29.772424Z 0 /usr/sbin/mysqld (mysqld 8.0.31) initializing of server in progress as process 80
2022-11-11T08:04:29.777358Z 1 InnoDB initialization has started.
2022-11-11T08:04:33.614888Z 1 InnoDB initialization has ended.
2022-11-11T08:04:37.621895Z 6 root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2022-11-11 08:04:41+00:00 : Database files initialized
2022-11-11 08:04:41+00:00 : Starting temporary server
2022-11-11T08:04:42.321690Z 0 The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2022-11-11T08:04:42.341394Z 0 /usr/sbin/mysqld (mysqld 8.0.31) starting as process 131
2022-11-11T08:04:42.401390Z 1 InnoDB initialization has started.
2022-11-11T08:04:45.844897Z 1 InnoDB initialization has ended.
2022-11-11T08:04:46.575024Z 0 CA certificate ca.pem is self signed.
2022-11-11T08:04:46.575058Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-11-11T08:04:46.575741Z 0 Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2022-11-11T08:04:46.584621Z 0 X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2022-11-11T08:04:46.584640Z 0 /usr/sbin/mysqld: ready for connections. Version: '8.0.31'socket: '/var/run/mysqld/mysqld.sock'port: 0MySQL Community Server - GPL.
2022-11-11 08:04:46+00:00 : Temporary server started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' 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.
2022-11-11 08:04:50+00:00 : Stopping temporary server
2022-11-11T08:04:50.284571Z 10 Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.31).
2022-11-11T08:04:51.346488Z 0 /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31)MySQL Community Server - GPL.
2022-11-11 08:04:52+00:00 : Temporary server stopped
2022-11-11 08:04:52+00:00 : MySQL init process done. Ready for start up.
2022-11-11T08:04:52.504332Z 0 The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2022-11-11T08:04:52.505313Z 0 /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1
2022-11-11T08:04:52.509649Z 1 InnoDB initialization has started.
2022-11-11T08:04:52.625646Z 1 InnoDB initialization has ended.
2022-11-11T08:04:52.755430Z 0 CA certificate ca.pem is self signed.
2022-11-11T08:04:52.755480Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-11-11T08:04:52.756754Z 0 Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2022-11-11T08:04:52.770087Z 0 X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2022-11-11T08:04:52.770112Z 0 /usr/sbin/mysqld: ready for connections. Version: '8.0.31'socket: '/var/run/mysqld/mysqld.sock'port: 3306MySQL Community Server - GPL.
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页:
[1]