Fixing MySQL privileges for upcoming elections



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


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]