mysqli_connect doesn’t
| From: | Yugroysl | Date: | Sat, 30 May 2020 11:23:49 +0000 |
| Subject: | mysqli_connect doesn’t | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-327173@lists.php.net to get a copy of this message | ||
I'm having trouble getting PHP7 to connect to a MariaDb database.
The relevant script is shown below, copied from PHP documentation,
but it won't connect.
The setup:
System 1: Windows 10, MariaDb 10.4.2, Apache 2.4, PHP 7; SQL client HeidiSQL
System 2: Fedora 32 Workstation, MariaDb 10.4.2, Apache 2.4, PHP 7; SQL client Sequeler
The databases on both systems are identical. The users are the same,
with the same names, privileges and passwords on both. Using HeidiSQL
I can connect perfectly to the databases on both machines, locally on
Windows and remotely on Linux from Windows. Sequeler connects perfectly
on the Linux box locally. Firewalls on both systems are properly configured.
Attempts to connect with the following script fail on both systems.
<html>
<head>
<body>
<?php
/*
$host is set to one of these depending on the system:
127.0.0.1 locally on Linux localhost locally on Windows 192.168.2.55 remotely on Linux from the Windows box*/ $host = "127.0.0.1"; /* these parameters are valid for both machines (obviously they're not the real ones!) */ $usr = "me"; $pw="me123456"; $db="mydb"; /* this is displayed correctly - shows that the parameters are ok */ printf("Here: %s, %s, %s, %s<br>",$host,$usr,$pw,$db); $conn = mysqli_connect($host,$usr,$pw,$db); /* SCRIPT STOPS HERE */ if ( !$conn ) { /* this is never displayed */
die("Connect failed!");
}
if ( $result=mysqli_query($conn,"SELECT * FROM mytable") ) {
$n=mysqli_num_rows($result); }mysqli_close($conn); printf("Found %d records",$n); ?> </body> </head> </html> Any ideas, anyone? Thanks in advance! PeterR. -- This email has been checked for viruses by AVG. https://www.avg.com