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:

  1. check mysql system pref panel, if says along line "warning, /usr/local/mysql/data not owned 'mysql' or '_mysql'

  2. if yes, go mysql folder cd /usr/local/mysql

  3. do sudo chown -r _mysql data/

  4. this change ownership of /usr/local/mysql/data , of content own user '_mysql'

  5. check mysql system pref panel, should saying it's running now, auto-magically. if not start again.

  6. 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

Popular posts from this blog

Python Kivy ListView: How to delete selected ListItemButton? -

Image
i'm trying learn kivy building simple todo-list app suggested dusty phillips, author of book "creating apps in kivy". this code far: from kivy.app import app kivy.uix.boxlayout import boxlayout kivy.properties import objectproperty kivy.uix.listview import listitembutton class taskbutton(listitembutton): pass class todoroot(boxlayout): task_input = objectproperty() task_list = objectproperty() def add_task(self): self.task_list.adapter.data.extend([self.task_input.text]) self.task_list._trigger_reset_populate() def del_task(self): pass class todoapp(app): def build(self): return todoroot() if __name__ == '__main__': todoapp().run() and kv file: #: import main todo #: import listadapter kivy.adapters.listadapter.listadapter #: import listitembutton kivy.uix.listview.listitembutton todoroot: <todoroot>: orientation: "vertical" task_input: task_input_view t...
Read more

ruby - How do I merge two hashes into a hash of arrays? -

http://codepad.org/wmyzqlis i'd merge these 2 arrays: a = { :a => 'a', :b => 'b', :d => 'd' } b = { :a => '1', :b => 'b', :c => 'c' } into hash looks this: {:a => ["a", "1"], :b => ["b", "b"], :c => [nil, "c"], :d => ["d", nil] } this doesn't work: p a.merge(b) { |k, v1, v2| [v1, v2] } # {:c=>"c", :a=>["a", "1"], :b=>["b", "b"], :d=>"d"} it's because hash#merge call block duplicate keys. a = { :a => 'a', :b => 'b', :d => 'd' } b = { :a => '1', :b => 'b', :c => 'c' } hash[(a.keys|b.keys).map { |key| [key, [a.fetch(key, nil), b.fetch(key, nil)]] }] # => {:a=>["a", "1"], :b=>["b", "b"], :d=>["d", nil], :c=>...
Read more