Asterisk (version 11 & 13) Realtime was working fine with MySQL version 5.5 but when I upgraded MySQL 5.7. It stops working and following errors appeared:
ERROR res_config_mysql.c: MySQL RealTime: Failed to connect database server <database-name> on localhost (err 2003). Check debug for more info. WARNING res_config_mysql.c: Table <table-name> not found in database. This table should exist if you're using realtime.
There was no issue in config files, database and table but it happens after MySQL upgraded from 5.5 to 5.7 version.
Can anyone help me to fix this issue or I should downgrade MySQL to previous version?