From: Scott Yamahata [mailto:[EMAIL PROTECTED]
> At the command prompt, I'm supposed to type:
>
> mysql -h host -u user -p
>
> Does that mean that I type, for example:
>
> mysql -h localhost -u admin -p
>
> with localhost=host and admin=user?
>
> When I'm asked for the password, I hit return and it lets me in.
>
> But if I try to create a database, by using:
>
> GRANT ALL ON store.* TO [EMAIL PROTECTED];
>
> I get an ERROR 1044: Access denied for user: '@localhost'
> to database
> 'store'
>
> Any help is appreciated.
Unless you've previously granted GRANT permissions to [EMAIL PROTECTED] (as the MySQL
root user), then this will, and should, fail.
In addition, though I'm not entirely certain, I think you need to delimit [EMAIL
PROTECTED] as two different strings -- GRANT ALL ON store.* TO 'admin'@'localhost'
If you need help giving GRANT permissions to [EMAIL PROTECTED], let us know or check
out:
http://www.mysql.com/doc/en/GRANT.html
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]