without - mysqld_safe starting mysqld daemon with databases from/var/lib/mysql
MySQL pid ended(cannot start mysql) (7)
120515 18:13:01 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
- Regarding this error, I assume that you have specified a datadir in my.cnf. If you are using a non-default data directory for MySQL, you need to move folders mysql and performance_schema (whichever exists) to the data directory specified in my.cnf. You can find these folders in mysql directory.
In MySQL 5.5+ the --skip-locking option is removed. Use --skip-external-locking instead. Refer to MySQL documentation --> http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html Quote: "The --enable-locking and --skip-locking server options (use --external-locking and --skip-external-locking)."
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:
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:
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
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
in /usr/local/mysql/support-files/mysql.server -- I did:
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.
Give this a whirl..
- Navigate to the problem's parent directory
rm -rf *.local.err(deletes file)
touch YOURUSERNAME.local.pid(generates new *.local.pid file the error thrown was complaining about)
- cd back into your project and restart mysql using
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.
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
If you want to absolutely get this thing working do the following:
You need to uninstall mysql first so do that, before you do this though, make sure you have a backup of all your DBs.
brew remove mysql
Then you need to make sure certain files are uninstalled, make a batch script of the following commands and run it:
sudo rm /usr/local/mysql sudo rm -rf /usr/local/var/mysql sudo rm -rf /usr/local/mysql* sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist sudo rm -rf /Library/StartupItems/MySQLCOM sudo rm -rf /Library/PreferencePanes/My* launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist rm -rf ~/Library/PreferencePanes/My* sudo rm -rf /Library/Receipts/mysql* sudo rm -rf /Library/Receipts/MySQL* sudo rm -rf /private/var/db/receipts/*mysql*
/etc/hostconfig using your favorite editing program and remove the line
brew cleanup then install mysql using
brew install mysql
After you've done this you'll probably get the same error again. Head over to the folder
cd /usr/local/var/mysql/. There should be a file in there called
cat ./localhost.local.err and look in the file. You should see something similar to:
2018-03-24 15:41:49 140735679804288 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 48: Address already in use
2018-03-24 15:41:49 140735679804288 [ERROR] Do you already have another mysqld server running on port: 3306 ?
If you do, run the command
sudo lsof -i :3306 and you'll probably get something back like this:
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 74 _mysql 20u IPv6 0xXXXXXXXXXXXXX 0t0 TCP *:mysql (LISTEN)
This means mysql is already running and listening on port 3306 and you need to kill it. Use
top to kill the program or just use Activity Monitor to kill it. Either way once that's done go back to
cd /usr/local/var/mysql/ and delete the folder
Once that's done run mysql.server start and you should get the following:
180324 15:46:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
And congrats. I've been trying to fix this for a week and it's such an easy fix and I just figured it out. I hate myself.
My answer is very similar to others, but slightly different and this applies mostly to a bitnami mamp stack. The fix for me was:
sudo chown -R mysql mysql/
mysql/ directory is the one located in
The above sets the mysql to be the owner of the mysql directory recursively into the other directories.
since I cannot post comments (got <50 reputation :( ) I am writing it here :)
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 :(