Re: [PHP-DB] Can connect to Mysql via command line but not via browser
[email protected] (Roberto Carlos Garcia Luis) Mon, 12 Oct 2020 22:57:53 -0500
| Newsgroups | php.db |
|---|---|
| Message-ID | <CAGnx8d97CkM7AcByLQ3SNH9MVPGRbPnMVhj9KRw8h4Z+hdpHzg@mail.gmail.com> |
--0000000000001af55305b1856c49 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Please try with this answer... https://stackoverflow.com/questions/41178774/connect-database-error-type-20= 02-permission-denied El jue., 3 sept. 2020 a las 17:23, Tai Larson (<[email protected]>) escribi=C3=B3: > The are connected to the same network. I=E2=80=99m setting up a developm= ent > environment. > > From: Aziz Saleh <[email protected]> > Sent: Thursday, September 3, 2020 3:09 PM > To: Tai Larson <[email protected]> > Cc: [email protected] > 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 <[email protected]<mailto= : > [email protected]>> 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 =3D "192.168.10.XXX"; > $username =3D "root"; > $password =3D "123456789"; > $conn =3D 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 > --0000000000001af55305b1856c49--