Words have meanings associated to it, some are synonyms like siblings and some are distant relatives like friends and associates.
Let's write the words down and you and I can later figure out our preferences to categorize them.
Open a command Terminal.
Use command + command - to increase or decrease the font size
Problem Statement:
bash-3.2# /usr/local/mysql/support-files/mysql.server start
Starting MySQL
.................................................................................................... ERROR! The server quit without updating PID file (/usr/local/mysql/data/xx-xxx.pid).
bash-3.2# cat /usr/local/mysql/data/xx-xxxx.pid
Root Case :
There might be multiple mysql processes running. Kill them.
Solution:
bash-3.2# ps aux|grep mysql
root 28892 0.9 0.0 4277256 796 s001 S+ 1:09PM 0:00.00 grep mysql
_mysql 22971 0.0 1.1 4884468 186036 ?? Ss 9:49AM 0:23.22 /usr/local/mysql/bin/mysqld --user=_mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/usr/local/mysql/data/mysqld.local.err --pid-file=/usr/local/mysql/data/mysqld.local.pid --keyring-file-data=/usr/local/mysql/keyring/keyring --early-plugin-load=keyring_file=keyring_file.so
sudo kill 22971
Restart the server
bash-3.2# /usr/local/mysql/support-files/mysql.server start
Starting MySQL
. SUCCESS!
Error Messages from logs could look like:
bash-3.2# cat /usr/local/mysql/data/amoni-mac.err
