MySQL will not run on OSX El capitan for any reason whatsoever -

first of let me start saying have read , tried approaches found on web , stack overflow.

what when try run

mysql.server start 

or

sudo /usr/local/mysql/support-files/mysql.server start 

is

error! server quit without updating pid file (/usr/local/var/mysql/hostname.local.pid). 

what when try run:

mysql 

is

error 2002 (hy000): can't connect local mysql server through socket '/tmp/mysql.sock' (2) 

i tried:

1. sudo mysqld_safe &
2. clicking mysql start button on system preferences.
3. restart computer
4. reinstall mysql
5. install older version of mysql
6. killall , try run mysql
7. sudo chmod -r 777 /usr/local/mysql/
8. `sudo chown -r mysql /var/lib/mysql/
9. rm /usr/local/var/mysql/localhost.err
10. sudo /usr/local/mysql/bin/mysqld_safe start
11. tried here: how auto-load mysql on startup on os x yosemite / el capitan

i out of ideas, don't know do.

what did make work:

killall -u username brew remove mysql brew cleanup 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* 

*restart computer

brew doctor , fix errors brew update brew install mysql unset tmpdir mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp mysql.server start