How to increase the connection timeout for mysql connection from c# application?

Question

I want to increase the connection timeout for mysql connection and I can not modify the timeout settings from administrator panel of mysql server. I want to do it within c# application and I noticed that I can read the property ConnectionTimeout of MySqlConnection class. I would like to know that is there a way to increase the connection time before opening mysql connection.

Answer 1

you can change ConnectionString as below:

String connectionString = "Server=myserver; Port=3306; Database=databasename; Uid=userid; Pwd=password;Connection Timeout=30";

in the above Connection String you can specify the number of seconds as value for Connection Timeout

Answer 2

use "default command timeout" in your connection string, it works for me

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
default command timeout=20;

https://www.connectionstrings.com/mysql-connector-net-mysqlconnection/specifying-default-command-timeout/