List:General Discussion« Previous MessageNext Message »
From:Benjamin Stillman Date:February 27 2013 6:00pm
Subject:RE: mysql Ver 14.12 Distrib 5.0.27 user privileges question
View as plain text  
OP's first question: " I am not able to create a table on my own. what privileges I need
to create and modify tables in this database?"

The answer to that question is that he/she needs CREATE to create tables and ALTER to
alter them.


-----Original Message-----
From: Reindl Harald [mailto:h.reindl@stripped]
Sent: Wednesday, February 27, 2013 12:55 PM
To: mysql@stripped
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

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


________________________________

Notice: This communication may contain privileged and/or confidential information. If you
are not the intended recipient, please notify the sender by email, and immediately delete
the message and any attachments without copying or disclosing them. LBI may, for any
reason, intercept, access, use, and disclose any information that is communicated by or
through, or which is stored on, its networks, applications, services, and devices.
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