RE: [PHP-DB] Can connect to Mysql via command line but not via browser
| From: | Tai Larson | Date: | Thu, 03 Sep 2020 22:23:35 +0000 |
| Subject: | RE: [PHP-DB] Can connect to Mysql via command line but not via browser | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-49186@lists.php.net to get a copy of this message | ||
The are connected to the same network. I’m setting up a development environment.
From: Aziz Saleh <azizsaleh@gmail.com>
Sent: Thursday, September 3, 2020 3:09 PM
To: Tai Larson <tai.larson@weierlaw.com>
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Can connect to Mysql via command line but not via browser
Are both connected to the same network? Just asking because I see a local ip for server ip/name.
Maybe try with public IP instead see if it helps.
On Thu, Sep 3, 2020 at 5:51 PM Tai Larson <tai.larson@weierlaw.com<mailto:tai.larson@weierlaw.com>> wrote:
I have a MySQL database server and a separate web sever running Apache. Both are running Centos 8.
I can connect to my database server from my web server via the command line, but I get permission
denied whenever I try to connect to the server via a browser.
Here is the code I'm running:
<?php
$servername = "192.168.10.XXX";
$username = "root";
$password = "123456789";
$conn = new mysqli($servername, $username, $password); if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error); } echo "Connected
successfully"; ?>
I SSH into my web server and run this command "php TestMySQL.php". I receive the output
of "Connected successfully".
When I attempt through my browser or curl, I receive the output of "Connection failed:
Permission denied".
I can also connect to the remote database with the local mysql client.
Thank you all in advance for your help.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php