Report Viewer - app.config unknowingly

Question

I am unable to make a Report Viewer connection with Mysql, it does not appear in the "Choose Data Source" list. I believe that the problem is in the "app.config" that is disfigured someone could pass me the entire code of the "app.config" for Mysql Connector/NET 6.9.12 Visual Studio Community 2017

The code of my entire app.config is:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="Gold_Business.Properties.Settings.bgmysqlConnectionString"
            connectionString="server=localhost;user id=root;database=bgmysql"
            providerName="MySql.Data.MySqlClient" />
    </connectionStrings>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
    </startup>
</configuration>

When replacing the code below in the code above the problem persists because the other parts of the code are not correct presenting the error below the code. What the entire "app.config" should look like for Mysql Connector/NET 6.9.12?

<connectionStrings>  
    <add name="myDatabaseConnection" connectionString="server=localhost;user=root;database=mydatabase;port=3306;password=mypassword;" /> 
</connectionStrings>  

Answer 1

Hello, follow example of connectionString by app.config for Mysql.

<connectionStrings>  
    <add name="myDatabaseConnection" connectionString="server=localhost;user=root;database=mydatabase;port=3306;password=mypassword;" /> 
</connectionStrings>  

I hope it helps.