Re: MySQL Administrator problem

2007-01-20 Thread Daniel Culver
Actually on my Mac; 10.4.6 ppc the MySQL Administrator will only open to a connection through localhost. The localhost connection will accept any authorised user to connect, but, MySQL Administrator will only assume the privileges of the account I am working from (I have several). It has be

Re: MySQL Administrator problem

2007-01-20 Thread Kevin Spencer
On 1/19/07, Daniel Culver <[EMAIL PROTECTED]> wrote: Are you working on a Mac? If so, logging in as root is not good enough. You must have set up and log into the root user account of your Mac computer or server. The OP is talking about managing MySQL accounts with MySQL Administrator. MySQL A

Re: Table update

2007-01-20 Thread Jørn Dahl-Stamnes
On Saturday 20 January 2007 05:52, ViSolve DB Team wrote: > Hi > > Update will never support group by clause, only supports group functions; > Try as: > > Update teams t > inner join rider_team as rt on (rt.team_id=t.id) > inner join participants as p on (p.rider_id=rt.rider