ENCODE-DCC/caper

Setting up MYSQL Metadata database - Unable connect to local MySQL server through socket

sfpacman opened this issue · 1 comments

I follow the instruction to set up MYSQL by running the run_mysql_server_singularity.sh, but I keep getting this error.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
All done. You can ignore any error messages occurred when creating a user (ERROR 1007).

I think it has something to do with that - I tried to set the file permission manually but it doesn't seem to do anything.

2021-10-14T22:24:35.676812Z 0 [Note] Execution of init_file '/home/dummy/.mysqlrootpw' started.
2021-10-14T22:24:35.676842Z 0 [ERROR] mysqld: File '/home/dummy/.mysqlrootpw' not found (Errcode: 13 - Permission denied)
2021-10-14T22:24:35.676847Z 0 [ERROR] Aborting

It's hard to debug. Can you try with the docker version instead?