远程连接到WAMP MySQL没有连接

Question

我在Windows Server 2016上使用WAMP运行网站。该网站有一个MySQL数据库，我有添加用户与密码，并给出静态IP的和％

每次我试图使用PHP的字符串，我得到的错误连接如下

Warning: mysql_connect(): Can't connect to MySQL server on '...' (13) Cannot Connect

当我使用MySQL工作台我可以登录没有问题，MySQL数据库

我目前使用下面的代码

$host="***.***.***.***"; // Host IP Address I even tried it by :3306 port after IP 
$username="***"; // Mysql username 
$password="***"; // Mysql password 
$db_name="gs"; // Database name 

// Connect to server and select database. 
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB"); 

我已经加入到phpmyadmin.conf文件中的以下以及

Directory "c:/wamp/apps/phpmyadmin4.0.4/"> 
    Options Indexes FollowSymLinks ExecCGI 
    AllowOverride all 
    Order Allow,Deny 
    Allow from all 
    Allow from 0.0.0.0 
    Allow from 127.0.0.1 

它否认我访问任何建议，将不胜感激

我已经使用的mysqli以及这是我收到的错误，这里是我的代码

$servername = "154.0.***.***"; 
$username = "***"; 
$password = "***"; 
$port = "3306"; 

// Create connection 
$conn = new mysqli($servername, $username, $password, $port); 

// Check connection 
if ($conn->connect_error) { 
    die("Connection failed: " . $conn->connect_error); 
} 
echo "Connected successfully"; 

Warning: mysqli::mysqli(): (HY000/2002): Permission denied in /home/www/e-track.biz on line 30 Connection failed: Permission denied

第30行是

$conn = new mysqli($servername, $username, $password, $port); 

Answer 1

嗨，

请使用下面的代码： - 如果此代码不起作用，然后请检查服务器设置。

<?php 
$servername = "154.0.***.***"; 
$username = "***"; 
$password = "***"; 
$db_name="gs"; 

$con = @mysqli_connect($servername, $username, $password,$db_name); 
if (mysqli_connect_errno()) 
{ 
    echo "Database connection error: ".mysqli_connect_error(); 
} 
else 
{ 
    echo "Connected successfully"; 
} 
?>