RE: GRANT issues

2010-10-05 Thread LIU YAN
marq...@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

Re: GRANT issues

2010-10-05 Thread Mike OK
quot; To: "MySQL List" Sent: Tuesday, October 05, 2010 10:50 AM Subject: GRANT issues 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

GRANT issues

2010-10-05 Thread Steve Marquez
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 u