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

You didn't post the command you used so I'll reply with what I would use to
set up that kind of access. btw, you'll want to be careful with access
from outside localhost and even more so when someone accesses from outside
your subnet. MySQL connections are *not* encrypted by default and
usernames/passwords are sent in plain text....

GRANT ALL on THEDBNAME.* TO www@"%" IDENTIFIED by "password";

Greg

Michael S. Jessop wrote:

Is anyone else having a problem with this on Mac OS X?? I am tempted
to export my data, delete mysql then reinstall... but I really really
really don't want to do that if there is some other solution?

Mike

In article <170720031947136471%candiazoo (AT) mac (DOT) com>, Michael S. Jessop
<candiazoo (AT) mac (DOT) com> wrote: