View Single Post
  #4   (View Single Post)  
Old 13th December 2008
Mantazz Mantazz is offline
Shell Scout
 
Join Date: Oct 2008
Posts: 90
Default Found it...

Looks like the problem was that it was permissions for tables, not databases. In this case, the database was called "hackers" and the table was called "attempts".
AFAIK, there may be no mechanism to grant permissions for entire databases, only for tables within. So then I did
Code:
mysql> grant all on Attempts to syslog@localhost identified by 'varlog';
Query OK, 0 rows affected (0.00 sec)
Followed by
Code:
mysql> show grants for 'syslog'@'localhost';
+---------------------------------------------------------------------------------------------------------------+
| Grants for syslog@localhost                                                                                   |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'syslog'@'localhost' IDENTIFIED BY PASSWORD '' |
| GRANT ALL PRIVILEGES ON `hackers`.`Attempts` TO 'syslog'@'localhost'
And now the user 'syslog' can see the Attempts table. The columns within show up as well, so it looks like I can proceed.

thanks!
Reply With Quote