List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:February 27 2013 5:55pm
Subject:Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
View as plain text  
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.2013 18:38, schrieb Prabhat Kumar:
> 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 <rp.neuli@stripped> wrote:
>> 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 create a table on
>> my own. what privileges I need to create and modify tables in this database?
>>
>> mysql  Ver 14.12 Distrib 5.0.27, for sun-solaris2.9 (sparc) using
>> EditLine wrapper
>>
>> mysql> show grants;
>>
>>
> +-------------------------------------------------------------------------------------------------------+
>> | Grants for myuserid@%
>> |
>>
>>
> +-------------------------------------------------------------------------------------------------------+
>> | GRANT USAGE ON *.* TO 'myuserid'@'%' IDENTIFIED BY PASSWORD
>> '*4EF5......6' |
>> | GRANT SELECT, INSERT, UPDATE, DELETE ON `mydb`.* TO 'myuserid'@'%'
>>
> +-------------------------------------------------------------------------------------------------------+
>> 2 rows in set (0.00 sec)
>>
>> at % means I can do the operations from other hosts too? using ssh


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
mysql Ver 14.12 Distrib 5.0.27 user privileges questionRajeev Prasad27 Feb
  • Re: mysql Ver 14.12 Distrib 5.0.27 user privileges questionPrabhat Kumar27 Feb
    • Re: mysql Ver 14.12 Distrib 5.0.27 user privileges questionReindl Harald27 Feb
      • RE: mysql Ver 14.12 Distrib 5.0.27 user privileges questionBenjamin Stillman27 Feb
        • Re: mysql Ver 14.12 Distrib 5.0.27 user privileges questionReindl Harald27 Feb