Michael,

Friday, February 15, 2002, 4:08:42 PM, you wrote:

MH> Hi mysql list members,

MH> We use the following statements to setup users and rigts for a mysql
MH> server which is accessible locally and via internet:

MH> INSERT INTO mysql.user VALUES 
MH> ('%','xyz00',PASSWORD('...'),
MH>  'N','N','N','N','N','N','N','N','N','N','N','N','N','N');

MH> INSERT INTO mysql.db VALUES
MH> ('%','xyz00_%','xyz00','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

MH> The server runs on 66.70.34.150:3307. We can connect via socket locally
MH> and via Host:Port remote:

MH>         remote-system> mysql -h 66.70.34.150 -P 3307 -u xyz00 -p
MH>         => works

MH>         local-system> mysql -S /var/run/mysql-ext/mysql.sock -u yxz00 -p
MH>         => works

MH> But we can NOT connect locally by host:port:

MH>         local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
MH>         => ERROR 1045: Access denied for user:          'xyz00@localhost' (Using
MH> password: YES)

MH> On a mysqld which is accessible only locally the both INSERT statements
MH> above would have  "localhost" instead of "%".  Why does "localhost" not
MH> qualify for "%"?  Do we have to double the entries, having separate ones
MH> for localhost?  It does not make sense, does it?

When you set '%' or '66.70.34.150' for entries in table 'user' 
that means you can access via TCP/IP, if you set 'localhost' that 
means you can connect to the database through unix socket.

Please, look in the manual:
        http://www.mysql.com/doc/C/o/Connection_access.html
        http://www.mysql.com/doc/A/c/Access_denied.html
        http://www.mysql.com/doc/A/d/Adding_users.html

MH> Thanks
MH>         Michael





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




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

Reply via email to