: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Wednesday, February 27, 2013 12:55 PM
To: mysql@lists.mysql.com
Subject: Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
says who?
you MAY need CREATE privileges
but it not uncommon have a defined scheme and not allow the user to create or
d
says who?
you MAY need CREATE privileges
but it not uncommon have a defined scheme and not allow
the user to create or drop tables, the user below is
able to do anything for a common web-app
to anser the OP's question
% in mysql is the same as * for the bash
so yes, % means "any host"
Am 27.02.
.com
> Subject: Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
>
> says who?
>
> you MAY need CREATE privileges
> but it not uncommon have a defined scheme and not allow the user to create or
> drop tables, the user below is able to do anything for a common web-app
>
you need CREATE Privileges.
http://dev.mysql.com/doc/refman/5.0/en/grant.html#grant-privileges
On Wed, Feb 27, 2013 at 10:42 PM, Rajeev Prasad wrote:
> Hello,
>
> currently on this version of MySQL a database has been built for me to
> use. and following privileges are given: I am not able to c
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 26, 2003 1:26 AM
> To: michael young; [EMAIL PROTECTED]
> Subject: Re: user privileges question
>
>
> At 18:02 -0400 6/25/03, michael young wrote:
> >Hi,
> >
Hi Paul,
2003年 6月 26日 木曜日 09:55、Paul DuBois さんは書きました:
> At 9:19 +0900 6/26/03, Nils Valentin wrote:
> >Hi Michael,
> >
> >you raised an interesting question.
> >
> >I created a new account (testroot) I gave him all privileges - except the
> >GRANT privilege.
> >
> >GRANT ALL ON *.* TO 'testroot'@'
At 9:19 +0900 6/26/03, Nils Valentin wrote:
Hi Michael,
you raised an interesting question.
I created a new account (testroot) I gave him all privileges - except the
GRANT privilege.
GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx';
mysql> show grants for testroot;
+---
Hi Michael,
you raised an interesting question.
I created a new account (testroot) I gave him all privileges - except the
GRANT privilege.
GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx';
mysql> show grants for testroot;
+-
At 18:02 -0400 6/25/03, michael young wrote:
Hi,
I am creating a small web based program for users to access
the data in the datbases. New databases will be added in later. I
want to create a user to access these databases with certain rights,
not all rights. Will I have to grant this user
Hi,
I am creating a small web based program for users to access the
data in the datbases. New databases will be added in later. I want to
create a user to access these databases with certain rights, not all
rights. Will I have to grant this user right to each database as I add
them in or
10 matches
Mail list logo
