Phrixus
Phrixus

Reputation: 319

How can I connect to MySQL on a WAMP server?

This might be ridiculously easy for you but I've been struggling with this for an hour... :(

<?php
$connect = mysql_connect("localhost:8080", "root", "mypassword");
echo($connect);?>

This is the code that I'm trying to run - you can see that I'm using 8080 as my port number and, of course, I have HTML codes as well.

However, it gives me the following error messages whenever I try to open the PHP file:

Warning: mysql_connect() [function.mysql-connect]: MySQL server has gone away in C:\wamp\www\php_sandbox\index.php on line 2

Warning: mysql_connect() [function.mysql-connect]: Error while reading greeting packet. PID=4932 in C:\wamp\www\php_sandbox\index.php on line 2

Warning: mysql_connect() [function.mysql-connect]: MySQL server has gone away in C:\wamp\www\php_sandbox\index.php on line 2

I don't know... what's wrong with this? Is it because of the port number?

Upvotes: 13

Views: 121635

Answers (3)

Snehasis Mohapatra
Snehasis Mohapatra

Reputation: 1

Just Change the Connection mysql string to 127.0.0.1 and it will work

Upvotes: 4

Kevin
Kevin

Reputation: 13226

Try opening Port 3306, and using that in the connection string not 8080.

Upvotes: 4

JonnyLitt
JonnyLitt

Reputation: 773

Change localhost:8080 to localhost:3306.

Upvotes: 25

Related Questions