Unanswered Question
Aug 15th, 2007
User Badges:

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Bart_ironport Thu, 08/16/2007 - 20:11
User Badges:

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 :)


This Discussion