Connection string

You can find many ways to impliment your connection string from here. 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.

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 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 if you haven't already).

Example:

 protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
 {
  optionsBuilder.UseMySQL(DataBaseContexts.ConnectionStringMySQL);
 }