RE: mysql Ver 14.12 Distrib 5.0.27 user privileges question

2013-02-27 Thread Stillman, Benjamin
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.rei

Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question

2013-02-27 Thread Reindl Harald
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.

Re: Mysql Monitoring with Graphite

2013-02-27 Thread Mike Franon
I am using graphite, but what exactly do you want to graph? For mysql graphing I actually use nagios plugin called check_mysql_health along with check_mk/pnp4nagios That works really well. On Fri, Feb 22, 2013 at 2:24 AM, Johan De Meersman wrote: > - Original Message - >> From: "Adars

Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question

2013-02-27 Thread Reindl Harald
oh, osrry i was focused on the " at % means I can do the operations from other hosts too?" Am 27.02.2013 19:00, schrieb Stillman: > 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 que

Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question

2013-02-27 Thread 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 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 c