when i used to connect with phpmyadmin using netbeans in php programming language i got some error

Question

This is my code for connecting to database:

$datbase=mysqli_connect("localhost:82","root"," ");
if(!$datbase)
{
    die("connection failed".mysqli_connect_error());
}

it shows me that

Warning: mysqli_connect(): MySQL server has gone away in C:\Program Files\apache24\Apache24\htdocs\PhpProject3\php_DataBase.php on line 9

Warning: mysqli_connect(): Error while reading greeting packet. PID=10848 in C:\Program Files\apache24\Apache24\htdocs\PhpProject3\php_DataBase.php on line 9

Warning: mysqli_connect(): (HY000/2006): MySQL server has gone away in C:\Program Files\apache24\Apache24\htdocs\PhpProject3\php_DataBase.php on line 9

line number 9 is database=mysqli_connect("localhost:82","root"," ")

Possible duplicate of [MySQL Server has gone away when importing large sql file](https://stackoverflow.com/questions/12425287/mysql-server-has-gone-away-when-importing-large-sql-file) — Linus, Jun 13 '17 at 06:31

score 1 · Accepted Answer · answered Jun 13 '17 at 06:19

Error in this line and also remove space in password

$datbase=mysqli_connect("localhost:82","root"," ");

You are not connecting to MySQL, but to Apache server. If you didn't change MySQL port just use

$datbase=mysqli_connect("localhost","root","","databaseName");

score 0 · Answer 2 · edited Jun 13 '17 at 07:00

0

You should read first http://php.net/manual/en/function.mysqli-connect.php.

$link = mysqli_connect("host", "my_user", "my_password", "my_db");

Try this:

$datbase=mysqli_connect("localhost","root","","my_db");
if(!$datbase)
{
    die("connection failed".mysqli_connect_error());
}

edited Jun 13 '17 at 07:00

Paul Karam

4,052
8
30
53

answered Jun 13 '17 at 06:20

Ahmed Ginani

6,522
2
15
33

score 0 · Answer 3 · answered Jun 13 '17 at 06:27

0

Replace this line with

 $datbase=mysqli_connect("localhost:82","root"," ");

with this one

   $datbase=mysqli_connect("localhost","root","","your database name");

answered Jun 13 '17 at 06:27

user2550096

11
1

score 0 · Answer 4 · edited Jun 13 '17 at 07:02

0

you are using port number on localhost that you are not set in php.ini file

try like this

//$datbase=mysqli_connect("localhost","username","password","databaseName");

$datbase=mysqli_connect("localhost","root","","databaseName");

edited Jun 13 '17 at 07:02

Ahmed Ginani

6,522
2
15
33

answered Jun 13 '17 at 06:31

score 0 · Answer 5 · answered Jun 13 '17 at 06:33

If your Mysql server is runs with default settings means . you don't need specify the port number . otherwise you need to specify port number as 5th parameter . like below Example .

Mysql default port number is 3306

$datbase=mysqli_connect("localhost","username","password","database_name","port_number");
if(!$datbase)
{
     die("connection failed".mysqli_connect_error());
}

when i used to connect with phpmyadmin using netbeans in php programming language i got some error

5 Answers5