All geek questions in one place

Error "mysqld dead but pid file exists"

I get the error "mysqld dead, but the pid file exists"

I have an acache web client running on EC2. With WordPress. I started to see a "error in the Databse Connection"

When I execute the mysqld status sudo service I see the error "mysqld dead, but the pid file exists"

Looks like I have enough space

[ root@ip-10-0-0-149 log]# df -h Filesystem Size Used Avail Use% Mounted on /dev/xvda1 7.8G 1.5G 6.3G 19% / devtmpfs 486M 56K 486M 1% /dev tmpfs 499M 0 499M 0% /dev/shm

Also, when I make a tail, I get

  InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140717 21:04:58 InnoDB: Waiting for the background threads to start 140717 21:04:59 InnoDB: 5.5.38 started; log sequence number 6150055 140717 21:04:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140717 21:04:59 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140717 21:04:59 [Note] Server socket created on IP: '0.0.0.0'. 140717 21:04:59 [Note] Event Scheduler: Loaded 0 events 140717 21:04:59 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.38' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

Please, help!

+6
source share
1 answer

in my case, I did this and my problem was resolved.

  cd /var/run/mysqld rm -f mysqld.pid
+5
source

Source: https://habr.com/ru/post/972468/

More articles:


All Articles