In this article I will explain with an example, how to resolve the following error: Keyword not supported. Parameter name: ABC while working with MySQL database.
 
 

Error

This error occurs due to the following reason in MySQL database.
1. Specified Initial Catalog without space i.e. InitialCatalog
MySQL Error: 'Keyword not supported. Parameter name: ABC' error in MySql Database
 
In the below connection string, the Initial Catalog is specified without space.
<connectionStrings>
    <add name="constr" connectionString="Data Source=123.12.0.1;port=3307;InitialCatalog=Northwind;User Id=root;password=pass@123" />
</connectionStrings>
 
 

Solution

Following is the solution for the above error.
1. Make sure that the Initial Catalog contains space between in the connection string as shown below.
<connectionStrings>
    <add name="constr" connectionString="Data Source=localhost;port=3306;Initial Catalog=Northwind;User Id=root;password=pass@123" />
</connectionStrings>