RE: GRANT issues

2010-10-05 Thread LIU YAN
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 | +

Re: GRANT issues

2010-10-05 Thread Mike OK
Hi Steve Your statement will allow you to SELECT from any table in the pet_calendar database. You need to add INSERT, UPDATE, DELETE, CREATE etc to your GRANT statement. If you would like to have a super user, just GRANT ALL Mike - Original Message - From: "Steve Marquez" To: "