Hi, Try this request:
grant all on db.bsd to shadowgrl@'%' identified by "testing123" with grant option; Regards, Sébastien > -----Message d'origine----- > De : Michael Sharp [mailto:[EMAIL PROTECTED]] > Envoyé : samedi 9 mars 2002 13:08 > À : [EMAIL PROTECTED] > Objet : 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