C# mysql Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

add default command timeout=0 as below

string connStr = "Server=localhost;database=mydb;username=root;pwd=root;default command timeout=0";