NaniG Posted February 16, 2012 Share Posted February 16, 2012 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..... Quote Link to comment Share on other sites More sharing options...
fenway Posted February 20, 2012 Share Posted February 20, 2012 I don't follow. Quote Link to comment Share on other sites More sharing options...
The Little Guy Posted February 20, 2012 Share Posted February 20, 2012 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. Quote Link to comment Share on other sites More sharing options...
NaniG Posted February 23, 2012 Author Share Posted February 23, 2012 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 25, 2012 Share Posted February 25, 2012 I cross checked in my databases and it doesn't contain the mysql database. No one knows what that means. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.