# Connect to MySql in C# and Entity Framework - Connecting **Article Created: 21 May 2020** || **Last Edited: 21 July 2020** [\<\<](./introduction.html) || [\< Preparations](./preparation.html) --- ## Connection string You can find many ways to impliment your connection string from [here](https://www.connectionstrings.com/mysql/). From experience, 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 don't know your port or user id, just look at the connection you use to connect to the database. ![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 If you are making an ASP.NET application, you will need to alter your Startup.cs file. Your ConfigureServices method should currenly 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.UseSQL(CONNECTION_STRING); }); } ``` You need to change `.UseSQL` to `.UseMySQL` (refer to [preparations](./preparation.html) if you haven't already). ## DBContext child class If you want to connect a DBContext child class to a MySQL databse, the best way is to override the `OnConfiguring` method. In the override, in `optionsBuilder`, call the `.UseMySQL` method (refer to [preparations](./preparation.html) if you haven't already). Example: ``` protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseMySQL(DataBaseContexts.ConnectionStringMySQL); } ``` Now you should be connected to your database.