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)
More than 3 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme