I'm using MySQL 3.23 on FreeBSD 4.5-STABLE, and I am kinda new to MySQL.

I created the database " bsd " as root. I need a remote user, connecting
from any IP and logging in with " shadowgrl " and giving the password "
testing123 " to have full access to the bsd database only.

After making the bsd database, I did this:

grant all on db.bsd
to shadowgrl@
identified by "testing123"
with grant option;

I know the last option is dangerous, but I trust this user fully, and the
server is firewalled to only allow her network in.

However, when connecting remotely, shadowgrl is getting error: user has no
access to server

What am I overlooking?

Michael



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