probling when create databse on remote server

[popmotsy]

hii,,I m using shared web hosting,,i m creating a installer script to create database on remote server,,but i always get the warning mesg,,

 

,,Access denied for user 'user'@'host' (using password: NO) in xxxxxxxx installer.php on line 14

Cannot Connected With Database.....

 

can any one know abt this problem,,,please suggest me the proper solution....

 

thanks..

[Daniel0]

Your username and/or password is wrong or that particular user is not allowed to login from the server where your script is.

[popmotsy]

thanks for replying,,,,,,

 

but is there any wayy to allow that user to login from the server where the script is,,,,,,

 

thankss,,,,,

[Daniel0]

Yeah. Do you have some sort of control panel you are managing your MySQL server with, or are you using the CLI console?

[popmotsy]

hiiii....

 

well i told that ,,,i m using shared web hosting,,,and control panel is not provided with that,,,i m just using php script just like that,,,,,

 

<?php

 

$sql[]="create database xxxxx_database";

 

$host = "hostname";

$user = "username";

$dbpassword = "password";

 

$connection = mysql_connect($host, $user, $dbpassword) or die("Cannot Connected With Database");

mysql_select_db("cpv_database", $connection) or die("Database is not selected");

 

for($i=0;$i<count($sql);$i++)

{

$result = mysql_query($sql[$i]) or die('<li>$sql :'.$sql[$i].mysql_error());

echo '<li>'.$i.'sql to run -->:'.$sql[$i].'<br />';

}

 

........

 

and run on the server ,,,and i got that damn warning again and againn.... >...

 

 

 

 

 

 

 

[Daniel0]

You'll have to contact your host to get them to set the permissions then.

[popmotsy]

permission for creatin database,,,,,????

[Daniel0]

Permission to connecting. It's probably set to only allow connections from localhost. Again, you'll have to contact your host if you cannot change the permissions yourself.

[popmotsy]

well....thanks for help...hope that will solve my issue.....