localhost via TCP/IP 跟 localhost via UNIX socket 的差別
<?php $mysqli = new mysqli("localhost","root","","practice",3306); if($mysqli->connect_errno){ echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ")" . $mysqli->connect_error; } echo $mysqli->host_info . "\n"; localhost via TCP/IP localhost via UNIX socket localhost via TCP/IP ▲在windows主機上會看到這個 使用TCP/IP代表連接是透過網路卡 意謂著會受到網絡防火墻和網卡相關的限制 localhost via UNIX socket ▲在linux主機上會看到這個 使用socket代表本地直連，未透過網路卡 則不受網絡防火墻和網卡相關的的限制 會透過mysql.sock檔案 可以透過以下方式找到你的mysql.sock