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