# Connect to MySql in C# and Entity Framework - Connecting [![🔗](/img/link-tabler.svg)](#Connect%20to%20MySql%20in%20C#%20and%20Entity%20Framework%20-%20Connecting) **Article Created: 21 May 2020** || **Last Edited: 25 November 2020** [`<<`](./introduction.html) || [`< Preparations`](./preparation.html) --- ## Connection string [![🔗](/img/link-tabler.svg)](#Connection%20string) You can find a truckload of ways to make your connection string from places like [this](https://www.connectionstrings.com/mysql/) but in this case, I've found out that most don't work. After a lot of trial and error, I've found that this one works the best: ``` "server=localhost; port=YOUR-PORT; user id=YOUR-USER-ID; password=YOUR-PASSWORD; database=NAME-OF-DATABASE; SslMode=none" ``` If you are using `MySQL Workbench` and you don't know your port and id, you can look at the server information from the `MySQL Connections` page. ![MyServer root 127.0.0.1:3306](./img/connections.png) In this example, the user id is _root_ and the port is _3306_. ## ASP.NET Startup [![🔗](/img/link-tabler.svg)](#ASP.NET%20Startup) If you are making an `ASP.NET` application, you'll need to put the connection string in the `ConfigureServices` method of the `Startup.cs` file. You'll also need to modify your `ConfigureServices` method, by replacing `.UseSQL` with `.UseMySQL`. The result should look something like this: ``` // This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddControllersWithViews(); services.AddTransient(); services.AddDbContext(opt => { opt.UseMySQL(CONNECTION_STRING); }); } ``` ## DBContext child class [![🔗](/img/link-tabler.svg)](#DBContext%20child%20class) If you want to connect a `DBContext` child class to a `MySQL` database, one of the easiest ways to do it, is to override the `OnConfiguring` method. In the override, you'll need to call the `optionsBuilder.UseMySQL` method (`optionsBuilder` is a parameter of the method) with the connection string. ``` protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseMySQL(CONNECTION_STRING); } ``` Et voilà! You should now be connected.