Solving Mysql Mono port issues

solving MySql problems when porting to Mono

Checklist items to tick when porting ASP.NET MySql projects from .NET on Windows to Mono.NET on Ubuntu linux:

Since Mysql is more case-sensitive on Linux, make sure that Database= names matches with actual database names in connection strings. Better, keep them in lowercase.
Make sure that MySql 5.6+ is installed since the default command sudo apt-get install mysql-server installs version 5.5
The version of MySql on Ubuntu Linux and Windows shall match
MySql v5.5 tables doesn’t support FULLTEXT indices and CURRENT_TIMESTAMP features, upgrade from it

Written on January 23, 2016