How to generate the right connection string for MySql

Question

I have ASP.Net MVC site & using EF Code First

As Database, I am using MySql. But not getting the right connection string. If it was MSSQL I could have easily generate using Visual Studio itself.

Is there a quick way to auto generate the right connection string when using MySql.

Thanks.

ScaisEdge · Accepted Answer · 2016-11-13 09:27:30Z

4

This could be useful

<connectionStrings>
   <add name="MyContext" providerName="MySql.Data.MySqlClient"
    connectionString="server=localhost;port=3306;database=mydbname;uid=my_user_id;password=my_password"/>
</connectionStrings>

tipically the my_user_id = root

https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html

answered Nov 13, 2016 at 9:27

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kgn-web Over a year ago

Can you please look into this related question. stackoverflow.com/questions/40572912/…

jafarbtech · Accepted Answer · 2016-11-13 09:35:35Z

0

While adding the edmx file (under data tab) you have select generate from existing db. And select mysql db for more details follow the complete guide here

answered Nov 13, 2016 at 9:35

jafarbtech

7,0551 gold badge41 silver badges60 bronze badges

Collectives™ on Stack Overflow

How to generate the right connection string for MySql

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related