Asterisk Mysql Application

I need some help in using the Mysql application from dialplan. While connecting the database when I use MYSQL(Connect connid dhhost dbuser dbpass dbname), I need to provide the port as well.

I have two mysql instances running, one on 3306 and the other on 3307. When I connect it always connects
to the standard port 3306. I need it to connect to the 3307 port. How can this be done :question:

I have successfully connected the ARA and CDRs to this DB by res_mysql.conf and cdr_mysql.conf. But still haven’t figured out how to connect it via dialplan. :cry:

Please HELP!!


Thanks for all your replies. :imp:
I was able to do it through ODBC.