当前位置: 代码迷 >> MySQL >> mac安装mysql遇到的有关问题总结
  详细解决方案

mac安装mysql遇到的有关问题总结

热度:270   发布时间:2016-05-05 16:28:15.0
mac安装mysql遇到的问题总结

(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

?

?

?

?

?

?

?

  相关解决方案