代碼如下:
<?php$mysqli = new mysqli('localhost', 'root', '184995511', 'cg_levi');if ($mysqli->connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);};echo 'ok';
如果上面連接地址為'localhost'就會(huì)報(bào)錯(cuò),如下:
Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /mnt/www/cglevi/publichtml/mysql.php on line 2Connect Error (2002) No such file or directory
將'localhost'修改為'127.0.0.1'之后鏈接正常
查看了hosts沒有問題,如下:
127.0.0.1 localhost::1 localhost localhost.localdomain localhost6 localhost6.localdomain6/etc/hosts (END)
查看mysql狀態(tài),沒有問題,如下:
mysql> status;--------------mysql Ver 14.14 Distrib 5.6.10, for Linux (x86_64) using EditLine wrapperConnection id: 860Current database: Current user: root@localhostSSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server version: 5.6.10 MySQL Community Server (GPL)Protocol version: 10Connection: Localhost via UNIX socketServer characterset: latin1Db characterset: latin1Client characterset: utf8Conn. characterset: utf8UNIX socket: /var/lib/mysql/mysql.sockUptime: 13 hours 13 min 50 secThreads: 1 Questions: 11900 Slow queries: 0 Opens: 100 Flush tables: 1 Open tables: 80 Queries per second avg: 0.249--------------
請(qǐng)問如何解決?