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