checking database setup

andynightingale

Can anyone tell me how to check if a mySQL database has been set up for me by an ISP? I have all the connection details and have used them in phpMyAdmin but it through up an error "
#1045 - Access denied for user: 'signalpumps@213.171.218.20' (Using password: YES)"

I tried:

<?php
$Host = "xxxxxxxx";
$User = "xxxxxxx";
$Password = "xxxxxx";
$DBName = "xxxxxxx";
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php 
$_conn = @mysql_conn($Host,$User,$Password,$DBName); 
if ( $_conn ) echo 'conn establsihed'; 
else echo 'conn not established'; 
?>
</body>
</html>

or is there an easier way of doing it? If it isn't set up and they have told me it is what can I ask them. They hadn't set up execute scripts for me when I asked them I was using php so I am a bit dubious!

Ulysses_Freeman

This is how I do my connection to the server:

 $dbcnx = mysql_connect("localhost", "account", "password");
if(!$dbcnx) {
  echo ("<p>Unable to connect to the ". 
 "database server at this time.</p>");			
  exit();
} else {			}

marky2coats

#1045 - Access denied for user: 'signalpumps@213.171.218.20' (Using password: YES)"

Usualy means that your username and password have not been set up or given the correct permissions to access the database.

Contact your ISP and ask them to confirm the login details.

PS. They may have set up signalpumps@% instead of signalpumps@213.171.218.20 in which case it needs changing.

Mark

andynightingale

I have confirmed all the connection details, ie Host, username, password and database name, so it isn't that.

I don't understand where 'signalpumps@213.171.218.20' comes from, apart from being the username along with a domain (not that of the server or site as far as I can tell) It's not the password or username that I have.

So I'll have to follow up the access/permission route with the ISP.

andynightingale

I have also tried using telnet to access the ip address that I was given for my database and get ' The remote host refused the connection' What is the problem and is it the ISP side or me?

marky2coats

What port did you connect to? If you tried the standard telnet port (23) then its very likely that the server has this port/service disabled.

The fact that you are getting:

#1045 - Access denied for user: 'signalpumps@213.171.218.20' (Using password: YES)"

Means you are connecting to mysql server fine but you not getting authenticated.

Also you say signalpumps is not your username? Then why is your PHP trying to connect to the server with that?

Mark.

andynightingale

Sorry signalpumps is the username. If I'm not getting authenticated, what is wrong with the deatils I was given... the password?

BuzzLY

I don't understand this line:

$_conn = @mysql_conn($Host,$User,$Password,$DBName);

Is "mysql_conn" your own personal function? Because it's not a PHP function. The correct PHP function is mysql_connect, and the (optional) 4th parameter is not a database name. It's a boolean flag for new_link. So, this line SHOULD read:

$conn = @mysql_connect($Host,$User,$Password);
mysql_select_db($DBName);

If changing that does not fix your problem, I'm not sure what's going on -- can you use that username/password to view the database in phpMyAdmin?

andynightingale

Yes I have used the username and password in phpMyAdmin, but get #1045 - Access denied for user: 'signalpumps@213.171.218.20' (Using password: YES)"

BuzzLY

My question was "were you able to view the database." In other words, can you SUCCESSFULLY use the username and password in PHPMyAdmin? If not, the problem is in the permissions for your username/password, not your code. Talk to your database administrator.

andynightingale

<?php
$Host = "xxxxxxxxxx";
$User = "xxxxxxx";
$Password = "xxxxx";
$DBName = "xxxxxx";
?>

<body>

<?php
$conn = @mysql_connect($Host,$User,$Password) or die(mysql_error()); 
mysql_select_db($DBName);  

if(!$conn){ 
echo_("<p>Unable to connect to the database server at this time.</p>"); 
} else if (!$conn)
echo ("connected!!!");
exit();
?>

</body>
</html>

see: http://www.signal-pumps.co.uk/test.php
gives me 'Access denied for user: 'signalpumps@213.171.218.20' (Using password: YES)'

andynightingale

I think its time to talk to the ISP who set this up!!!!
Thanks all for your help.