phpmyadmin Database connection

Question

I'm trying to connect to MySQL database but, I'm getting an error.

Code:

<?php
    ini_set('mysql.connection_timeout',300);
    ini_set('default_socket_timeout',300);
    define('DB_SERVER', 'localhost:8080');
    define('DB_USERNAME', 'root');
    define('DB_PASSWORD', '');
    define('DB_DATABASE', 'sib');
    $db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
?>

Which gives me the error:

Warning: mysqli_connect(): MySQL server has gone away in C:\xampp\htdocs\SIB\connect.php on line 9

Warning: mysqli_connect(): Error while reading greeting packet. PID=10696 in C:\xampp\htdocs\SIB\connect.php on line 9

Warning: mysqli_connect(): (HY000/2006): MySQL server has gone away in C:\xampp\htdocs\SIB\connect.php on line 9

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\SIB\connect.php on line 9

From the warnings it sounds like you have not set up MySQL server correctly or you do not have it running. You might have skipped some steps in the xampp setup -- time to read the instructions? — Dave S
– Dave S, Commented Jun 4, 2019 at 22:53
It sounds like you are trying to send large chunk of data to MySQL. Is that really all of your code? Or maybe the port specified is incorrect? — Dharman
– Dharman ♦, Commented Jun 4, 2019 at 22:55

Dharman · Accepted Answer · 2019-06-22 00:08:58Z

1

The first thing is that your port must be specified as a separate parameter to mysqi_connect, not together with host. - The second thing is that You are not connecting to MySQL, but to Apache server. If you didn't change MySQL port just use define('DB_SERVER', 'localhost'); in place of define('DB_SERVER', 'localhost:8080');

<?php 
     ini_set('mysql.connection_timeout',300);
     ini_set('default_socket_timeout',300);
     define('DB_SERVER', 'localhost');
     define('DB_USERNAME', 'root');
     define('DB_PASSWORD', '');
     define('DB_DATABASE', 'sib');
     $db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE,3306);

as per php.net/manual/en/mysqli.quickstart.connections.php

edited Jun 22, 2019 at 0:08

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Jun 5, 2019 at 4:30

CodeBreaker

4013 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

phpmyadmin Database connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related