Problem with mysql !!!!

[Anon]

i wrote below code and the output says "Connected to serverAccess denied for user: '[e-mail]' to database 'messageboard' "..on linux ??? what does it mean ??? is something wrong with this code or anyother problem?? please help me..i had put my password,user name and database name on connect.php.
thankz

<?
include("./connect.php");

$result= mysql_query("create database $db");
if(!$result)
{
print mysql_error();
exit();
}
else
{
print("Database created");
}
?>

[kailien]

Perhaps, the user name is just "john" and not "[e-mail]"

Or, the passward could be wrong

Or, you do not have access / rights to create databases on the MySQL server

Do you want to create a new table on the database $db or do you want to create a new database $db?

Try perform a query. If it works, then you know you do not have the rights to create databases. Just change the permissions / rights for user John or [e-mail].

Cheers...

Kai

[mdmann]

Try granting create privilege to [e-mail] using the following command from within MySQL:

grant create on messageboard to [e-mail] identified by "<your password>"

If you need other types of access, you will need to modify this grant command
accordingly. For example, if you want to have complete access to all the database
manipulation commands you should do

grant all on messageboard to [e-mail] identified by "<your password>"

M.