Question
Help solving following error: #2002 - No such file or directory<br />
I’ve searched around the internet for quite some time but have been unable to come up with a working solution. I have a WordPress site set up on a Ubuntu 16.04 LAMP running MySQL. My WP site isn’t working properly (E.g. returning with the “Error establishing a database connection” message when attempting to visit my /wp-admin/ page). I also get the following error when attempting to log into phpMyAdmin: #2002 - No such file or directory<br />The server is not responding (or the local server’s socket is not correctly configured).
Here are the printed results when running systemctl status mysql.service
:
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start-post) (Result: exit-code) since Tue 2018-07-24 17:56:44 UTC; 6s ago
Process: 13857 ExecStart=/usr/sbin/mysqld (code=exited, status=2)
Process: 13847 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 13857 (code=exited, status=2); : 13858 (mysql-systemd-s)
Tasks: 2
Memory: 356.0K
CPU: 318ms
CGroup: /system.slice/mysql.service
└─control
├─13858 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─13886 sleep 1
Jul 24 17:56:44 bcmg-lamp-16-04 systemd[1]: Stopped MySQL Community Server.
Jul 24 17:56:44 bcmg-lamp-16-04 systemd[1]: Starting MySQL Community Server...
Jul 24 17:56:45 bcmg-lamp-16-04 systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
And here are the printed results when running journalctl -xe
:
Jul 24 17:57:14 bcmg-lamp-16-04 systemd[1]: mysql.service: Unit entered failed state.
Jul 24 17:57:14 bcmg-lamp-16-04 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 24 17:57:15 bcmg-lamp-16-04 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Jul 24 17:57:15 bcmg-lamp-16-04 systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Jul 24 17:57:15 bcmg-lamp-16-04 systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Jul 24 17:57:15 bcmg-lamp-16-04 audit[13947]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/13947/status" pid=13947 comm="mysqld" requested_mask="r" denied_
Jul 24 17:57:15 bcmg-lamp-16-04 kernel: audit: type=1400 audit(1532455035.251:67360): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/13947/status" pid=13947 comm
Jul 24 17:57:15 bcmg-lamp-16-04 audit[13947]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=13947 comm="mysqld" requested_mask="r"
Jul 24 17:57:15 bcmg-lamp-16-04 audit[13947]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/13947/status" pid=13947 comm="mysqld" requested_mask="r" denied_
Jul 24 17:57:15 bcmg-lamp-16-04 kernel: audit: type=1400 audit(1532455035.255:67361): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=139
Jul 24 17:57:15 bcmg-lamp-16-04 kernel: audit: type=1400 audit(1532455035.255:67362): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/13947/status" pid=13947 comm
Jul 24 17:57:15 bcmg-lamp-16-04 systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
Jul 24 17:57:24 bcmg-lamp-16-04 sshd[13984]: Received disconnect from 13.56.116.93 port 48842:11: Normal Shutdown, Thank you for playing [preauth]
Jul 24 17:57:24 bcmg-lamp-16-04 sshd[13984]: Disconnected from 13.56.116.93 port 48842 [preauth]
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×