469,331 Members | 1,769 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

Granted User Cannot Access Database (help please)

Hello all,

I'm relatively new to mysql and I'm having some trouble creating a user
that can access a database that I've created.

Here's what I've done:

1. As root, created a database called "tool_competence".
2. As root, created a couple of tables in the tool_competence db.
3. As root, created a user "called tool_comp_user" and flushed
privileges:

mysql> GRANT select, insert, update
-> ON tool_competence.employee_info
-> TO tool_comp_user@"%";

4. As root, checked grants using "show grants for tool_comp_user;" and
it reflects the granted privileges.
5. Logout of mysql and login as tool_comp_user: "mysql -u
tool_comp_user"
6. As tool_comp_user: "use tool_competence;" and I get the following
error:
ERROR 1044 (42000): Access denied for user ''@'[mydomain].com' to
database 'tool_competence'

Does anyone see anything wrong with this process or have any idea what
might be causing my problems?

Thanks in advance for any help,
Bart

Jul 23 '05 #1
1 1380
sp********@jam.rr.com wrote:
ERROR 1044 (42000): Access denied for user ''@'[mydomain].com' to
database 'tool_competence'


I realize now that in the above error message, user is ''. Why it did
not recognize the user when I logged in, I don't know. For some reason
it is now recognizing the user correctly and everything is working as I
would expect.

Very wierd because I was very careful about how I was logging in. And
haven't changed the way I was logging in since the problem was
occuring.

Although it appears not to be an issue now, I would gladly accept any
insights into what may have been going on if anyone out there has any
theories.

Thanks,
Bart

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by spambuster | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.