情况说明
test.php 内容如下
<?php
error_reporting(E_ALL);
ini_set('display_errors','On');
$mysqli=new mysqli();
$mysqli->connect('192.168.1.5','lamp1234','lamp1234','lamptest');
$sqlstr='select * from chuhu';
$result=$mysqli->query($sqlstr);
while($row=$result->fetch_object())
{$name=$row->chuhu_id;
echo $name;
}
?>
在windows下的phpstudy环境可以得到相关的数据里的数据,ip:192.168.1.200
但是同样的代码放到linux+apache+php+mysql环境,IP地址:192.168.1.5,就是说程序与mysql均在同一服务器下,同时3306端口是打开的。防火墙已关闭,同时利用mysqlfont工具在widnows平台链接linux下的mysql是可以的,正如同样的程序上windows下是可以执行的。
已把short_open_tag = Off改为short_open_tag = On
却提示报错,具体信息如下
[Mon Jul 11 04:38:37 2016] [error] [client 192.168.1.5] PHP Warning: mysqli::connect(): (HY000/2003): Can't connect to MySQL server on '192.168.1.5' (13) in /var/www/html/test.php on line 5
[Mon Jul 11 04:38:37 2016] [error] [client 192.168.1.5] PHP Warning: mysqli::query(): invalid object or resource mysqli\n in /var/www/html/test.php on line 7
[Mon Jul 11 04:38:37 2016] [error] [client 192.168.1.5] PHP Fatal error: Call to a member function fetch_object() on a non-object in /var/www/html/test.php on line 9
[Mon Jul 11 04:38:37 2016] [error] [client 192.168.1.5] PHP Warning: mysqli::connect(): (HY000/2003): Can't connect to MySQL server on '192.168.1.5' (13) in /var/www/html/test.php on line 5
[Mon Jul 11 04:38:37 2016] [error] [client 192.168.1.5] PHP Warning: mysqli::query(): invalid object or resource mysqli\n in /var/www/html/test.php on line 7
[Mon Jul 11 04:38:37 2016] [error] [client 192.168.1.5] PHP Fatal error: Call to a member function fetch_object() on a non-object in /var/www/html/test.php on line 9
my.ini文件 配置如下:
[root@localhost etc]# cat my.cnf
[mysqld]
default-character-set = utf8
port = 3306
skip-locking
#bind-address = 192.168.1.5
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
#symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
也就是说同样的的代码在linux却不能执行
还有什么办法,请各位指点一下,谢谢