access denied

[benbramz]

im just starting to get to grips with mysql using php.

i set up my first database not long ago, and i tried to connect to it using the following:

Code: Select all

<?php
// Connecting, selecting database
$dbh=mysql_connect ("localhost", "tuggersc_gavtest", "<tuggers_gavtest>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("tuggersc_gavssqltest"); 
// Performing SQL query
$query = 'SELECT * FROM my_table';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $col_value) {
       echo "\t\t<td>$col_value</td>\n";
   }
   echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?>

following this tutorial from php.net http://www.php.net/manual/en/ref.mysql.php(bout 30% down.)
but it says when i try to view the file

Warning: mysql_connect(): Access denied for user: 'tuggersc_gavtest@localhost' (Using password: YES) in /home/tuggersc/public_html/fantasy-league-test/mysql_test/test.php on line 11
I cannot connect to the database because: Access denied for user: 'tuggersc_gavtest@localhost' (Using password: YES)

the location is http://www.tuggers.co.uk/fantasy-lea..._test/test.php

cheers all

[Rob]

This really does look like you've got something wrong.

Double check the server name, database name, username and password.
I'm fairly sure something isnt quiet right there looking at the error message

[benbramz]

the connection string was copied from cpanel, so i would guess that it was correct....

i havnt changed anything on it. except putting the password in. what could it be...?

[Webforumz Staff]

That exact same code works fine here.

You must be using either the incorrect servername, username, password or perhaps you're trying to access a table that you don't have rights to access. Check all these things again.

[benbramz]

i dont think ive set up a table yet, would that be why? i just set up the database stright from cpanel u see. so i dont know if there would be a table already made......

[Webforumz Staff]

If the table didn't exist, you would get a different error with details of the table that could not be accessed.

There must be a problem with either the hostname, database name or password.

[benbramz]

ive checked the username and password, and they are fine. so it must be sothing to do with the host name. i have it at local host, which was the example i used. but what is an example of a hostname. its on a web host at zmb.co.uk

im stumped lol

[Webforumz Staff]

It's usually localhost, but some hosts choose to have a seperate mysql server... they should tell you this!

[benbramz]

ive flagged a post on the admin support section. ill see what they have to say and get back to u

[Tim356]

Any luck?

[benbramz]

have i eck

i wsubmitted a ticket and then somthing went wrong with the ticket section of the site. theres no a box that says Unauthorized Version Installed and a box to enter a lisence code.

so ive been waiting for them to fix that.

but now ive had enough!
lol