Re: Problem - "Host 'abc.def.com' is not allowed to connect to this MySQL server", Please advice..

#1 (**permalink**) 07-14-2008, 05:46 PM

make sure to FLUSH PRIVILAGES;

----- Original Message ----
> From: "ahmadbasha.shaik@wipro.com" <ahmadbasha.shaik@wipro.com>
> To: dilipkumar.parikh@eds.com; mysql@lists.mysql.com
> Cc: raghavendra.hosabettu@wipro.com
> 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, Idid not mention this in my earlier
> mail. Can you please let me know ifthere is any other way out.
>
> Regards
> Ahmad
>
> -----Original Message-----
> From: Parikh, Dilip Kumar [mailto:dilipkumar.parikh@eds.com]
> 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: ahmadbasha.shaik@wipro.com [mailto:ahmadbasha.shaik@wipro.com]
> Sent: Monday,July 14, 2008 3:21 PM
> To: mysql@lists.mysql.com
> Cc: raghavendra.hosabettu@wipro.com
> Subject: Problem - "Host 'abc.def.com' is not allowedto 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 theMySQL 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/mysql?unsub=d...parikh@eds.com
>
>
> 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 privilegedinformation. 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/mysql?unsub=g...ll@yahoo.co.uk

__________________________________________________ ________
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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode