php can't connect to the mysql database

Question

here is my code

 $db_handle = mysql_connect('127.0.0.1', 'root', '123456'); if(!$db_handle) die(mysql_error())

when i was debugging the code just got a page with "This page can't be display", and the a pop up message from netbean said " Socket Exception occured", can anyone help? thanks

edit new code:

$db_handle = new PDO('mysql:host=localhost;dbname=test','admin','123456'); if($db_handle) echo 'connected';

it works, but the mysqli didn't work either

You shouldn't use the mysql_* functionality. You should be using the PDO object, or the mysqli functions. — christopher
– christopher, Commented Apr 11, 2013 at 18:20
Also it is a VERY VERY VERY VERY VERY VERY VERY bad idea to connect as root. — Ed Heal
– Ed Heal, Commented Apr 11, 2013 at 18:21
is your mysql set up to use tcp connections? generally it's not and defaults to local unixdomain sockets only. — Marc B
– Marc B, Commented Apr 11, 2013 at 18:21
I don't think there's a problem with your code. More likely there's something wrong with the setup of you web server. Are you able to run a php file with this code? phpinfo(); — Jules Colle
– Jules Colle, Commented Apr 11, 2013 at 18:22

Mayank K. Swami · Accepted Answer · 2013-04-11 18:23:44Z

1

Please stop using mysql_query for new project, use mysqli or PDO

Here a sample:

mysqli = new mysqli($host, $user, $dbpassword, $database); if (mysqli_connect_errno()) { printf("Connection failed: %s\n", mysqli_connect_error()); exit(); }

edited Apr 11, 2013 at 18:23

Mayank K. Swami

57.3k23 gold badges130 silver badges148 bronze badges

answered Apr 11, 2013 at 18:21

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

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

4 Comments

Marc B Over a year ago

I'd -1 for saying the db name is missing. it's an OPTIONAL parameter. but pushing for mysqli/pdo makes up for it.

pita Over a year ago

I tried your code too got the same error. Is it possible that the code is fine because the page even didn't show the connection error, maybe some configuration was wrong? I check the mysql workbench, the connection method is standard(TCP/IP)

Fabio Over a year ago

Are you sure port is set, database is running and there is no firewall rule block connection somewhow?

pita Over a year ago

@Fabio yes, I checked the mysql, and turned off the firewall, the problem is still there, getting crazy

pita · Accepted Answer · 2013-04-12 17:45:18Z

$db_handle = new PDO('mysql:host=localhost;dbname=test','admin','123456'); if($db_handle) echo 'connected';

Collectives™ on Stack Overflow

php can't connect to the mysql database

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related