MySQL Error

[NaniG]

Hi to all,

 

  I have database and it contains mysql database. I already given the privileges to these database.

Here is the privilege command...

 

GRANT ALL PRIVILEGES ON dbname.* TO root@'%' IDENTIFIED BY 'pwd';
FLUSH PRIVILEGES;

 

I have another database hosted into another IP Address. Now i wanted to access these database from my local database to get the result.

 

when am trying to give the privileges, am getting the MySQL Error 1044 and 1045.

 

Please help me out from these issue.

 

Thanks in advance.....

[fenway]

I don't follow.

[The Little Guy]

I don't follow.

Was it the part where his database contains a database?

 

Any who, I think what is wrong. Is your granting privileges while on the wrong host. Maybe I am wrong though.

[NaniG]

Okay let me clarify first

 

When i gave grant privileges, got 1044 and 1045 MySQL Error.

 

I cross checked in my databases and it doesn't contain the mysql database.

 

So how can i grant all privileges to a particular host.

 

Thanks in advance.

 

 

[fenway]

I cross checked in my databases and it doesn't contain the mysql database.

No one knows what that means.