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 /run/mysqld/
//~nothing~
[me@my-laptop ~]$