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.ne...@yahoo.com> 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
signature.asc
Description: OpenPGP digital signature