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 r...@localhost | +---------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION | +---------------------------------------------------------------------+ 1 row in set (0.00 sec) best regards liuyann > From: smarq...@marquez-design.com > Subject: GRANT issues > Date: Tue, 5 Oct 2010 09:50:54 -0500 > To: mysql@lists.mysql.com > > 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: smarq...@marquez-design.com > web: http://www.marquez-design.com > phone: 479-648-0325 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
