cannot install php directory script to my host gator server-not connecting to dbase

i cannot access my database server to install a php script i purchased

When installing an link directory script i purchased onto my hostgator server i get this message:

Access denied for user 'MYUSERNAME@localhos'@'gator240.hostgator.com' (using password: YES)

Why is it saying this? I am typing in the correct password and user name that i entered in the cpanel mysql account maintainence section.I created a username and password into the mysql cpanel section. I gave it ALL the privilages. i made a database,used the localhost and it still didn't work,so i added my ISP host like %.myISP.com and it still doesn't work.i am typing in my username and password correctly and i even copied an pasted the username and password from cpanel.

inside cpanel here is my mysql settings:

Connection StringsPerl$dbh = DBI->connect("DBI:mysql:myusername_phplinkd:localhost" ,"myusername_myusername","<PASSWORD HERE>");PHP$dbh=mysql_connect ("localhost", "myusername_myusername", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("myusername_phplinkd");

UPDATE:

Ok now instead of saying this:

Access denied for user 'MYUSERNAME@localhos'@'gator240.hostgator.com' (using password: YES)

It is now saying this:

Access denied for user 'myusername'@'gator240.hostgator.com' (using password: YES)

UPDATE:

just a thought,would this have anything to do with the message i got when i first loaded the script. The test it done before the install ticked all of the boxes as supported except for this one:

Server API- CGI mode is likely to have problems.

This was the only thing that didn't test successfully and didn't have a tick next to it.

 

I installed recently for a friend at hostgator. This is what you should type when you run the phpld installer.

Host is localhost
user is siteusername_dbusername
DB is siteusername_dbname
Pasword is password you chose.

siteuser = cpanel login name

NOTE: mysql is case senstive User and user are 2 different words.

Now the only thing you can't see from you cpanel is the password you chose. Go there and copy the the info to notepad so you can see it while you run the install script.

BEFORE you do that make sure you have followed the directions about the proper chmod for the various directories and files.

 

thanks colbert,but it still doesn't work. and Yes i have done the giving the certain files 777 permission thingy. I don't know what is wrong. Maybe something is wrong with host gator's servers?

 

Error means you are entering wrong sql info..Submit a support ticket and ask them that what's the sql username and password..normally it is same as your cpanel login info.
Thanks,
Saad

 

it should be localhost (t missing)

In the mysql mgmt page, do you see localhost listed in the access list ? (near footer)

In the end, you can always get help from HG.