Asp net core 6 with remote mariaDB database

Asked Jan 28 '22 at 00:24

Active Jan 28 '22 at 03:44

Viewed 1,837 times

I need to connect with a mariaDB database which is hosted online with entity framework core 6.

here my connection string:

  "ConnectionStrings": {
    "DBConnection": "Server=148.163.126.69;Port=3306;Database=dbname;Uid=db_admin;Pwd=pass;connect timeout=100;default command timeout=200;"
  },

first part of program.cs:

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

builder.Services.AddControllers();
// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();
builder.Services.AddDbContext<UsersContext>(options =>
{
    options.UseMySql(builder.Configuration.GetConnectionString("DBConnection"),
     ServerVersion.AutoDetect(builder.Configuration.GetConnectionString("DBConnection")),
    builder =>
    {
        builder.EnableRetryOnFailure(5, TimeSpan.FromSeconds(10), null);
    });
});

But I keep getting this error:

Unable to connect to any of the specified MySQL hosts.

I already tried to connect with a local SQLServer and it works fine.

edited Jan 28 '22 at 03:44

Gabriel Luci

38,328
4
55
84

asked Jan 28 '22 at 00:24

Mahdi Benaoun

what is the question? – Borka Jan 28 '22 at 00:35
@Borka forgot to add it, just edited the post. – Mahdi Benaoun Jan 28 '22 at 00:47
did you check if the server is accepting external connections? – Borka Jan 28 '22 at 00:48
I allowed all IPs to access the database via cpanel=>Remote Sql. I added '%' wildcard. – Mahdi Benaoun Jan 28 '22 at 00:50
can you try to connect with another program, like some db explorer, but installed on your machine – Borka Jan 28 '22 at 00:53
@Borka I tried to connect with HeidiSQL but with no success, error 10060. – Mahdi Benaoun Jan 28 '22 at 01:16
so basically the server refuses your connection. check if there's a firewall or something – Borka Jan 28 '22 at 02:10
@Borka I deactivated the firewall completely. I'm connecting to a shared server , I'm not sure if that would cause a problem. – Mahdi Benaoun Jan 28 '22 at 23:45

Asp net core 6 with remote mariaDB database

0 Answers0