I am attempting to set up permissions on DB with the following code from the terminal on
Mac OS 10.6
logged into mysql with a user that has access to the mysql database
GRANT SELECT ON pet_calendar.* TO username@'localhost' IDENTIFIED BY 'password';
I can get the user and password set up fine, but it does not grant any privileges. It is
probably an easy fix that I am just missing, but I would appreciate your help.