I'm sorry for such a simple question, but I've been trying for a week now to solve this and haven't been able to find a solution.

user: guestuser
database: db1
table: tb1

I've been trying to give guest user insert privileges to tb1 but not to the rest of the tables in db1. I've tried:

grant select on db1.tb1 to guestuser;

which works... until I reboot my machine. Then it says that user can't select db1. But if I give guestuser select privileges on db1 in the mysql database, then he has access to all tables in db1. Anyone has a solution? Thanks in advance.

::If you are trying to give INSERT privileges to a user you need to add INSERT to your GRANT.

try:
or:
The 'FLUSH PRIVILEGES' at the end will tell the server to reset the privileges table and update with the new information. That might be the problem with it not saving.

Also, make sure that the user account that your using ( if not the root account ) has the rights to do so.

sorry about that, I meant insert. My syntax is correct, the permissions at the mysql db shows it's correct. but...

But either way, the guestuser is able to select the table and insert into the table until I reboot the computer. After that, mysql gives me a "access denied to db1"

any other suggestions?

What version of MySQL Server are you running ?

and have you tried the FLUSH PRIVILEGES; after your
grant statement ?

version 4.1.1a

yes, flush privileges everytime I change permissions. Also, that doesn't matter since my problem happens when my *reboots* which means, the service was restarted.

Notice that there are two permissions required here:

• The right to use table tb1 in database db1.
• The right to have access to database db1 in the first place!

You have granted access to the table, but the user isn't getting that far. He doesn't have "the right to access the database in the first place."

Right, but if I give him access to the database;

grant select on db1.* to guestuser;

he will have access to "all" the tables in the database and any new tables I make in that database. I can't allow that. Is the only solution to give him access to the whole database then restrict access? That just doesn't make sense since mysql is suppose to be dealing with permission from the ground up basis (assume users with no permissions then start from there). Anyways, that's my frustration. Thanks for the try, sundailvcs. I appreciate it. If you have any more suggestions, please tell me.

phpMyAdmin and Webmin will both allow you to easily setup Table permissions for different users very quickly.

but both are gui which doesn't change the underlying problem, which is mysql itself.

BTW, I use phpmyadmin too, same problem.