Unable to connect to MySQL database!

[malaysiauser]

Im new user of PHP and MySQL.

I tried to use a script package for my web. I'd created a database.
And my connection scripts are as follow;

[PHP]<?php

$mysql_host="lo calhost";

$mysql_username ="hidden";

$mysql_password ="hidden";

$mysql_database ="hidden";

$site_name="My Share Host"; //name of your site

$site_url="http ://hidden"; //full url of your site without trailing slash!

//------------------------------------------------------------

//-----------Do not modify anything under this line!----------

//------------------------------------------------------------



$dbhandle=mysql _connect($mysql _host,$mysql_us ername,$mysql_p assword);

@mysql_select_d b($mysql_databa se) or die("<div align=\"center\ ">Unable to connect to MySQL database!</div>");

$query="SELECT server FROM ftp_connection WHERE 1";

$result=mysql_q uery($query);

$ftp_server=@my sql_result($res ult,0);

...and some other functions here...



mysql_close($li nk);

?>[/PHP]


It gives error:


Unable to connect to MySQL database!

Someone please guide me.

Thank you very much.

[malaysiauser]

when i entering from another computer....

this is the error message:

锘?div align="center"> Unable to connect to MySQL database!

[r035198x]

when i entering from another computer....

this is the error message:

锘?div align="center"> Unable to connect to MySQL database!

Are you able to connect to MySQL from the console using those details?

[mwasif]

Do not use words like HELP PLEASE in title. Kindly use CODE tags when posting source code.

Use mysql_error() when connecting to DB to know the correct error. e.g.

[PHP]$dbhandle=mysql _connect($mysql _host,$mysql_us ernam e,$mysql_passwo rd) or die("Error: ".mysql_error() );

mysql_select_db ($mysql_databas e) or die("<div align=\"center\ ">Unable to connect to MySQL database! Error: ".mysql_error() ."</div>");[/PHP]
After using this code, what error do you get?

[malaysiauser]

pls check my site www.digimage,in fo

the error is unable to connect to mysql

[mwasif]

Did you use mysql_error() when connecting to database as I suggested in my previous post?

[malaysiauser]

Unable to connect to MySQL database! Error: Access denied for user 'digimage'@'loc alhost' to database 'filehost'

i'd created a database "filehost" with a username and password.
So in my php setting i use that username and password.
And for that user i select 'allow all'. But i still getting access denied.
Im using cpanel.

tq sir..

[malaysiauser]

i try to add another user and got this error;


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'digi'@'localho st' (using password: YES) in /home/digimage/public_html/settings.inc.ph p on line 23
Error: Access denied for user 'digi'@'localho st' (using password: YES)


im using cpanel to manage my MySQL database.

any idea?

[mwasif]

Unable to connect to MySQL database! Error: Access denied for user 'digimage'@'loc alhost' to database 'filehost'

i'd created a database "filehost" with a username and password.
So in my php setting i use that username and password.
And for that user i select 'allow all'. But i still getting access denied.
Im using cpanel.

tq sir..

In CPanel, username and database are started with your hosting account username. e.g. if you have created a user named 'digimage' then it should be something like hostingusername _digimage and the same with the database name.