Mysql

Centos

mysql query log

/etc/my.cnf

add
[mysql]
log=/var/log/httpd/mysql_query.log

MAC OS

- Error with homebrew
/tmp/mysql.sock not found
- Fix:

/usr/local/Cellar/mysql/5.6.12/support-files/mysql.server stop
unset TMPDIR
mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp

Create a my.cnf file, /usr/local/var/mysql/my.cnf

[mysqld]
socket=/tmp/mysql.sock

mysql.server start