From: Michael Dykman Date: June 9 2010 1:22pm Subject: Re: How can I see the query from a remote session against my server List-Archive: http://lists.mysql.com/mysql/221856 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable You have 2 options here. The Mysql General Query Log http://dev.mysql.com/doc/refman/5.1/en/query-log.html Alternatively, if it's windows ( I ask because of the ODBC connector) and it's easier for you, I haven't done windows in awhile, but I suspect you might find what you want via that connector. I seem to recall that you can, via control panel, set debug options on the connector which will happily create enormous logs of every query passing through. best of luck. - md (side-note: I would not recommend hosting data services without a DBA to manage them) On Wed, Jun 9, 2010 at 6:48 AM, Bill Dossett wrote: > Hi, > > I'm a real newb at admining MySQL. =A0 =A0We have a customer that uses ou= r software that scripts queries and they are using a MySQL backend. > > They have sent us a test script and their database and I have setup a tes= t server, loaded the data setup an ODBC connection and this all works fine. > > The first job they sent us appears to be working fine, but the second one= throws an error saying the query is empty back at us. > > I am an IT manager and I don't know much about how our software scripting= system works or even if there is a debugger, so I was just trying to attac= k the problem from the server side to see if I could see the query at the s= erver... =A0 I thought profiling might help, but that only helps me with th= e session that I am connected to as far as I can see anyway, I'm not seeing= any of the queries that are being generated by the remote seesion through = the odbc connector... > > Is there some way the I can see the queries that are being run against th= is server from the remote session? =A0As this is a test system and it's doi= ng very little, I was hoping that if I could see the query I might get some= insight of what might be wrong in the script without having to learn how o= ur whole scripting software system works. > > I have done this with the MSSQL profiler in the past to locate slow queri= es in the past, so I assume it is possible and I just can't make the docume= nts on the MySQL profiler make sense to me. > > Thanks for any help anyone could provide on this as I've got people that = expect miracles in the next 5 minutes here! > > Bill > > --=20 - michael dykman - mdykman@stripped May the Source be with you.