Larry, > GRANT ALL ON dbname.* TO larry@"%" IDENTIFIED BY 'larry123'; > FLUSH PRIVILEGES; > > properly changes the mysql.user table. However, if I subsequently > attempt to use the mysql client like this > > mysql -h <myhostname> -u larry -p dbname > > and enter 'larry123' at the password prompt, I get an error: > > Access denied for user: 'larry@myhostname' (Using password: YES)
Please read this: http://www.mysql.com/documentation/mysql/bychapter/index.html#Connection _access When the server reads in the table, it orders the entries with the most-specific Host values first ('%' in the Host column means ``any host'' and is least specific). Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 24, 2002 10:37 AM Subject: wildcard '%' for host in mysql.user table broken --------------------------------------------------------------------- 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