MySQL Connector/NET 6.7.7 has been released

2015-03-04 Thread karen langford
Dear MySQL users, MySQL Connector/NET 6.7.7, a new version of the all-managed .NET driver for MySQL has been released. This is the GA, is feature complete. It is recommended for production environments. It is appropriate for use with MySQL server versions 5.5-5.7. It is now available in source

MySQL Connector/NET 6.9.6 has been released

2015-03-04 Thread karen langford
Dear MySQL users, MySQL Connector/Net 6.9.6 is a maintenance release for the 6.9.x series of the .NET driver for MySQL. It can be used for production environments. It is appropriate for use with MySQL server versions 5.5-5.7. It is now available in source and binary form from http://dev.mysql.c

Re: Capturing milestone data in a table

2015-03-04 Thread Halász Sándor
2015/03/04 09:21 -0500, Phil One option would be to create a trigger for each milestone to generate the data instead. That could be a lot of triggers, not sure if it could be done in a single trigger, plus then I would have to maintain the trigger when adding new milestones. Less

RE: Users and Groups

2015-03-04 Thread Martin Gainty
> Date: Wed, 4 Mar 2015 14:04:55 +0100 > From: vegiv...@tuxera.be > To: lu...@lambrate.inaf.it > CC: mysql@lists.mysql.com > Subject: Re: Users and Groups > > > That reminds me, this may be of interest: > http://www.percona.com/blog/2015/03/02/emulating-roles-percona-pam-plugin-proxy-users/

Re: Capturing milestone data in a table

2015-03-04 Thread Johan De Meersman
- Original Message - > From: "Phil" > Subject: Capturing milestone data in a table > user_credits where metric1 > $mile and (metric1 - lastupdate) < $mile) That second where condition is bad. Rewrite it as metric1 < ($mile + lastupdate). Better yet, combine them into a between compariso

Capturing milestone data in a table

2015-03-04 Thread Phil
Hi mysql experts, I feel like I'm missing something. I'm trying to capture 'milestone' data when users pass certain metrics or scores. The score data is held on the user_credits table and changes daily. Currently just over 3M users on the table and their scores can range from 0 up to the 100's of

Re: Users and Groups

2015-03-04 Thread Johan De Meersman
That reminds me, this may be of interest: http://www.percona.com/blog/2015/03/02/emulating-roles-percona-pam-plugin-proxy-users/ - Original Message - > From: "Lucio Chiappetti" > To: "MySql" > Sent: Wednesday, 4 March, 2015 12:39:01 > Subject: Re: Users and Groups > When several years

Re: Users and Groups

2015-03-04 Thread Lucio Chiappetti
On Sun, 1 Mar 2015, Reindl Harald wrote: Am 01.03.2015 um 20:07 schrieb Steffan A. Cline: Has anyone seen a plugin for MySQL that will allow you to set up users and groups for access but it has all features for privileges like for tables, views and even colums, you can even restrict the acc

MySQL Utilities 1.6.1 Alpha has been released

2015-03-04 Thread Hery Ramilison
Dear MySQL users, This is the Alpha release for Utilities 1.6. MySQL Utilities version 1.6.1 is compatible with MySQL Server versions 5.5 and greater. Python v2.6 and v2.7 are supported. In addition to server utilities, MySQL Utilities also contains MySQL Fabric: a framework for managing a colle