make sure to FLUSH PRIVILAGES;
----- Original Message ---- > From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED]; mysql@lists.mysql.com > Cc: [EMAIL PROTECTED] > Sent: Monday, 14 July, 2008 10:59:35 AM > Subject: RE: Problem - "Host 'abc.def.com' is not allowed to connect to this > MySQL server", Please advice.. > > Hi, > > I did that too, > > I executed the command -> GRANT ALL PRIVILEGES ON *.* to > 'root'@'localhost' ; > I tried also GRANT ALL PRIVILEGES ON *.* to 'root'@'abc.def.com' ; where > abc.def.com is my machine name > > But both of these did not work, I did not mention this in my earlier > mail. Can you please let me know if there is any other way out. > > Regards > Ahmad > > -----Original Message----- > From: Parikh, Dilip Kumar [mailto:[EMAIL PROTECTED] > Sent: Monday, July 14, 2008 3:26 PM > To: Ahmadbasha Shaik (WT01 - E-ENABLING); Raghavendra Hosabettu (WT01 - > Innovation Group) > Subject: FW: Problem - "Host 'abc.def.com' is not allowed to connect to > this MySQL server", Please advice.. > Importance: High > > > Hi all, > > First try checking out the grant for the particular user ? > > Show grants for user@'abc.def.com'; > > If u don't find the results u can give grant as :- > > Grant select on *.* to user@'abc.def.com' identified by 'xxxx'; Flush > privileges; > > > > Thanks & Regards, > Dilipkumar > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, July 14, 2008 3:21 PM > To: mysql@lists.mysql.com > Cc: [EMAIL PROTECTED] > Subject: Problem - "Host 'abc.def.com' is not allowed to connect to this > MySQL server", Please advice.. > Importance: High > > Hi All, > > I am facing a particular problem which i have explained here. Can > you please let me know a solution for this. > > From my web application, I am trying to connect the MySQL server by > using the IP address as the server name, and it says the following > error: > "Host 'abc.def.com' is not allowed to connect to this MySQL server" > > Options that I tried: (from the information availabe on internet) > a) I tried modifying the hosts file in WinNT directory to include this > host name (assuming that it was not understanding the IP), but it did > not work > b) I tried adding a record with the IP as host and user as root in user > table of mysql database it did not work > c) I tried adding a record with the 'abc.def.com' as host and user as > root in user table of mysql database it did not work > d) I tried enabling "Remote Access" in MySQL Server instance config > wizard but since the root users password is not set, it is not allowing > me go forward (i.e. the next button is disabled) > e) If I try to reset the password while configuring the MySQL Server > Instance, it does not allow me to do so > f) I tried adding a record with the '%' as host and user as root in user > table of mysql database it did not allow me to add the record > > Regards > Ahmad > > Please do not print this email unless it is absolutely necessary. > > The information contained in this electronic message and any attachments > to this message are intended for the exclusive use of the addressee(s) > and may contain proprietary, confidential or privileged information. If > you are not the intended recipient, you should not disseminate, > distribute or copy this e-mail. Please notify the sender immediately and > destroy all copies of this message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient > should check this email and any attachments for the presence of viruses. > The company accepts no liability for any damage caused by any virus > transmitted by this email. > > www.wipro.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > Please do not print this email unless it is absolutely necessary. > > The information contained in this electronic message and any attachments to > this > message are intended for the exclusive use of the addressee(s) and may > contain > proprietary, confidential or privileged information. If you are not the > intended > recipient, you should not disseminate, distribute or copy this e-mail. Please > notify the sender immediately and destroy all copies of this message and any > attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient should > check this email and any attachments for the presence of viruses. The company > accepts no liability for any damage caused by any virus transmitted by this > email. > > www.wipro.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __________________________________________________________ Not happy with your email address?. Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]