ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I have been getting this from the start.
The log is shorter after chown -R mysql:root /var/run/mysqld and stop / start.
2021-07-11T11:06:42.410162Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T11:06:42.410203Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T11:06:42.411714Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-07-11T11:06:42.411788Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.20.04.1) starting as process 24951
2021-07-11T11:06:42.420985Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-07-11T11:06:42.421191Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-07-11T11:06:42.421294Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T11:06:42.421764Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-0ubuntu0.20.04.1) (Ubuntu).
Could the problem be with the mariaDB config? since it says " [ERROR] [MY-011011] [Server] Failed to find valid data directory."
I have checked several times and as far as I can tell it never created the .pid file either, /var/run/mysqld/mysqld.pid .
Puppy Linux. It just works!
Foassapup 9.5 64-(Frugal) Mobo, M5A99FX PRO - CPU, AMD FX-6300 6 core - mem,32GB - Storage
ssd 128GB M4 - ssd-256GB APS - ssd-1TB PNY - GPU GeForce GTX 1060 GAMING X 6G. Yes it's a Mutt.