Mysql on docker compose is 5.5 EOL

[anantshri]

docker-compose on dev environment is using 5.5 mysql need to upgrade to higher version as even 5.6 is now EOL
https://www.mysql.com/support/eol-notice.html

[sunilkr]

All tests ran fine MYSQL:5 (5.7) docker image. Although MSQL threw some (non-breaking) errors and warning related to internal tables for persistent stats.

https://stackoverflow.com/questions/15767652/mysql-error-table-mysql-innodb-table-stats-not-found

[sunilkr]

It seems to take some cached data from previous version of MYSQL, I am not able to figure out where that is on my system.

volumes:
      - swachalit-mysql:/var/lib/mysql

[sunilkr]

running mysql_upgrade fixed the errors thrown by DB.