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 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

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 question

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 vegiv...@tuxera.be wrote: - Original Message

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

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