2
votes
2answers
685 views

How can I change my mysql user that has all privileges on a database to only have select privileges on one specific table?

I gave my mysql user the "GRANT ALL PRIVILEGES ON database_name.* to my_user@localhost" treatment. Now I would like to be more granular, starting with lowering privileges on a specific table. I am ...