Hi fellow mysql'ers

Here my "simple" problem

I can connect to the mysql server host from any other host, but I cannot
from the host with the mysql server.

More detail

Mysql 3.23.30-gamma (yea I know I need to update it)

Example user is foo, password is bar

Columns_priv, func, and host are empty

In table user

Host            user     password
localhost       foo    7c9e0a41222752fa all priv's are Y
%               foo    7c9e0a41222752fa      ''
%.mydomain.com  foo    7c9e0a41222752fa      ''

table db has in it

host            db       user
%               test     (empty)      all priv's are Y
%               test\_%  (empty)            ''

Database of interest is widget (not in the db table)

>From the same host the mysql server is on

mysql -u foo -h localhost --password=bar widget
ERROR 1045: Access denied for user: 'foo@localhost' (Using password:
YES)

>From any other host (with the mysql client)

I can connect

-pete

Pete Lancashire
Unix Systems Administration
Columbia Sportswear Co. Inc.
[EMAIL PROTECTED]
(503) 978-4713



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