How to get MySql DB connection information from MySql workbench?

c# asp.net mysql sql workbench
recneps picture recneps · Feb 4, 2013 · Viewed 13.5k times · Source

I am trying to connect to a database using ASP.net and C#. I went through the MySql workbench tutorial and created a database, eer model, and table.

What I need now is the database connection information, specifically the connection string. How do I find what information needs to go in the connection string? What all needs to be in my connection string?

Answer

Daniel Kelley picture Daniel Kelley · Feb 4, 2013

ConnectionStrings.com is an excellent resource for details on connection strings and how they can be constructed.

Related questions

Index (zero based) must be greater than or equal to zero

Hey I keep getting an error: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. My code: OdbcCommand cmd = new OdbcCommand("SELECT FirstName, SecondName, Aboutme FROM User WHERE UserID=1", …

Read More
'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed

I deployed my ASP.NET project on host but take this fail. I am trying to solve this issue for hours but could not. On my first page users enter email and password after click login button they navigate menu. …

Read More
Dynamic MySQL database connection for Entity Framework 6

I wish to pass a dynamic connection string to the entity framework context. I have over 150 schemas which are identical (one per account) and I would like to select the connection as such: ApplicationDbContext db = new ApplicationDbContext("dbName"); In theory …

Read More