Pid file quit without updating file
Getting these bad boy errors on your mysql on OSX, there seems to be lots of solutions about how to fix this, Google hell, this more than likely happens if mysql is running and the OS is updated like from OSX Mountain Lion to Mavericks.
So possible solutions are, first up try a straight restart: [email protected][/usr/local/mysql/data]: sudo /usr/local/mysql/support-files/mysql.server start Starting My SQL . The server quit without updating PID file (/usr/local/mysql/data/neils-i Mac.local.pid).
I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.
Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
[mysqld] port = 3306 socket = /tmp/skip-external-locking key_buffer_size = 16K pid-file=/var/run/mysqld/[mysqld_safe] log-error=/var/log/pid-file=/var/run/mysqld/The solution that worked for me was here: https://serverfault.com/questions/334284/cant-create-pid-file-on-mysql-server-permission-denied Changing some of my permissions seemed to do the trick.
S Apr30 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysql 1666 0.0 0.9 130000 19356 ?
It has ownership changed to mysql for the directory "data", but not to "var"; this is unusual because for years I have had to ensure that var directory was mysql writable.
So I manually ran and then attempted to start it again. But worse, no file in the var dir - it was in the "data" dir!
It seems you have issue with you permission on mysql datadir.
Run below command [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/pid-file=/var/run/mysqld/), that it is the actual one that mysql is using when it runs, and that it has the correct configuration for the installation you created.