Help need for Grant Privileges...

[nomad]

Hello Everyone.
I need some help in create Privileges for a new db.
I'm using a host call addr.com and I hate them for there cpanel sucks.
any I hav to write a MySQL to Grant All Privileges for a user to use a db.

Here is my code

GRANT ALL
on allyson.blog    //allyson is the db and blog is the table
TO [e-mail]  // trying to make a new user
IDENTIFIED BY "12345";

I get this error code:
MySQL said:

#1044 - Access denied for user: '[e-mail].%' to database 'mysql'

Note this is a new db with a table called blog_db with one field.
Since addr.com us no real cpanel I don't know what Privileges the db has

I'm also using phpMyAdmin 2.6.2 but they have no localhost set up window.

Any help would be great...
nomad
PS I set up to use wordpress.

[Atli]

Hi.

The problem there is that the user that you are using to execute your GRANT command does not have the privileges required to GRANT privileges.

Doesn't the cPanel have a feature that allows you to modify database privileges?
That is at least how my host has it set up for me.

[nomad]

Hi Atli:
No in the cpanel there is no hardly anything in it. I wrote to the company and I hope they get back to me. I will never use addr.com again. Once my wife contract is over I will transfer it to another host site.
Thank so far any other ideals
damon