hi Steve,
after you login with the new account , you can use the command
show grants;
to check which permission had been already granted to this account as below.
mysql> show grants;
+---------------------------------------------------------------------+
| Grants for root@localhost |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+
1 row in set (0.00 sec)
best regards
liuyann
> From: smarquez@stripped
> Subject: GRANT issues
> Date: Tue, 5 Oct 2010 09:50:54 -0500
> To: mysql@stripped
>
> Greetings,
>
> 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';
> FLUSH PRIVILEGES;
>
> 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.
>
> Thanks,
>
> --
> Steve Marquez
> Marquez Design
> e-mail: smarquez@stripped
> web: http://www.marquez-design.com
> phone: 479-648-0325
>
