(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
这样就可以了。
参考链接: