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
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
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
grant all on *.* to root@'%.def.com'; /* The percent sign is your
wildcard character. */
flush privileges;
I don't think you need to flush privileges as of 5.0. I still do just
to be sure.
Curtis
[EMAIL PROTECTED] wrote:
Hi Parikh,
Yes.. It worked with IP i.e when I granted privileges