Isnt it

GRANT ALL ON college.* TO someuser identified BY "somepassword";



-----Original Message-----
From: J [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 28 April 2002 2:22 AM
To: [EMAIL PROTECTED]
Subject: Problem with User Account - access denied


I created and user, like below, using mysql on my
Linux machine (Linux-Mandrake 8.1) to access a
database called college:

GRANT ALL ON college.* TO someuser BY "somepassword";

But I'm denied access even from localhost. I tried the
following too:

GRANT ALL ON college.* TO someuser@% BY
"somepassword";

But MySQL gives me an error message.

I need to be able to access the database, from
anywhere, including localhost.

Anyone can help me out? Thanks

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

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

Reply via email to