Linux安全网 - Linux操作系统_Linux 命令_Linux教程_Linux黑客

会员投稿 投稿指南 本期推荐:
搜索:
您的位置: Linux安全网 > Linux编程 > 数据库管理 > » 正文

Can't connect to MySQL server on 'ip&#39

来源: iloveyin 分享至:

I tried to connect to a remote mysql server ( 192.168.1.197 ) from a server with IP 192.168.1.193.
My php connect:
$host = "192.168.1.197";
$user = "root";
$pass = "rootpassword";
$database = "sample1";
#$con=@mysql_connect("$host","$user","$pass") or die('Error connecting to mysql');
$con = mysql_connect("$host", "username", "password") or die(mysql_error());
$db="$database"; @mysql_select_db($db, $con);

When i run this in the web, I'm getting the (13) error. I've search the web but could not find any concrete answer.

If i type this in the command prompt:
[root@linuxso.com include]# mysql -u root -h 192.168.1.197 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 71
Server version: 5.0.51a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

I was able to connect..

Can someone help me on this one?

I even created a user rights for root ( both 193 & 197 )
User Host Password Global privileges Grant
root 192.168.1.193 Yes ALL PRIVILEGES Yes
root 192.168.1.197 Yes ALL PRIVILEGES Yes

 

解决方法1、:setsebool -P httpd_can_network_connect_db=1


Tags:
分享至:
最新图文资讯
1 2 3 4 5 6
验证码:点击我更换图片 理智评论文明上网,拒绝恶意谩骂 用户名:
关于我们 - 联系我们 - 广告服务 - 友情链接 - 网站地图 - 版权声明 - 发展历史