I am having trouble adding users that have remote access to my machine.
I use the wildcard method (user@"%") and have tried simply granting
SELECT or even with ALL but I cannot connect to the database via the
network. (MySQL 4.0.12 is the version).

[h000a9578d1ca:~] mike% /Library/MySQL/bin/mysql -h candiazoo.com -u
www -p
Enter password:
ERROR 1045: Access denied for user: 'www (AT) 24 (DOT) 62.214.12' (Using password:
YES)

The method I use (right out of the MySQL manual) creates a user entry
in the user table, and an entry in the dn table. The user entry has N
for all of the "yes/no" privilege fields while the db table has "Y" in
the appropriate slots.

I left the limit fields as "0" (unlimited) and did not fill in the SSL
field[s].

Any thoughts? I don't see what I am doing/have done wrong.

:/

Mike J.
candiazoo (AT) mac (DOT) com