MFC ODBC

santas-littlehelper_ironport · ‎08-15-2007

Hi all,

I want to access the MFC MySQL DB via ODBC to make some reports.
I already got username/pw.
The problem is that I can only access message_tracker db from the server wherer MFC is installed. When I access from a different server I can only access the information_scheme.
Any hints what I can do?

Thanks in advance.

Bart_ironport · ‎08-16-2007

It's just mysql so you can start it with --skip-grant-tables, log in as root and update the users table so that remote logins are allowed.

I did this to generate some custom reports as well. It's a bit overkill in my case, but its easier than writing your own log parser. It would be nice to have a parsing library that everyone could reuse for their scripts :)

santas-littlehelper_ironport · ‎08-17-2007

Can you give me a hint where I can find the root password??