(1)
??~?sudo mysql.server start
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/yuandeMacBook-Pro.local.pid).
?
?
?
Last login: Sat Oct 10 23:07:52 on ttys000
?? ~?sudo krbservicesetup?
??~?sudo mysql.server start
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/yuandeMacBook-Pro.local.pid).
??~?sudo chown? -R _mysql:mysql? /usr/local/var/mysql ?
?? ~ ?
?
?
(2) add? my.cnf? ?
?
通过brew 安装的mysql默认是不会产生my.cnf文件的。需要把/usr/local/Cellar/mysql/5.6.27/support-files 文件中的my-default.cnf文件赋值到/etc/下面,并重命名为my.cnf。这样以后就可以通过修改my.cnf修改mysql配置了。
?
?
(3):
MySQL connection not working: 2002 No such file or directory
需要:? ? add? php.ini?
?
? 3.1? 打开部分需要的extension扩展
?
? 3.2? 设定 pdo_mysql.default_socket
mysql.default_socket = /tmp/mysqld.sock
pdo_mysql.default_socket= /tmp/mysqld.sock
mysqli.default_socket =/tmp/mysqld.sock
?
(4)? mac 开启mysql的慢日志,错误日志和普通日志。
配置方法如下,在 /etc/my.cnf中添加以下内容:?
general_log = 1
general_log_file = /var/log/mysql/mysql.log
?
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
slow-query-log? ? ? ? = /var/log/mysql/mysql-slow.log
long_query_time = 2
#log-queries-not-using-indexes
?
?
注意:此处要注意的是:?
mysql5.11之前慢日志的开启变量是: log_slow_queries
?
而现在的是show-query-log
?
?
?
?
5:? ? brew install php56的时候报错: ?
?? Error: Formulae found in multiple taps:?
?* homebrew/php/php56
?* josegonzalez/php/php56
?
Please use the fully-qualified name e.g. homebrew/php/php56 to refer the formula.
?
?
解决方法:?
?
?brew untap josegonzalez/php
?brew tap --repair
?brew update
?
这样就可以了。
?
?
参考链接:
1: http://stackoverflow.com/questions/1676688/php-mysql-connection-not-working-2002-no-such-file-or-directory
?
2:? http://stackoverflow.com/questions/20723803/pdoexception-sqlstatehy000-2002-no-such-file-or-directory
?
?
?
?
?
?
?