0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

ERROR! MySQL server PID file could not be found!

Posted at
asatokensei@MacBook-Air memopy % mysql.server start
Starting MySQL
......
.^C
asatokensei@MacBook-Air memopy % mysql.server stop 
 ERROR! MySQL server PID file could not be found!

asatokensei@MacBook-Air memopy % ls -la /usr/local/var/mysql/MacBook-Air.local.pid
ls: /usr/local/var/mysql/MacBook-Air.local.pid: No such file or directory

asatokensei@MacBook-Air memopy % mysql.server status
 ERROR! Multiple MySQL running but PID file could not be found (14996 15095 )
asatokensei@MacBook-Air memopy % ps ax | grep mysql
14996 s001  S      0:00.03 /bin/sh /usr/local/Cellar/mysql@5.7/5.7.29/bin/mysqld_safe --datadir=/usr/local/var/mysql --pid-file=/usr/local/var/mysql/MacBook-Air.pid
15095 s001  S      0:05.78 /usr/local/Cellar/mysql@5.7/5.7.29/bin/mysqld --basedir=/usr/local/Cellar/mysql@5.7/5.7.29 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql@5.7/5.7.29/lib/plugin --log-error=MacBook-Air.err --pid-file=/usr/local/var/mysql/MacBook-Air.pid
18863 s001  R+     0:00.00 grep mysql
asatokensei@MacBook-Air memopy % kill 14996
asatokensei@MacBook-Air memopy % kill 15095
asatokensei@MacBook-Air memopy % ps ax | grep mysql
18876 s001  S+     0:00.01 grep mysql
asatokensei@MacBook-Air memopy % mysql.server status
 ERROR! MySQL is not running
asatokensei@MacBook-Air memopy % mysql.server start 
Starting MySQL
. SUCCESS! 
asatokensei@MacBook-Air memopy % mysql.server status
 SUCCESS! MySQL running (18991)

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?