"MySQL Connector/C++ 8.0 is highly recommended for use with MySQL Server 8.0, 5.7, 5.6, and 5.5. Please upgrade to MySQL Connector/C++ 8.0" -- https://dev.mysql.com/downloads/connector/cpp/8.0.html Some of the queries are not working since MySQL-server upgrade to version 8.*.
The problem I was facing resulted purely from more strict policy of the new version of MySQL server, however it's very desirable to have appropriate version of the MySQL Connector/C++.