Install orchard CMS 1.9.2 using MySQL

Orchard CMS 1.9.2 is running well using database MS SQL Server and MySQL.  For Orchard CMS 1.9.2 when you install it using database MySQL, it will give you an error like this below

Data Source=localhost;Database=mydb;User Id=userid;Password=password

or

Data Source=localhost;Port=3306;Database=mydb;User Id=userid;Password=password

This error is due to some tables created in MySQL are empty, the sample data are not inserted properly in database MySQL.

If you really want to use database MySQL, I suggest you to install it first using database MS SQL Server and then copy data of each tables which is not inserted properly in MySQL during installation from database MS SQL Server and then paste it into database MySQL. After that, you can try to run your website and see the result.

Good luck