I work on a Mac OSX 10.6.8, and I use Mysql Workbench to learn how to handle databases (I'm a beginner as far as databases go). Now, I have created a few users, and I'm trying to toy around with giving these users' rights, and let them interact with each other by granting and revoking each other various rights.
I have logged in via the root user and supposedly given all "toy users" their initial rights by using the necessary grant queries (verified via queries using "show grants"), but then I try to log in as the various users. Let's say two of these users are named "Sofia" and "Martin", and I want Sofia to give Martin the update- and insert-rights to a table "Book". Sofia was given the necessary privileges from my root-login unless I am mistaken, so I write (when logged in as Sofia)
grant update, insert on Book to Martin;
Error 1142: GRANT command denied to user ''@'localhost' for table 'book'
show grants for Sofia;
Error 1044: Access denied to user ''@'localhost' for database 'mysql'
grant update, insert on Book.* to `Martin`@`%`;
please click edit to see the back-ticks
See the MySQL manual page on