List:General Discussion« Previous MessageNext Message »
From:Prabhat Kumar Date:February 27 2013 5:38pm
Subject:Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
View as plain text  
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:

> 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 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)
>
> mysql>
>
> at % means I can do the operations from other hosts too? using ssh.
>
> thank you.
>



-- 
Best Regards,

Prabhat Kumar
MySQL DBA

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

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