ASP.NET Core 3.1 Identity tables in MySQL
To have identity tables in MySQL install Pomelo package, set the connection string and DBContext in Startup.cs like this:
services.AddDbContext(options => options.UseMySql(Configuration.GetConnectionString("MySqlConnection"));
Open NuGet > Package Manager Console
Run: EntityFrameworkCore\Update-Database -Verbose
Run: update-database