I am trying to connect to server in NetBeans. I write the code as below:
<?php echo "wlecome"; echo "<br>"; $conn=mysqli_connect("mydomain.com:2082", "phpmyadmin_user", "password","database_name"); echo $conn; ?>
Running of this code return this erreurs:
wlecome Warning: mysqli_connect(): MySQL server has gone away in C:xampphtdocsmyprojetindex.php on line 10 Warning: mysqli_connect(): Error while reading greeting packet. PID=1092 in C:xampphtdocsmyprojetindex.php on line 10 Warning: mysqli_connect(): (HY000/2006): MySQL server has gone away in C:xampphtdocsmyprojetindex.php on line 10 Fatal error: Maximum execution time of 30 seconds exceeded in C:xampphtdocsmyprojetindex.php on line 10
Advertisement
Answer
MySQL can be configured to not accept external connections, for security reasons. By saying the full domain name, you are using the public IP and therefore you are an external connection. If MySQL is running on the same box as your webserver, just access it via this domain name:
localhost:2082