Home > OS >  Error while reading greeting packet on connection of php with mysql using mysqli
Error while reading greeting packet on connection of php with mysql using mysqli

Time:11-11

<?php
    $conn = new mysqli('localhost','root', '', 'votesystem','8080');

    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
?>

Errors returned are:

Warning: mysqli::__construct(): Error while reading greeting packet. PID=14576 in C:\xampp\htdocs\votesystem\admin\includes\conn.php on line 2

Warning: mysqli::__construct(): (HY000/2006): MySQL server has gone away in C:\xampp\htdocs\votesystem\admin\includes\conn.php on line 2

Fatal error: Maximum execution time of 120 seconds exceeded in C:\xampp\htdocs\votesystem\admin\includes\conn.php on line 2

My localhost runs on port 8080.

  • username-root
  • hostname=localhost
  • password=no
  • global privileges=ALL
  • PRIVILEGES Grant= yes

CodePudding user response:

You have confused the Webserver with the MySQL Server. Your web server is running on port 8080, not your MySQL Server. The MySQL server runs on port 3306 (by default) so your web application needs to connect to it on that port.

Change your mysqli connect string to:

$conn = new mysqli('localhost','root', '', 'votesystem', '3306');
  • Related