MySQL Forums
Forum List  »  PHP

MySQL Remote Connection
Posted by: Mariampillai Raphielda
Date: May 31, 2018 01:22PM

Hello,
Could you please anyone help me to resolve this following problem.

Recently I've installed MySQL Server version: 5.7.22 on 0ubuntu18.04.1 (Virtual machine) on my home LAN. Then I created a user with remote access permission.
Everything working fine when I connecting with IP address of the sql server through a PHP script hosted in the same machine. But when I try to connect from another PC using the same PHP script, my browser displays "HTTP ERROR 500".

I try to change bind-address = 0.0.0.0 in the /etc/mysql/mysql.conf.d/mysqld.cnf file but no success. The firewall is disbled, and I can ping DB server from my PC even "telnet 192.168.1.100 3306" command working fine.

what could be the reason?

Thanks for your help
Raphy

Options: ReplyQuote


Subject
Written By
Posted
MySQL Remote Connection
May 31, 2018 01:22PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.