I'm trying to write a simple windows client to monitor my MySQL server. I'm
using ADO and I can connect to the server fine from a remote host and issue
queries using the ADO connection object like:
set rs = conn.execute ("show databases")
conn.execute("use " & strDBName )
set rs = conn.execute("show tables")
no problem. However I was surprised when this didn't work (that is, it
didn't return a recordset)
set rs = conn.execute("show processlist")
rs is empty, which is odd, because I thought I would at least see my own
process. So I thought at first it might be Process_priv in mysql.user, but
it is "Y" for this user and host. Oddly I can use the mysql GUI client
(windows) on the same remote client, logging in as the same user and execute
the statement "show processlist" and I get a recordset displayed.
Am I missing something in the documentation (which I have read!) that treats
the "show processlist" differently?
All I'm really interested in is logging connections. I was trying to avoid
starting mysqld with --log, because I'm not interested in logging the users
queries. Is there an easy way to just log connections?
Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
