SQL DB connect error

[Coolmaty]

I am getting this error whenever to install my scripts to the main site.


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'cool'@'localhost' (using password: YES) in /home/coolmaty/public_html/sources/sql/mysql.php on line 32

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/coolmaty/public_html/sources/sql/mysql.php on line 33


Need help.

Thanks in advance

 

[tnl2k7]

Have you created and linked the database user to the database in the MySQL databases section of cPanel? You'll need to do this before the database will be useable by any scripts.

-Luke.

 

[Coolmaty]

Yes, i have created a db : coolmaty_Cool
and user as : coolmaty_user

 

[tnl2k7]

Have you linked the database user to the database though? This can be done via cPanel on the same page you make the accounts and SQL databases. When prompted, select the all privileges checkbox at the top.

-Luke.

 

[Coolmaty]

Yes, i have enabled all the privileges.

 

[tnl2k7]

Okay, try installing your script again now then, using the information you posted previously. I think you may have mistyped something, as the permissions all seem correct. Please post back telling us whether it worked or not, if it doesn't work the exact errors would be useful .

-Luke.

 

[Coolmaty]

I am redoing [SQL db] again.

 

[tnl2k7]

Okay, post back when you've got news on whether it's working or not .

-Luke.

 

[Coolmaty]

Can i post images?? so that it will give a idea about what i am receiving?
Edit: Tried to refer MySQL manual 5.0 but it didn't help, as i always got #1064 error.

 

[Christopher]

You can post images.

 

[tnl2k7]

I helped you with this yesterday and the script worked fine when I left you. What happened?

-Luke.

 

[Coolmaty]

oops!! accidentally the db's got deleted [deleted it accidentally] as power backup went off all of a sudden.