MySQL does not start when upgrading OSX to Yosemite or El Capitan -
i know similar questions exist, such mysql mamp not work osx yosemite 10.10. however, have mamp, nor xampp installed on computer.
when try start mysql prefpane, nothing happens.
when try start mqsql command line via sudo /usr/local/mysql/support-files/mysql.server start
get:
starting mysql . error! server quit without updating pid file
(/usr/local/mysql/data/adamg.local.pid).
any , appreciated. can supply file output necessary.
open terminal:
check mysql system pref panel, if says along line "warning, /usr/local/mysql/data not owned 'mysql' or '_mysql'
if yes, go mysql folder cd /usr/local/mysql
do sudo chown -r _mysql data/
this change ownership of /usr/local/mysql/data , of content own user '_mysql'
check mysql system pref panel, should saying it's running now, auto-magically. if not start again.
another way confirm
netstat -na | grep 3306
it should say:
tcp46 0 0 *.3306 *.* listen
to see process owner , process id of mysqld:
ps aux | grep mysql
Comments
Post a Comment