Michael,
Thanks for the detailed response.
First off, it's a network connection, but I forgot to
show the -h in my example. Sorry for the lack of
clarity there.
The error message that I'm getting is:
ERROR 1045: Access denied for user
'myuser'@'host.mydomain.com' (using password: YES)
So then,
Tripp Bishop wrote:
Simple question:
I'd like to create a user that has all privileges for
just one database on the server.
When I try the following:
grant all privileges on my_db.* to
'myuser'@'%.mydomain.com'
identified by 'foobar';
the statement runs fine.
You can verify it worked with
