Paul …
Thanks for the 24 hours explanation.
My unix_socket is ACTIVE per below …
| unix_socket | ACTIVE | AUTHENTICATION | NULL | GPL |
However, unlike you, I do not have the required /var/run/mysqld/mysqld.sock
pi@watchman:/var/run/mysqld $ ls -la /var/run/mysqld/mysqld.sock
ls: cannot access '/var/run/mysqld/mysqld.sock': No such file or directory
Lucky googling - I stumbled across this …
EDIT: A really good way of finding the location of the socket file is:
netstat -ln | grep mysql
unix 2 [ ACC ] STREAM LISTENING 22418 /var/lib/mysql/mysql.sock
So I tried it …
pi@watchman:/etc/cron.monthly $ netstat -ln | grep mysql
which gave the following result …
unix 2 [ ACC ] STREAM LISTENING 13879 /home/pi/data/mysql/mysql.sock
So I hunted further - see third from the bottom …
pi@watchman:/etc/cron.monthly $ cd /home/pi/data/mysql
pi@watchman:~/data/mysql $ ls -al
total 110776
drwxrwxrwx 5 mysql mysql 4096 Feb 7 02:24 .
drwxrwxrwx 10 pi pi 4096 Feb 7 02:15 ..
-rw-rw---- 1 mysql mysql 16384 Feb 7 01:15 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Feb 7 01:15 aria_log_control
-rw-r--r-- 1 mysql mysql 0 Aug 17 15:27 debian-10.1.flag
drwx------ 2 mysql mysql 4096 Feb 6 23:54 emoncms
-rw-rw---- 1 mysql mysql 12582912 Feb 7 02:24 ibdata1
-rw-rw---- 1 mysql mysql 50331648 Feb 7 02:24 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Aug 17 15:28 ib_logfile1
-rw-rw---- 1 mysql mysql 0 Aug 17 15:29 multi-master.info
drwx------ 2 mysql mysql 4096 Aug 17 15:28 mysql
srwxrwxrwx 1 mysql mysql 0 Feb 7 02:24 mysql.sock
drwx------ 2 mysql mysql 4096 Aug 17 15:28 performance_schema
-rw-rw---- 1 mysql mysql 24576 Feb 7 02:24 tc.log
In my ignorance I tried to sudo cp from there to /var/run/mysqld/mysqld.sock - but that’s not allowed.
Is there a way to link both?