GRANT issues

--Apple-Mail-1-892893461
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=us-ascii

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,

--=20
Steve Marquez
Marquez Design
e-mail: smarquez@marquez-design.com
web: http://www.marquez-design.com
phone: 479-648-0325=20


--Apple-Mail-1-892893461--

Re: GRANT issues

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: "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 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@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=gcdmg-mysql-2@m.gmane.org

RE: GRANT issues

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@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: smarquez@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=gcdmg-mysql-2@m.gmane.org