Connecting to mySQL on localhost

Question

So I'm having an issue connecting to a mySQL database I created on my local host using XAMPP. The DB itself is set up fine on 127.0.0.1, but I had to use port 8000 (instead of 80) to get it to start in XAMPP.

  $con = mysql_connect("localhost:8000","","");
 if (!$con) {
   die('Connection failed.' . mysql_error());
 }

The above doesn't work, the browser times out after a few seconds saying it cannot display the webpage (note that it doesn't give the die message). I have also tried 127.0.0.1:8000 but no luck. Creating a user in phpMyAdmin and entering the credentials didn't achieve anything either.

If I take out the port and just use:

$con = mysql_connect("localhost","","");

This connects, but I can't seem to select my database because I don't think it's connecting to the right server!

Any ideas? Thank you in advance!

Please, don't use mysql_* functions in new code. They are no longer maintained and the deprecation process has begun on it. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — Madara's Ghost
– Madara's Ghost, Commented Nov 24, 2012 at 19:45

BenMorel · Accepted Answer · 2014-05-18 21:19:40Z

3

Do not use mysql_*it is deprecated
Port 8000 is for your server not mysql. Default mysql port 3306

You better of using PDO

http://www.php.net/manual/en/pdo.construct.php

edited May 18, 2014 at 21:19

BenMorel

37k52 gold badges208 silver badges339 bronze badges

answered Nov 24, 2012 at 19:44

E_p

3,14419 silver badges30 bronze badges

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

Comments

user1824546 · Accepted Answer · 2012-11-24 19:53:56Z

1

remove port 8000 .This is not mysql port.

answered Nov 24, 2012 at 19:53

user1824546

297 bronze badges

Comments

Gillian Lo Wong · Accepted Answer · 2012-11-24 19:53:59Z

1

The port for MySQL is 3306. But you dont have to use that in your php code.

The reason why you cannot select your database is because you never specified that in your script. Hence, try the mysql_select_db function.

Like so:

mysql_connect('localhost','user', 'pass');
mysql_select_db('database_name');

If you plan on using this code for a bigger system, its better to use prepared statements like madara-uchiha suggested. It wont be long until these functions will print depreciation notices in your application ;)

edited Nov 24, 2012 at 19:53

answered Nov 24, 2012 at 19:47

Gillian Lo Wong

9,7125 gold badges36 silver badges38 bronze badges

Comments

000 · Accepted Answer · 2012-11-24 19:54:55Z

1

You may also use mysqli

<?php $con = new mysqli("localhost", "username", "password", "dbName");
if ($con->connect_errno) {
echo "Failed to connect to MySQL: (".$con->connect_errno.")".$con->connect_error;
}
?>

answered Nov 24, 2012 at 19:54

000

3,9404 gold badges27 silver badges40 bronze badges

Collectives™ on Stack Overflow

Connecting to mySQL on localhost

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related