You are not logged in.
I left for a few days come back and this occurred.
Can't login to phpMyAdmin get this error #2002 - No such file or directory — The server is not responding (or the local server's socket is not correctly configured).
Everything worked fine till 2 days ago according to my logs. So here is what I seem I have to come down to I need to restart the service which I have tried. I can stop it but if I try to start again I get time out errors. for clarity here are the commands I used.
sudo systemctl stop mysqld.service
sudo systemctl start mysqld.service
Below is my status but in honesty it doesn't actually mean much to me. Any advice would be great I need to get it at least to a point where I can copy all the databases if nothing else.
● mysqld.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: activating (start-post) (Result: exit-code) since Sun 2016-04-17 00:11:26 CEST; 1min 4s ago
Process: 2483 ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
Main PID: 2483 (code=exited, status=1/FAILURE); : 2484 (mysqld-post)
Tasks: 2 (limit: 512)
CGroup: /system.slice/mysqld.service
└─control
├─2484 /bin/sh /usr/bin/mysqld-post
└─2941 sleep 1
Apr 17 00:11:27 mysqld[2483]: 2016-04-17 0:11:27 140010887559040 [Note] InnoDB: Waiting for purge to start
Apr 17 00:11:27 mysqld[2483]: 2016-04-17 0:11:27 140010887559040 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 18411414723
Apr 17 00:11:27 mysqld[2483]: 2016-04-17 0:11:27 140010460280576 [Note] InnoDB: Dumping buffer pool(s) not yet started
Apr 17 00:11:27 mysqld[2483]: 2016-04-17 0:11:27 140010887559040 [Note] Plugin 'FEEDBACK' is disabled.
Apr 17 00:11:27 mysqld[2483]: 2016-04-17 0:11:27 140010887559040 [Note] Recovering after a crash using tc.log
Apr 17 00:11:27 mysqld[2483]: 2016-04-17 0:11:27 140010887559040 [Note] Starting crash recovery...
Apr 17 00:11:27 mysqld[2483]: 2016-04-17 0:11:27 140010887559040 [Note] Crash recovery finished.
Apr 17 00:11:27 mysqld[2483]: 2016-04-17 0:11:27 140010887559040 [Note] Server socket created on IP: '::'.
Apr 17 00:11:27 mysqld[2483]: 2016-04-17 0:11:27 140010887559040 [ERROR] mysqld: Table './mysql/db' is marked as crashed and last (automatic?) repair failed
Apr 17 00:11:28 systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
Last edited by Arch-Hoochie (2016-04-17 11:31:03)
Offline
Okay after a pot of coffee I managed to fix it. Still not sure what caused the initial issue but this is how I fixed it incase anyone else runs into this.
https://wiki.archlinux.org/index.php/My … nnot_start
Followed that section resetting the root password to what it was and doing a table check fixed it.
Offline