Connection to asteriskcdrdb db from outside server

Does anybody know any way of connecting and retrieving information from asteriskcdrdb database from outside the trixbox server, other than using phpmyadmin interface to the mysql db?

I am not familiar with the way Trixbox is setup, but the connection to the mysql database boils down to basically three things.

  1. The database must be listening on an interface that can be accessed remotely (mysql setting)
  2. A database user must have rights to connect to the database from the remote host you desire (mysql setting)
  3. The iptables rules must allow the connection. (iptables setup)

Information on each piece can be found with the proper use of Google.

um can you be more specific? This research will take forever.