Can't connect to database.

roberto_badgio

hello, I am currently setting up a mysql databse, and I'm trying to conect to it through php.

the error message i am getting is:

Warning: Access denied for user: 'heighington@localhost' (Using password: YES) in /home/heighington/public_html/john2.php on line 12 Warning: MySQL Connection Failed: Access denied for user: 'heighington@localhost' (Using password: YES) in /home/heighington/public_html/john2.php on line 12 Unable to select database

I think this means that I have th name of the local host wring, but i have no idea what to put.

this is the code:


<?
$username="heighington";
$password="ccJWZKTf";
$database="heighington";

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

mysql_close();	
?>

I am currently using localhost, but read somewhere about using localhost:3306, but that came up with a parsing error.

has anybody got any ideas?

thanks.

LarsLai

hi!
if you did not change any users in mysql first try:

$username="root"; 
$password=""; 
$database="heighington";

if this does connect make sure you have set your username and password
right in the 'user' table of database 'mysql'

roberto_badgio

HI, soory, i tried to do that , but it didn't work. (thanks anyway)

this is the error i got:

Warning: Access denied for user: 'root@localhost' (Using password: NO) in /home/heighington/public_html/john2.php on line 12 Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /home/heighington/public_html/john2.php on line 12 Unable to select database

do you think I don't the right access to the database then?

if this does connect make sure you have set your username and password
right in the 'user' table of database 'mysql'

umm. . . sorry don't understand what you mean here. I only have one database im using at the moment, and Im using phpmyadmin, if this is any help.

Does the fact that the account is a reseller account, and i have a part of a larger account change anything (It's not a subdomain, but a real domain).

tsinka

Hi,

make sure that the mysql.user table contains a record with Host='localhost', User='heighington' and Password=PASSWORD('ccJWZKTf') and set the privilege flags to your needs.

After that restart the database or execute the query

FLUSH PRIVILEGES

Alternatively, create a user with hardly any privileges in mysql.user and grant the privileges through mysql.db

Thomas

roberto_badgio

ok, I've just seen on phpmyadmin that i have no privileges, so I think i need to contact the person that owns the main account for my site, because it's a reseller account.

Thanks anyway.

Robet.