Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

After MySQL install via Brew, I get the error - The server quit without updating PID file

Tags:

mysql

homebrew

Ok, I've searched all over and have spent quite a bit of my time installing, uninstalling, trying various option but without success.

I'm on Mac OS X Lion (10.7.3) and am trying to setup a Python, MySQL.

I successfully installed Python and MySQL via HomeBrew. Python works great.

After MySQL Installation, I followed the first 2 steps - unset and the mysql_install_db commands.

Now, when I try to start mysql "mysql.server start", I get the following error

ERROR! The server quit without updating PID file (/usr/local/var/mysql/Brajeshwar.local.pid).
  • Brajeshwar is my username on my machine.
like image 513
Brajeshwar Avatar asked Mar 08 '12 20:03

Brajeshwar

People also ask

Where to find PID file for MySQL?

pid in the /usr/local/mysql/data/ directory.

What is PID file in MySQL?

The PID is the process ID of the MySQL processes. You will have to kill those processes. # kill -9 PID. PID – Process ID of the MySQL process. 3) Check the ownership of MySQL data directory /var/lib/mysql/.

How do I start MySQL server on Mac?

Open macOS system preferences and select the MySQL preference panel, and then execute Start MySQL Server. The Instances page includes an option to start or stop MySQL, and Initialize Database recreates the data/ directory.

Can't connect to local MySQL server?

normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.

1 Answers

I found that it was a permissions issue with the mysql folder.

chmod -R 777 /usr/local/var/mysql/

solved it for me.

like image 76
mikoop Avatar answered Oct 05 '22 18:10

mikoop
Sign in to Comment

Related questions

Select data between a date/time range
How and when to use SLEEP() correctly in MySQL?
Create table in MySQL that matches another table?
Java: Insert multiple rows into MySQL with PreparedStatement
SELECT INTO in MySQL
Fatal error: Call to a member function bind_param() on boolean [duplicate]
Unable to get spring boot to automatically create database schema
How to remove new line characters from data rows in mysql?
How to deal with an apostrophe while writing into a MySQL database [duplicate]
SHOW PROCESSLIST in MySQL command: sleep
MySQL "CREATE TABLE IF NOT EXISTS" -> Error 1050
mysqldump - Export structure only without autoincrement
How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
MySQL get row position in ORDER BY
Calculating time difference between 2 dates in minutes
How do write IF ELSE statement in a MySQL query
How to get primary key of table?
Integrity constraint violation: 1452 Cannot add or update a child row:
Laravel Eloquent vs query builder - Why use eloquent to decrease performance [closed]
phpmyadmin automatic logout time

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!