You should specify the machine address after @ something like 'localhost' or specify particular IP / name. I might do this.
grant all on db.bsd to shadowgrl@localhost identified by "testing123" with grant option; When you connect remotely, you need to specify host name. NOBBY ----- Original Message ----- From: Michael Sharp <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 09, 2002 6:07 PM Subject: adding a user to a database > 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 --------------------------------------------------------------------- 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
