List:General Discussion« Previous MessageNext Message »
From:LIU YAN Date:October 5 2010 4:29pm
Subject:RE: GRANT issues
View as plain text  
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 
>  		 	   		  
Thread
GRANT issuesSteve Marquez5 Oct
  • Re: GRANT issuesMike OK5 Oct
  • RE: GRANT issuesLIU YAN5 Oct