php - PDO 无法连接到 MySQL 但 CLI 可以

Question

做了一个测试脚本:

<?php
$a = new PDO('mysql:dbname=mydbname;host=mydbhost:3306', 'myusername', 'mypassword');
var_dump($a);

我收到以下错误:

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2005] Unknown MySQL server host 'mydbhost:3306' (107)' in /users/pvarney/test_pdo.php:3 Stack trace:
#0 /users/pvarney/test_pdo.php(3): PDO->__construct('mysql:dbname=my...', 'myusername', 'mypassword')
#1 {main}   thrown in /users/pvarney/test_pdo.php on line 3

然后通过 CLI:

[pvarney@ci-server ~]$ mysql mydbname -h mydbhost -u myusername -p --port=3306
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 828511

... snip mysql welcome text ...

mysql>

我已更改连接字符串以屏蔽连接信息，但我确实将其复制粘贴到 CLI 中以确保我没有任何拼写错误。

Answer 1

改变

new PDO('mysql:dbname=mydbname;host=mydbhost:3306', 'myusername', 'mypassword');

到

new PDO('mysql:dbname=mydbname; host=mydbhost; port=3306;', 'myusername', 'mypassword');