Difficulties connecting to DB on WEB Server

[groo_78]

Hey,

I've checked the internet, these forums, and pretty near everywhere you can imagine and even the books i have don't have any suggestions.

I recently installed APACHE/PHP/MYSQL on my XP machine and started working with it and i produced a web page and it works la de da. A friend of my has web space through MediaTemple with php/mysql support so he is letting me use about 20 mgs and i tried the same code but to no avail. My code gives me the following error:

Connected successfully Access denied for user: '@localhost' to database 'database_name'

and my code is:

$connection = mysql_pconnect("localhost")
or die(mysql_error());

print ("Connected successfully\r\n");

mysql_select_db("database_name", $connection)
or die(mysql_error());

I have tried adding the mysql_pconnect("localhost", $username, $password) but i get the same error.

Although i have some past experience with ASP/Oracle/Access , i have always had an admin set me up - ie - give me the ftp foler to upload my files and the connection string was supplied. I don't even know exactly what files to upload!! I pretty much just uploaded the folder titled 'database_name' from c:\mysql\bin. THe only files in the folder are *.frm files. ANy suggestions?

Thanks in advance.

[ruturajv]

please ask your friend for the complete username and password for mysql dB
that is where your problem is !

[groo_78]

The database was created by myself. It is just a simple test. I didn't user a Username or Password when i created it. I tried adding one and it worked fine when i ran it locally on my machine but after i uploaded it and tried using:

mysql_pconnect("localhost", $username, $password)
or die(mysql_error());



i had the same problem.