大家好，又见面了，我是你们的朋友全栈君。
I’m getting the following error installing drupal 7:
Failed to connect to your database server. The server reports the following message: SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘myservername’ (13).
I am running MySQL on one windows server and httpd on another linux. MySQL is running just fine and on the httpd server I can connect just fine to the MySQL, as follows:
mysql -h dbserver -p –port=3001 -u drupal
Similarly I can run mysqli and pdo and it connection just fine too from my httpd:
$servername = “dbserver”;
$username = “drupal”;
$password = “xxx”;
$dbname = “drupal”;
$port = 3001;
$conn = new mysqli($servername, $username, $password, $dbname, $port);
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
echo “Connected successfully”;
$conn->close();
try {
$conn = new PDO(“mysql:host=$servername;dbname=$dbname;port=$port”, $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo “Connected successfully”;
}
catch(PDOException $e)
{
echo “Connection failed: ” . $e->getMessage();
}
$conn=null;
?>
So there is nothing wrong on my web server or php or mysql. It’s just through the installation that it fails. I’ve been in the advanced and entered all the correct details.
Any idea? I looked and there was no apache log and I couldn’t figure out how to increase error reporting during install or find exactly where it does the database connection check..
thanks.
解决方案
Can you confirm you have dbserver’s ip mapped.
Go to terminal and type : “ping dbserver” and please post result.
EDITED: This situation was caused by a security policy of the linux distro where the apache server is setup that doesn’t allow it to connect to remote mysql instances. For solving this situation go to terminal and type sudo setenforce 0, that way linux won’t enforce such strict webserver behaviour.
发布者：全栈程序员-用户IM，转载请注明出处：https://javaforall.cn/162248.html原文链接：https://javaforall.cn
【正版授权，激活自己账号】： Jetbrains全家桶Ide使用，1年售后保障，每天仅需1毛
【官方授权 正版激活】： 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...
