MYSQL error 2002 how to solve the problem?

Question

MYSQL error 2002 how to solve the problem?

One day on a production server crashed mysql
phpmyadmin gives error 2002
access to the system via ssh.
Conclusions are such

ps -ea |grep mysql
 1090 ? 00:00:00 mysqld_safe
 1477 ? 11:50:43 mysqld

/etc/init.d/mysqld stop
bash: /etc/init.d/mysqld: No such file or directory

systemctl start mysqld.service
Failed to issue method call: Unit mysqld.service failed to load: No such file or directory. See system logs and 'systemctl status mysqld.service' for details.

systemctl status mysqld.service
mysqld.service
 Loaded: error (Reason: No such file or directory)
 Active: inactive (dead)

systemctl status mysql.service
mysql.service - LSB: Start the MySQL database server
 Loaded: loaded (/etc/init.d/mysql)
 Active: failed (Result: timeout) since Wed, 29 Jun 2016 16:20:55 +0400; 5min ago
 Process: 29500 ExecStop=/etc/init.d/mysql stop (code=killed, signal=TERM)
 Process: 10422 ExecStart=/etc/init.d/mysql start (code=killed, signal=TERM)
 CGroup: name=systemd:/system/mysql.service

When you write

/etc/init.d/mysql start
redirecting to systemctl

and if hangs.

Google didn't help(

elyssa60 asked July 8th 19 at 11:11

Related questions

More answers about "MYSQL error 2002 how to solve the problem?"

3 answers

Giles_Funk63 answered on · Answer 1 · 2019-07-08T11:13:40.492Z

Giles_Funk63 answered on July 8th 19 at 11:13

The logs of mysql, of course you watched?

Definitely forgot to write, log not(( /var/log/mysql totally empty - elyssa60 commented on July 8th 19 at 11:16

lily.Kozey answered on · Answer 2 · 2019-07-08T11:15:40.492Z

lily.Kozey answered on July 8th 19 at 11:15

>>See system logs and 'systemctl status mysqld.service' for details.
>>Loaded: error (Reason: No such file or directory)
in the fall crashed something from a file, then reinstall only the base separately, drain.
Maybe out of space or quota on disk space.

The fact of the matter is that disks are busy only 5%. Hundreds of gigs of memory free.
So did the reinstallation only? - elyssa60 commented on July 8th 19 at 11:18

: well, not so bad, base, continue, recently, on Habre I read how to raise polyubite base https://habrahabr.ru/post/50064/ - elyssa60 commented on July 8th 19 at 11:21

: I'd merged the binaries of the base, raised muscul at home / work servicce, restored database, then began the manipulation on the primary server reinstallation / lifting base. - lily.Kozey commented on July 8th 19 at 11:24

I do not know what, but it all turned out.
yast during the night did nothing (yast2 -i mysql mysql-client)
in the morning rebutnul server (shutdown-r now)
something went wrong and it shut off
after enabling it worked. - lily.Kozey commented on July 8th 19 at 11:27

elyssa60 answered on · Answer 3 · 2019-07-08T11:17:40.492Z

df-ah
Filesystem Size Used Available Used% Mounted
rootfs 273G 11G 248G 5% /
devtmpfs is 7.9 G 20K and 7.9 G 1% /dev
tmpfs 7,9 G 0 7,9 G 0% /dev/shm
tmpfs 7,9 G 924K of 7.9 G 1% /run
devpts 0 0 0 - /dev/pts
/dev/sda2 273G 11G 248G 5% /
proc 0 0 0 - /proc
sysfs 0 0 0 - /sys
tmpfs 7,9 G 0 7,9 G 0% /sys/fs/cgroup
cgroup 0 0 0 - /sys/fs/cgroup/systemd
cgroup 0 0 0 - /sys/fs/cgroup/cpuset
cgroup 0 0 0 - /sys/fs/cgroup/cpu,cpua cct
cgroup 0 0 0 - /sys/fs/cgroup/memory
cgroup 0 0 0 - /sys/fs/cgroup/devices
cgroup 0 0 0 - /sys/fs/cgroup/freezer
cgroup 0 0 0 - /sys/fs/cgroup/net_cls controller is mounted
cgroup 0 0 0 - /sys/fs/cgroup/blkio
cgroup 0 0 0 - /sys/fs/cgroup/perf_eve nt
systemd-1 0 0 0 - /proc/sys/fs/binfmt_mis c
tmpfs 7,9 G 924K of 7.9 G 1% /var/lock
tmpfs 7,9 G 924K of 7.9 G 1% /var/run
securityfs 0 0 0 - /sys/kernel/security
hugetlbfs 0 0 0 - /dev/hugepages
debugfs 0 0 0 - /sys/kernel/debug
mqueue 0 0 0 - /dev/mqueue
tmpfs 7,9 G 0 7,9 G 0% /media
/dev/sdb1 549G 331M 521G 1% /home
none 0 0 0 - /var/lib/ntp/proc
gvfs-fuse-daemon 0 0 0 - /run/user/apeks/gvfs
fusectl 0 0 0 - /sys/fs/fuse/connection s
binfmt_misc 0 0 0 - /proc/sys/fs/binfmt_mis