cannot get a connection to MySQL in php

Question

I have this simple code:

<?php
//Open the mySQL connection
$conn_string = "'localhost', 'Vale', 'test'";
$dbh = mysql_connect($conn_string);

//Check that a connection with the DB has been established
if (!$dbh) 
{
   die("Error in MySQL connection: " . mysql_error());
}
...

And I get the error: Error in MySQL connection: php_network_getaddresses: getaddrinfo failed: The requested name is valid, but no data of the requested type was found.

I cannot figure out what the problem is, I have been google-ing but all the suggestions have failed (tried 127.0.0.1 instead of localhost, 127.0.0.1:3306, etc.)

I have code that works with postgre, but I need to use mysql, and I am trying to modify it, but I cannot pass the first line and get a connection. Any suggestion, please? Thank you!

Community · Accepted Answer · 2023-11-17 20:33:26Z

4

mysql_connect doesn't take a comma seperated string. It takes 3 individual strings. Change it to this:

$dbh = mysql_connect($server, $mysql_user, $password);

If you absolutely have a comma separated string, and can't get around this, you can split the string like this:

 $config = str_replace("'", '', $conn_string); // replace the quotes.
 $config = preg_split('/,/', $conn_string); // split string on ,
 if($config != $conn_string) { // make sure this returned an array
     count($config) === 3 OR die("Invalid database configuration string");
     $dbh = mysql_connect($config[0], $config[1], $config[2]);
     if(FALSE === $dbh) {
         die("Coult not connect: " . mysql_error());
     }
 }

edited Nov 17, 2023 at 20:33

CommunityBot

11 silver badge

answered Mar 24, 2014 at 1:06

Ryan

14.7k9 gold badges68 silver badges104 bronze badges

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

1 Comment

user Over a year ago

Thank you, I just realized that! New to MySQL, in Postgre it worked.

Logan Wayne · Accepted Answer · 2014-03-24 01:16:58Z

1

You might want to consider MySQLi, instead of MySQL.

<?php

$dbh=mysqli_connect("localhost","Vale","Password","test"); /* Vale is your username? And the name of your database if test, right? And your Username's Password is blank? */

if(mysqli_connect_errno()){

echo "Error".mysqli_connect_error();
}

?>

edited Mar 24, 2014 at 1:16

answered Mar 24, 2014 at 1:10

Logan Wayne

5,98716 gold badges33 silver badges50 bronze badges

1 Comment

Nathan Dawson Over a year ago

You should probably make it clear for the OP that the 3rd argument that's a blank string is actually the DB password.

Community · Accepted Answer · 2023-11-17 20:24:57Z

0

As other users have pointed out mysql_connect expects the database, username, and password as separate arguments rather than a single string.

I think another highly important issue to point out is that this particular extension is deprecated.

Please see: https://www.php.net/function.mysql-connect

A better solution would be to use mysqli_connect: https://www.php.net/manual/en/function.mysqli-connect.php

$db = mysqli_connect( 'localhost', 'Vale', 'test', 'yourDatabaseName' );

edited Nov 17, 2023 at 20:24

CommunityBot

11 silver badge

answered Mar 24, 2014 at 1:11

Nathan Dawson

19.4k3 gold badges59 silver badges60 bronze badges

Comments

Community · Accepted Answer · 2023-11-17 20:33:26Z

0

mysql_connect requires three argument not single string

$dbh = mysql_connect('localhost', 'Vale', 'test');

edited Nov 17, 2023 at 20:33

CommunityBot

11 silver badge

answered Mar 24, 2014 at 1:07

Tamil Selvan C

20.3k12 gold badges55 silver badges72 bronze badges

Collectives™ on Stack Overflow

cannot get a connection to MySQL in php

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related