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.
If I think try to connect to the server through the
mysql client like this:
mysql -u myuser -pfoobar my_db
I get access denied...
So then if I do this:
grant all privileges on *.* to
'myuser'@'%.mydomain.com'
identified by 'foobar';
I can connect no problem. What am I doing wrong? I
definitely don't want this user to have privileges on
other databases but I also want the user to be
functional.
Thanks,
Tripp
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
