MySQL pid ended (cannot start mysql)
Solution 1
I have the same problem when installing mysql newest version mysql-5.6.10-osx10.7-x86.dmg for my MAC OS 10.7.5. Following is my solutions. First , delete the mysql installed
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
sudo rm -rf ~/Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*
Then, get mysql-5.1.68-osx10.6-x86.dmg , install this old version, and done!
Solution 2
As @AndPy says, the same with me, if you ls -l
the /usr/local/var/mysql
you can see that the file COMPUTER-NAME.local.err
is owned by _mysql
or some such.... in this case just erase the file and mysql.server start
will create new one owned by your user and will start properly this time :)
If the file is already owned by your user, this wont help, you got to google more :(
Solution 3
I had the same problem after updating to OS X Mavericks.
Starting MySQL . ERROR! The server quit without updating PID file
Like Redrick and AndPy mentioned I also had to rename (actually I deleted the file) the error file located in $ cd /usr/local/var/mysql
. My error file was called localhost.err
. After removing the file with $ rm localhost.err
I could finally start MySQL again with $ mysql.server start
.
Solution 4
I found this error on redmine bitnami stack because owner of files in directory data incorrect.
Check owner of directory /mysql/data/ must be 'mysql' user
Hope this help.
Solution 5
I had the same problem.
In /usr/local/var/mysql I found a file in the form COMPUTER-NAME.local.err. Simply changing that file name solved the problem. I could now start the mysql server with
mysql.server start
Danny Englander
I'm a Drupal themer, developer & evangelist. I love to blog about and engage in the Drupal community.
Updated on July 09, 2022Comments
-
Danny Englander almost 2 years
I have a clean install of MySQL (mysql-5.5.24-osx10.6-x86_64). I am on Lion (OS 10.7.4) with a Mac Pro Quad Core. I installed MySQL the GUI installer and also installed the pref pane and the startup item.
However when I run:
sudo ./bin/mysqld_safe
I get this message:
120515 17:58:19 mysqld_safe Logging to '/usr/local/mysql-5.5.24-osx10.6-x86_64/data/Dannys-Mac-Pro.local.err'. 120515 17:58:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql-5.5.24-osx10.6-x86_64/data 120515 17:58:20 mysqld_safe mysqld from pid file /usr/local/mysql-5.5.24-osx10.6-x86_64/data/Dannys-Mac-Pro.local.pid ended
I also cannot start MySQL from the preference pane.
Here is what I have tried so far based on the hours of Googling and research today:
Permissions issues?
cd /usr/local sudo chown mysql mysql sudo chown mysql mysql-5.5.24-osx10.6-x86_64 sudo chown _mysql mysql sudo chown _mysql mysql-5.5.24-osx10.6-x86_64
and
sudo chown -R /usr/local/mysql-5.5.24-osx10.6-x86_64/ sudo chown -R /usr/local/mysql
sudo chown -R root:wheel /Library/StartupItems/MySQLCOM
Link issues?
in /usr/local/mysql/support-files/mysql.server -- I did:
basedir="/usr/local/mysql" datadir="/usr/local/mysql/data"
In the file /etc/rc.common add the follow line at end: /usr/local/mysql/bin/mysqld_safe --user=mysql &
sudo ln -s /usr/local/mysql-5.5.24-osx10.6-x86_64 /usr/local/mysql
I also tried the removal process here and reinstalled but this did not seem to make a difference. I also launched Activity Monitor in OS X to see if any other mySQL processes were running by chance but they were not.
Nothing above worked so I am sort of at wits end. Here is the log from the .err file located at:
/usr/local/mysql-5.5.24-osx10.6-x86_64/data/Dannys-Mac-Pro.local.err 120515 18:07:43 mysqld_safe mysqld from pid file /usr/local/mysql-5.5.24-osx10.6-x86_64/data/Dannys-Mac-Pro.local.pid ended 120515 18:13:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql-5.5.24-osx10.6-x86_64/data 120515 18:13:01 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-5.5.24-osx10.6-x86_64/data/ is case insensitive 120515 18:13:01 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql-5.5.24-osx10.6-x86_64/bin/mysqld: Table 'mysql.plugin' doesn't exist 120515 18:13:01 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120515 18:13:01 InnoDB: The InnoDB memory heap is disabled 120515 18:13:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120515 18:13:01 InnoDB: Compressed tables use zlib 1.2.3 120515 18:13:01 InnoDB: Initializing buffer pool, size = 128.0M 120515 18:13:01 InnoDB: Completed initialization of buffer pool 120515 18:13:01 InnoDB: highest supported file format is Barracuda. 120515 18:13:01 InnoDB: Waiting for the background threads to start 120515 18:13:02 InnoDB: 1.1.8 started; log sequence number 1595675 120515 18:13:02 [ERROR] /usr/local/mysql-5.5.24-osx10.6-x86_64/bin/mysqld: unknown option '--skip-locking' 120515 18:13:02 [ERROR] Aborting 120515 18:13:02 InnoDB: Starting shutdown... 120515 18:13:03 InnoDB: Shutdown completed; log sequence number 1595675 120515 18:13:03 [Note] /usr/local/mysql-5.5.24-osx10.6-x86_64/bin/mysqld: Shutdown complete 120515 18:13:03 mysqld_safe mysqld from pid file /usr/local/mysql-5.5.24-osx10.6-x86_64/data/Dannys-Mac-Pro.local.pid ended
Update: I upgraded the same machine from Snow Leopard to Mountain Lion 10.8.1 and MySQL works perfectly fine now with the upgrade, I had to do nothing extra.