mysql.sock does not exist error in fresh install of MySQL on Arch Linux

mysql mariadb archlinux mysql.sock
tino picture tino · Jun 7, 2016 · Viewed 8.7k times · Source

I'm trying to use MySQL on Arch Linux. it is already installed but this error comes up when I try to connect:

connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory")'

I've looked for /etc/my.cfg but the file does not exist. Something must have gone wrong during the installation. How can I "purge" MariaDB and reinstall it?

Answer

grochmal picture grochmal · Jun 8, 2016

If you're using archlinux it is a vital idea to understand the package manager (pacman). For the question about /etc/my.cfg you can run

pacman -Ql mariadb

there you will see that the file is actually called:

/etc/mysql/my.cnf

Arch linux will not configure the package for you, that is part of the arch philosophy. It will provide example configurations, and even provide you with a systemd unit file

usr/lib/systemd/system/mysqld.service

but it is your responsibility to ensure that the configuration is correct and actually start the daemon.

systemctl enable mysqld   # add the unit file to the boot sequence
systemctl start mysqld    # runs ExecStart= in the unit file
systemctl stop mysqld     # kills the daemon
systemctl disable mysqld  # remove unit from boot sequence

reinstall

Since the word reinstall is in the title of the question and someone might find this question thanks to that: To reinstall mariadb you simply do

pacman -S mariadb

pacman will reinstall a package that is already installed, there is no need to remove the package (for completeness, package removal happens with pacman -R)

Related questions

MySQL: Grant **all** privileges on database

I've created database, for example 'mydb'. CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin; CREATE USER 'myuser'@'%' IDENTIFIED BY PASSWORD '*HASH'; GRANT ALL ON mydb.* TO 'myuser'@'%'; GRANT ALL ON mydb TO 'myuser'@'%…

Read More
ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

I have created tables in MySQL Workbench as shown below : ORDRE table: CREATE TABLE Ordre ( OrdreID INT NOT NULL, OrdreDato DATE DEFAULT NULL, KundeID INT DEFAULT NULL, CONSTRAINT Ordre_pk PRIMARY KEY (OrdreID), CONSTRAINT Ordre_fk FOREIGN KEY (KundeID) REFERENCES …

Read More
Cast int to varchar

I have below query and need to cast id to varchar Schema create table t9 (id int, name varchar (55)); insert into t9( id, name)values(2, 'bob'); What I tried select CAST(id as VARCHAR(50)) as col1 from t9; select CONVERT(…

Read More