MariaDB setup / Missing mysqld.sock

Off-topic
1

I am trying to install and use MariaDB (MySQL) on my laptop running Manjaro. Whenever I try to log on to MariaDB it tells me “ERROR 2002 (HY000): Can’t connect to local server through socket ‘/run/mysqld/mysqld.sock’ (2)” been trying with search engine and language models for hours but no cigar, as well as several reinstalls.

Any ideas on how to move forwards?

Including some terminal snippets that I think might be useful. added me own notes like this: //~note~

[me@my-laptop mysqld]$ sudo systemctl restart mariadb.service

[me@my-laptop mysqld]$ sudo journalctl -xe | grep mariadb

[me@my-laptop]
//~removed everything from before the restart~
sep 18 19:21:54 my-laptop dbus-daemon[478]: [system] Activating via systemd: service name='org.freedesktop.home1' unit='dbus-org.freedesktop.home1.service' requested by ':1.297' (uid=0 pid=13486 comm="sudo systemctl restart mariadb.service")
sep 18 19:21:54 my-laptop sudo[13486]: me : TTY=pts/2 ; PWD=/run/mysqld ; USER=root ; COMMAND=/usr/bin/systemctl restart mariadb.service
░░ Subject: A stop job for unit mariadb.service has begun execution
░░ A stop job for unit mariadb.service has begun execution.
sep 18 19:21:54 my-laptop mariadbd[13180]: 2023-09-18 19:21:54 0 [Note] /usr/bin/mariadbd (initiated by: unknown): Normal shutdown
sep 18 19:21:54 my-laptop mariadbd[13180]: 2023-09-18 19:21:54 0 [Note] InnoDB: FTS optimize thread exiting.
sep 18 19:21:55 my-laptop mariadbd[13180]: 2023-09-18 19:21:55 0 [Note] InnoDB: Starting shutdown...
sep 18 19:21:55 my-laptop mariadbd[13180]: 2023-09-18 19:21:55 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
sep 18 19:21:55 my-laptop mariadbd[13180]: 2023-09-18 19:21:55 0 [Note] InnoDB: Buffer pool(s) dump completed at 230918 19:21:54
sep 18 19:21:55 my-laptop mariadbd[13180]: 2023-09-18 19:21:55 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
sep 18 19:21:55 my-laptop mariadbd[13180]: 2023-09-18 19:21:55 0 [Note] InnoDB: Shutdown completed; log sequence number 47679; transaction id 18
sep 18 19:21:55 my-laptop mariadbd[13180]: 2023-09-18 19:21:55 0 [Note] /usr/bin/mariadbd: Shutdown complete
sep 18 19:21:55 my-laptop systemd[1]: mariadb.service: Deactivated successfully.
░░ The unit mariadb.service has successfully entered the 'dead' state.
░░ Subject: A stop job for unit mariadb.service has finished
░░ A stop job for unit mariadb.service has finished.
░░ Subject: A start job for unit mariadb.service has begun execution
░░ A start job for unit mariadb.service has begun execution.
sep 18 19:21:55 my-laptop (mariadbd)[13534]: mariadb.service: Referenced but unset environment variable evaluates to an empty string: MYSQLD_OPTS, _WSREP_NEW_CLUSTER
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] Starting MariaDB 11.1.2-MariaDB source revision 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5 as process 13534
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Compressed tables use zlib 1.3
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Number of transaction pools: 1
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Using liburing
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Completed initialization of buffer pool
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: End of log at LSN=47679
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Opened 3 undo tablespaces
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: log sequence number 47679; transaction id 17
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] Plugin 'wsrep-provider' is disabled.
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Buffer pool(s) load completed at 230918 19:21:55
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] Server socket created on IP: '0.0.0.0'.
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] Server socket created on IP: '::'.
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] /usr/bin/mariadbd: ready for connections.
sep 18 19:21:55 my-laptop mariadbd[13534]: Version: '11.1.2-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Arch Linux
░░ Subject: A start job for unit mariadb.service has finished successfully
░░ A start job for unit mariadb.service has finished successfully.

[me@my-laptop mysqld]$ sudo systemctl status mariadb.service
[sudo] password for me: 
● mariadb.service - MariaDB 11.1.2 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; preset: disabled)
     Active: active (running) since Mon 2023-09-18 19:21:55 CEST; 9min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 13494 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 13496 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemct>
    Process: 13560 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
   Main PID: 13534 (mariadbd)
     Status: "Taking your SQL requests now..."
      Tasks: 8 (limit: 11845)
     Memory: 273.8M
        CPU: 310ms
     CGroup: /system.slice/mariadb.service
             └─13534 /usr/bin/mariadbd

sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: log sequence number 47679; transaction id 17
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] Plugin 'wsrep-provider' is disabled.
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] InnoDB: Buffer pool(s) load completed at 230918 19:21:55
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] Server socket created on IP: '0.0.0.0'.
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] Server socket created on IP: '::'.
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55 0 [Note] /usr/bin/mariadbd: ready for connections.
sep 18 19:21:55 my-laptop mariadbd[13534]: Version: '11.1.2-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Arch Linux
sep 18 19:21:55 my-laptop systemd[1]: Started MariaDB 11.1.2 database server.[me@my-laptop mysqld]$ mariadb -u root -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)

[me@my-laptop ~]$ journalctl -xeu mariadb.service
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: 2023-09-18 19:21:55>
sep 18 19:21:55 my-laptop mariadbd[13534]: Version: '11.1.2-Ma>
sep 18 19:21:55 my-laptop systemd[1]: Started MariaDB 11.1.2 d>
░░ Subject: A start job for unit mariadb.service has finished successfully
░░ Defined-By: systemd
░░ Support: https://forum.manjaro.org/c/support
░░ 
░░ A start job for unit mariadb.service has finished successfully.
░░ 
░░ The job identifier is 4748.

[me@my-laptop ~]$ ls -la /run/mysqld/
total 0
drwxr-xr-x  2 mysql mysql  40 19 sep 16.04 .
drwxr-xr-x 29 root  root  680 19 sep 16.04 ..

[me@my-laptop ~]$ mariadb -u root -p -h localhost -P 3306
Enter password: 
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

[me@my-laptop ~]$
2

I’ve had the same issue and couldn’t really track the exact reason, but it happend after I played around with a mysql docker container.

You might be able to fire up the mysql process by moving the old aria_log_control file.

$ sudo mv /var/lib/mysql/aria_log_control /var/lib/mysql/aria_log_control.orig
$ sudo systemctl start mysql

You can then backup your databases and try the following

cd /var/lib/mysql
rm -r *
mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
systemctl start mysql