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

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