> > Can I just hand delete the records that I manually inserted?
> If you are brave and sure in yourslef.
I'm not really that brave, it's just that I didn't have
a choice - it appears to have worked fine - I am now
able to connect using the GUI tool.
> > What is the syntax of the grant?
> > Is it wrong to hand edit these tables? root with the
> > password "new_password" is a valid logon for this db.
> Don't touch MySQL privilege tables, except host table.
> That way you just mess up the things, as you did.
> Use GRANT / REVOKE / SET PASSWORD ..
OK - fair enough - two q
> > We want to use the Windows GUI tool to connect to a database on
> > a Linux box.
> You have to grant privileges to user@ip_address and enter ip_address
> in host table. Or grant privilege to user@"%".
I entered these records by hand from the
> ./mysql -u root -p mysql command line to
Hi all,
We want to use the Windows GUI tool to connect to a database on
a Linux box.
However, after trying to configure it and attempting to connect,
we get a message along the lines of "Host 'ip_address' not allowed to
connect
to this MySQL server".
I'm sure that this is some silly confi
