[Solved] ALL PRIVILEGES except one table in MySQL [duplicate]

by


or is there another way to grant ALL PRIVILEGES and REVOKE the special
one?

NO, there is not any shortcut to do this. You will have to revoke ALL PRIVILEGE from user and then GRANT for each table separately.

REVOKE ALL PRIVILEGES ON db.* FROM 'carl'@'%';

Though there is option for automating this task of GRANTING all tables separately using scripting like:

Pseudo code

1. You can list out all tables using `SHOW TABLES;`

2. for each item is on table list

3. if(item != "specific table name") then
   GRANT table privilege to user

See this similar post MySQL grant all privileges to database except one table

solved ALL PRIVILEGES except one table in MySQL [duplicate]