如何在 Mac 上的 MySQL 上设置默认端口

Question

在 OSX 上，当我尝试使用以下命令时：

resources.db.adapter = "pdo_mysql"
resources.db.params.dbname = "myDb"
resources.db.params.host = "localhost"
resources.db.params.username = "root"
resources.db.params.password = ""

我收到以下错误

Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) in /Library/WebServer/sites/testweb/library/Zend/Db/Adapter/Pdo/Abstract.php on line 129

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /Library/WebServer/sites/testweb/library/Zend/Db/Adapter/Pdo/Abstract.php:129
Stack trace:
#0 /Library/WebServer/sites/testweb/library/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=gl...', 'myDb', '', Array)
#1 /Library/WebServer/sites/testweb/library/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect()
#2 /Library/WebServer/sites/testweb/library/Zend/Db/Adapter/Abstract.php(858): Zend_Db_Adapter_Pdo_Mysql->_connect()
#3 /Library/WebServer/sites/testweb/library/Zend/Db/Adapter/Abstract.php(928): Zend_Db_Adapter_Abstract->quote('asdf@asd...', NULL)
#4 /Library/WebServer/sites/testweb/library/Zend/Db/Select.php(1000): Zend_Db_Adapter_Abstract->quoteInto('email = ?', 'asdf@asd...', NULL)
#5 /Library/WebServer/sites/testweb/library/Zen in /Library/WebServer/sites/testweb/library/Zend/Db/Adapter/Pdo/Abstract.php on line 144

如果我添加 :3306 则它可以工作

resources.db.params.host = "localhost:3306"

但是 Windows 机器会出现这样的连接问题。

有没有办法让 OSX 仅连接 localhost mysql 默认端口？

Answer 1

要使用“localhost”作为 ip，而不是让 UNIX 系统尝试连接到套接字，只需提供 ip 地址而不是“localhost” - 127.0.0.1

resources.db.params.host = 127.0.0.1

要指定端口，您应该在资源配置中使用单独的行如有必要：

resources.db.params.port = 3306

Answer 2

Mountain Lion 使用 MAMP 解决方案：

sudo ln -f /Applications/MAMP/bin/php/php5.4.4/bin/php /usr/bin/php