Hi.
First, for some reason, I got your email three times (both, personally
and to the list - once to both would be okay).
On Tue 2002-07-23 at 12:30:38 -0700, [EMAIL PROTECTED] wrote:
> Understand.
> But, how to "use IP addresses instead of hostnames"?
The only context where you use hostnames in connection with the MySQL
server is when you grant privileges to people. Usually you grant those
to a user@hostname combination (as login/username). This is where you
should use user@ip instead, i.e. whenever you use the SQL statements
GRANT/REVOKE.
For example, if your client host has the name mine.funny.com and the
IP 192.168.254.3 and you want to grant yourself some privileges from
the superuser account, usually you would write something like:
GRANT SELECT,INSERT,DELETE,UDPATE ON yourdb.*
TO 'hk_tang'@'mine.funny.com'
IDENTIFIED BY 'whatever'
Using the IP instead the hostname you would write
GRANT SELECT,INSERT,DELETE,UDPATE ON yourdb.*
TO 'hk_tang'@'192.168.254.3'
IDENTIFIED BY 'whatever'
Greetings,
Benjamin.
> > > WARNING: The host 'ed.airtiger.com' could not be
> > > looked up with resolveip.
> > > This probably means that your libc libraries are
> > not
> > > 100 % compatible
> > > with this binary MySQL version. The MySQL deamon,
> > > mysqld, should work
> > > normally with the exception that host name
> > resolving
> > > will not work.
> > > This means that you should use IP addresses
> > instead of
> > > hostnames
> > > when specifying MySQL privileges !
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
