All geek questions in one place

MySql ERROR! Server shuts down without updating PID file

I inherited a computer on which the MySql server was previously installed, and then deleted (apparently, it went fine before the removal). I am in a database class, so I tried installing it again, and now I get an error:

Starting MySQL ERROR! The server shuts down without updating the PID file (/usr/local/mysql/data/Computer.local.pid).

I looked online and saw that this error occurred to others, but either: a) I could not figure out how to do this, or b) the fix did not work for me.

I tried (from http://coolestguidesontheplanet.com/mysql-error-server-quit-without-updating-pid-file/ ):

Computer: / computer $ / usr / local / mysql / support-files / mysql.server restart

And I get this error: ERROR! MySQL server PID file not found! MySQL launch

. MISTAKE! The server shuts down without updating the PID file (/usr/local/mysql/data/Computer.local.pid).

I'm not sure what they are telling me to do here:

Delete / etc / my.cnf or just run it now and restart: sudo mv / etc / my.cnf / etc / my.cnf.bak

because I get this error on input:

Computer: / computer $ cd / usr / my.cnf

- bash: cd: /usr/my.cnf: no such file or directory

I also see from: mysql ERROR! Does the server shut down without updating the PID file? That there are error logs and the my.cnf file, but I'm not sure if they access them.

Loaded MySql: mysql-5.7.10-osx10.9-x86_64.dmg

I am on mac version 10.7.5

Thanks!

+4
source share
1 answer

1: .

tail -f /usr/local/mysql/data/*.err

2: . , mysql

mysqladmin -uroot shutdown
sudo killall mysqld 

ps -ef | grep mysql

3:

sudo chown -RL root:mysql /usr/local/mysql
sudo chown -RL mysql:mysql /usr/local/mysql/data
chmod -R 755 /usr/local/mysql/data

4: mysql

sudo mysql.server start
+24

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

More articles:


All Articles