Re: grant question

At 11:19 -0500 4/22/05, Scott Purcell wrote: I am here in the docs. GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... ON {tbl_name | * | *.* | db_name.*} TO user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']] ... [REQUIRE

grant question

I am here in the docs. GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... ON {tbl_name | * | *.* | db_name.*} TO user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']] ... [REQUIRE NONE | [{SSL| X509}]

Grant question

Hi list, I have many databases on my MySQL server such as: dbexample dbexample_clients_abc dbexample_clients_def dbexample_clients_ghi dbexample_local_abc dbexample_local_def dbexample_local_ghi Is it possible to grant all these databases in just one GRANT instruction such as: GRANT

RE: Grant question

Specialist Pottawattamie County, Iowa -Original Message- From: Andre Matos [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 04, 2005 4:26 PM To: mysql@lists.mysql.com Subject: Grant question Hi list, I have many databases on my MySQL server such as: dbexample dbexample_clients_abc

Re: GRANT question

Rhino [EMAIL PROTECTED] wrote on 21/02/2004 16:59:27: I am new to most aspects of MySQL administration so I was wondering if someone can help me figure out what GRANTs I need for a particular situation. I have a user who needs to be able to run some MySQL scripts that create and load

Re: GRANT question

At 9:31 + 2/23/04, [EMAIL PROTECTED] wrote: Rhino [EMAIL PROTECTED] wrote on 21/02/2004 16:59:27: I am new to most aspects of MySQL administration so I was wondering if someone can help me figure out what GRANTs I need for a particular situation. I have a user who needs to be able to run

GRANT question

I am new to most aspects of MySQL administration so I was wondering if someone can help me figure out what GRANTs I need fora particularsituation. I have a userwho needs to be able to run some MySQL scripts that create and load tables in a database named NFL. He is accessing MySQL remotely

Re: GRANT question

Rhino [EMAIL PROTECTED] wrote: I am new to most aspects of MySQL administration so I was wondering if someone can help me figure out what GRANTs I need for a particular situation. I have a user who needs to be able to run some MySQL scripts that create and load tables in a database named

Re: GRANT question

Followup questions interspersed below - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 21, 2004 12:29 PM Subject: Re: GRANT question Rhino [EMAIL PROTECTED] wrote: I am new to most aspects of MySQL administration so I

Re: GRANT question

At 13:09 -0500 2/21/04, Rhino wrote: Followup questions interspersed below - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 21, 2004 12:29 PM Subject: Re: GRANT question Rhino [EMAIL PROTECTED] wrote: I am new to most aspects

Re: GRANT question

More followups below - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, February 21, 2004 1:25 PM Subject: Re: GRANT question At 13:09 -0500 2/21/04, Rhino wrote: Followup questions interspersed below

Re: GRANT question

At 14:30 -0500 2/21/04, Rhino wrote: More followups below 1. Why is this happening? The Load Data article says he needs the File privilege and I've given it to him. He also has all privileges on the NFL database. What more do I need to do for him? FILE is a global level

Re: GRANT question

Thanks, that clears things up pretty well. By the way, since you're on the documentation team, can you tell me what the official channels are for making suggestions about the documentation. I have some ideas about how to make it better Rhino -- MySQL General Mailing List For list

Re: GRANT question

At 14:56 -0500 2/21/04, Rhino wrote: Thanks, that clears things up pretty well. By the way, since you're on the documentation team, can you tell me what the official channels are for making suggestions about the documentation. I have some ideas about how to make it better Mail to [EMAIL

GRANT question

If i use GRANT and REVOKE to change user privileges, it is my understanding that i don't have to issue a FLUSH PRIVILEGES statement. Is this correct? Our sysadmin rebooted the MySQL server this morning, and there were some privilege problems afterward. I had to reset the privileges for some

Re: GRANT question

Hi, Yes, you're right. GRANT and REVOKE do not need FLUSH PRIVILEGES afterwards. Flushing is only needed when manually updating the grant tables via normal INSERT/UPDATE/DELETE commands. Regards, Iikka On Wed, 2 Oct 2002 [EMAIL PROTECTED] wrote: If i use GRANT and REVOKE to change user

MySQL Grant Question

I have an existing mysql user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? Thank You - Before posting,

RE: Grant question

: Wednesday, July 24, 2002 6:27 PM To: Paul Maine Subject: Re: Grant question Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply

Re: MySQL Grant Question

Pada Wed, 24 Jul 2002 18:52:44 -0500 Paul Maine [EMAIL PROTECTED] menulis : I have an existing mysql user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? you can run :

Re: Grant question

Another grant command for the existing privileges + index privs. should work Bhavin. - Original Message - From: Paul Maine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 5:33 PM Subject: RE: Grant question I have an existing mysql user that I wish to add