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.ne...@yahoo.com> 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