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
