MySQL fails to start after update
Realized all this mess has been created because mysql has been installed via brew and via package from mysql site.

Solution for me was to remove mysql completely &amp; reinstalled it via brew.

The new database data i created are located in /usr/local/var/mysql/

Running where mysql returns /usr/local/bin/mysql

Running mysql.server start|stop|restart seems to function ok. Also accessing db via sequel pro works ok but when i tried to setup my rails projects i run rake db:create but i received


  rake aborted! LoadError:
  dlopen(/Users/myuser/.rvm/gems/ruby-2.2.4/extensions/x86_64-darwin-14/2.2.0/mysql2-0.4.3/mysql2/mysql2.bundle,
  9): Library not loaded:
  /usr/local/Cellar/mysql/5.5.19/lib/libmysqlclient.18.dylib Referenced
  from:
  /Users/myuser/.rvm/gems/ruby-2.2.4/extensions/x86_64-darwin-14/2.2.0/mysql2-0.4.3/mysql2/mysql2.bundle
  Reason: image not found -
  /Users/myuser/.rvm/gems/ruby-2.2.4/extensions/x86_64-darwin-14/2.2.0/mysql2-0.4.3/mysql2/mysql2.bundle



libmysqlclient.18.dylib doesnt exist in my setup, nor the directory ..Cellar/mysql/5.5.19/.. 
There is usr/local/Cellar/mysql/5.7.11/lib/
And there is libmysqlclient.dylib -&gt; libmysqlclient.20.dylib but no ../libmysqlclient.18.dylib in my system.


In ~/.bash_profile there is export PATH=/usr/local/bin:$PATH

In ~/.bash_rc there

[[ -s "$HOME/.rvm/scripts/rvm" ]] &amp;&amp; source "$HOME/.rvm/scripts/rvm" # Load RVM into a shell session *as a function*

PATH=$PATH:$HOME/.rvm/bin # Add RVM to PATH for scripting


and in ~/.zshrc there is

export PATH="/usr/local/sbin:$PATH"


Seems like i have messed up with my systems paths?