Fixing MySQL privileges for upcoming elections

[Tobias Mueller <muelli cryptobitch de>]

Heya :)

I'm trying to generate election tokens right now but I am not allowed to:

[tobiasmue window elections]$ mysql foundation < 2012-create-election.sql
ERROR 1142 (42000) at line 2: INSERT command denied to user 'anonvoting'@'window-back' for table 'elections'
[tobiasmue window elections]$ 

mysql> SHOW GRANTS;
+---------------------------------------------------------------------------------------------------------------------+
| Grants for anonvoting window-back                                                                           
        |
+---------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'anonvoting'@'window-back' IDENTIFIED BY PASSWORD 'foo' |
| GRANT SELECT, SHOW VIEW ON `foundation`.* TO 'anonvoting'@'window-back'                                     
        |
| GRANT DELETE ON `foundation`.`election_tmp_tokens` TO 'anonvoting'@'window-back'                            
        |
+---------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)

mysql> 


I think the second line only gives me SELECT and SHOW VIEW, but not INSERT, UPDATE or DELETE.

Can anybody fix that? Preferably until tonight ;-)

Cheers,
  Tobi