How can I connect to an asterisk via odbc to a third-party mysql?

Question

MySQL

How can I connect to an asterisk via odbc to a third-party mysql? If the local mysql connection works, but the external one does not. Thanks
Connecting /etc/odbc.ini

[asterisk]
Driver=MySQL
Description=Connector/ODBC 3.51 Driver DSN
Server=localhost
User=asterisk
Password=asterisk
Database=asterisk
Port=3306
Socket=/var/lib/mysql/mysql.sock

Not connected - /etc/odbc.ini

[secondcon]
Driver = MySQL
Description = Connector/ODBC 3.51 Driver DSN
Server = XX.XXX.XX.XX
User = ******
Password = ******
Database = mydatabase
Port = 3306
Socket = /var/ lib/mysql/mysql.sock

through odbc show shows

Name: asterisk
DSN: asterisk
Number of active connections: 1 (out of 1)

Name: secondcon
DSN: secondcon
Last fail connection attempt: 2020-04-25 15:30:27
Number of active connections: 0 (out of 1)

Answer 1

Asterisk makes no difference. But MySQL may simply not be configured to accept connections from external addresses.