Failed to connect to MySQL-asterisk

Files need to check are:

/etc/asterisk/res_odbc.conf

/etc/odbcinst.ini

To resolve this , You have to check the correct configuration of above file.

For Example :

in —  /etc/odbcinst.ini

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1

or

[asterisk-connector]
Description           = MySQL connection to 'asterisk' database
Driver                = MySQL
Database              = asterisk
Server                = localhost
UserName              = asterisk
Password              = welcome
Port                  = 3306
Socket                = /var/lib/mysql/mysql.sock

And in  res_odbc.conf 

[asterisk]
enabled => yes
dsn => asterisk-connector
username => asterisk
password => welcome
pooling => no
limit => 1
pre-connect => yes

Posts to Review:

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib /mysql/mysql.sock’ (2) MYSQL Partitioning : What is and HOW To ? ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log Resolved : mysql replica : Relay log read failure: Could not parse relay log event entry.