Hi Parikh,
Yes.. It worked with IP i.e when I granted privileges to 'root'@'ip of
my machine' and flushed it, it worked fine. But I have a qestion below:
GRANT ALL PRIVILEGES ON *.* to 'root'@'IP';
FLUSH PRIVILEGES;
However, Would '*.def.com' work in the place of IP?, as I feel that
giving privileges for each IP for each machine that is going to access
the mysql server would be tedious and not recommended choice. Please let
me know.
Regards
Ahmad
-----Original Message-----
From: Parikh, Dilip Kumar [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2008 3:34 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..
Ok It means that DNS not configured so better give the IP address
instead of hsostname and check using in mysql as
Show grants for [EMAIL PROTECTED];
This should show u the grants
Thanks & Regards,
Dilipkumar
MphasiS an EDS Company | No 25,Steeple Reach,Cathedral Road | Chennai |
India | 91 44 28113801 |Extn 2216
Mobile: 9884430998 | 9962029004
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2008 3:30 PM
To: Parikh, Dilip Kumar; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
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
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
