greatSQL安装后启动时报错
按照文档中安装指南-二进制包安装-ubuntu环境安装greatSQL8.0.32-27，systemctl启动时报如下错误：× greatsql.service - GreatSQL Server
Loaded: loaded (/etc/systemd/system/greatsql.service; disabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Wed 2025-06-18 19:34:31 CST; 1min 46s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 2609 ExecStartPre=/usr/local/GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Process: 2636 ExecStart=/usr/local/GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64/bin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Main PID: 2636 (code=exited, status=1/FAILURE)
Status: "Server shutdown complete"
Error: 13 (Permission denied)
CPU: 241ms
6月 18 19:34:31 yui-virtual-machine mysqld: 2025-06-18T11:34:31.737950Z 0 Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
6月 18 19:34:31 yui-virtual-machine mysqld: 2025-06-18T11:34:31.737953Z 0 Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
6月 18 19:34:31 yui-virtual-machine mysqld: 2025-06-18T11:34:31.737994Z 0 /usr/local/GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64/bin/mysqld (mysqld 8.0.32-27) starting as process 2636
6月 18 19:34:31 yui-virtual-machine mysqld: 2025-06-18T11:34:31.740091Z 0 Can't create test file /usr/local/GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64/data/mysqld_tmp_file_case_insensitive_test.lower-test
6月 18 19:34:31 yui-virtual-machine mysqld: mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
6月 18 19:34:31 yui-virtual-machine mysqld: 2025-06-18T11:34:31.740523Z 0 Aborting
6月 18 19:34:31 yui-virtual-machine mysqld: 2025-06-18T11:34:31.740606Z 0 /usr/local/GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64/bin/mysqld: Shutdown complete (mysqld 8.0.32-27)GreatSQL, Release 27, Revision aa66a385910.
6月 18 19:34:31 yui-virtual-machine systemd: greatsql.service: Main process exited, code=exited, status=1/FAILURE
6月 18 19:34:31 yui-virtual-machine systemd: greatsql.service: Failed with result 'exit-code'.
6月 18 19:34:31 yui-virtual-machine systemd: Failed to start GreatSQL Server.
应该如何解决？
看起来是datadir目录的权限没设置正确，详见日志内容
6月 18 19:34:31 yui-virtual-machine mysqld: mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
还请严格按照我们手册内容操作，参考 https://greatsql.cn/docs/8.0.32-27/4-install-guide/3-2-ubuntu-install.html yejr 发表于 2025-6-25 11:04
看起来是datadir目录的权限没设置正确，详见日志内容
按照手册使用root执行了下列相应的指令，不解决此问题
mkdir -p /data/GreatSQL
chown -R mysql:mysql /data/GreatSQL
chmod -R 700 /data/GreatSQL
sdcx 发表于 2025-6-25 19:16
按照手册使用root执行了下列相应的指令，不解决此问题
mkdir -p /data/GreatSQL
不解决此问题？ yejr 发表于 2025-6-26 08:10
不解决此问题？
是的，解决不了 从报错看，和你的目录权限及属主设置有关。你的GLIBC版本是匹配的吧 sdcx 发表于 2025-6-26 22:32
是的，解决不了
那就继续贴相应的错误日志和操作过程 reddey 发表于 2025-6-27 09:00
从报错看，和你的目录权限及属主设置有关。你的GLIBC版本是匹配的吧
glibc 2.35，和文档是一样的 yejr 发表于 2025-6-27 09:21
那就继续贴相应的错误日志和操作过程
破案了，my.cnf有点问题，修正之后就正常了 sdcx 发表于 2025-6-27 23:35
破案了，my.cnf有点问题，修正之后就正常了
厉害，加油。
页:
[1]
2