Cannot connect to the mysql database from ASP.NET project

MySQL
#1

Hello,
I’ve made a mySQL database but whenever I try to connect it times out “server not found”. The weird part is that I can connect to the database by using the mysql workbench (using the same server/creditentials). The connectionstring I use is the following:

Thanks for your help!

#2

I think, you should check your connection string in web.config file, that you’re trying to deploy.

#3

Hello @alex187,

We provide some connection strings as an example here hopefully it helps!

1 Like
#4

Helloo @Monroy.
I have trouble too, connecting to mysql database. I used the connection string in your provided link, but it’s still not working. I also can connect to MySQL Workbench without a problem.

#5

Hello,

Has anyone figured that out yet? I still have the same problem.

Thanks,

Sergio Nunes

#6

I’m using it in this way

<add name="yourname" providerName="MySql.Data.MySqlClient" connectionString="server=mysql#.gear.host;uid=youruser;password=yourpassword;database=yourdb;persistsecurityinfo=True" />

#7

missing port number?

#8

It should work just like that. If required, the MySQL port number is 3306 while MSSQL is 1433.