GreatSQL 8.0.32-25 执行初始化数据库命令报错
执行的命令:
# mysqld --initialize-insecuret
报错内容如下:
[root@g8213 data]# cat log/mysqld.log
2024-05-22T03:11:55.653596Z 0 [Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
2024-05-22T03:11:55.653650Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2024-05-22T03:11:55.653656Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2024-05-22T03:11:55.653722Z 0 [System] [MY-010116] [Server] /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64-minimal/bin/mysqld (mysqld 8.0.32-25) starting as process 2813
2024-05-22T03:11:55.663803Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0b53d695-17e9-11ef-b475-005056abc0a1.
2024-05-22T03:11:55.668214Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-22T03:11:55.668351Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-22T03:11:55.668382Z 0 [ERROR] [MY-010119] [Server] Aborting
解决办法:
执行如下初始化命令:
# mysqld --initialize --console
日志如下:
2024-05-22T03:12:39.996064Z 0 [System] [MY-010910] [Server] /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64-minimal/bin/mysqld: Shutdown complete (mysqld 8.0.32-25) GreatSQL, Release 25, Revision db07cc5cb73.
2024-05-22T03:13:30.044751Z 0 [Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
2024-05-22T03:13:30.044926Z 0 [System] [MY-013169] [Server] /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64-minimal/bin/mysqld (mysqld 8.0.32-25) initializing of server in progress as process 2867
2024-05-22T03:13:30.059158Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-05-22T03:13:30.381192Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-05-22T03:13:31.444588Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: w<luMosk<4d7
该案例暂时没有网友评论
✖
案例意见反馈
亲~登录后才可以操作哦!
确定你的邮箱还未认证,请认证邮箱或绑定手机后进行当前操作