[讨论中] greatsql 的默认socket文件和网页推荐配置偏差的问题

87 1 2024-11-27 18:02

这是great-init.sh里的命令

SOCKET="$(_get_config 'socket' "$@")"
      "$@" --skip-networking --socket="${SOCKET}" &
      pid="$!"

推荐socket配置为socket = /data/GreatSQL/mysql.sock

下面是加上了socket 和datadir变量后的报错，

/greatsql-init.sh: running /docker-entrypoint-initdb.d/init.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/data/GreatSQL/mysql.sock' (2)

正常启动的如下：不加能正常启动，因为跳过了greatsql-init.sh里初始化的过程
但是没有mysql.sock？？？？？？

bash-4.4# cd data/GreatSQL
bash-4.4# ls
'#file_purge'       binlog.000001 client-cert.pem ibdata1          mysql.sock.lock    slow.log
'#ib_16384_0.dblwr' binlog.000002 client-key.pem ibtmp1          performance_schema sys
'#ib_16384_1.dblwr' binlog.000003 duckdb.data    innodb_status.1 private_key.pem    undo_001
'#innodb_redo'       binlog.index duckdb.data.wal mysql          public_key.pem    undo_002
'#innodb_temp'       ca-key.pem    error.log       mysql.ibd       server-cert.pem
auto.cnf          ca.pem       ib_buffer_pool mysql.pid       server-key.pem
bash-4.4# cat mysql.lock
cat: mysql.sock: No such file or directory

根本就没有socket变量设置的mysql.lock，只有mysql.sock.lock???
是我哪里搞错了嘛？

GreatSQL, Docker

全部回复(1)

只看楼主