c# - Unable to connect to any of the specified MySQL hosts

Question

I work in C # through MySQL.Data.dll. Normally, all works fine, but sometimes it pops up an error "Unable to connect to any of the specified MySQL hosts". What is this error and how to get rid of it?

Answer 1

You may check mysql server is working or not and you can add port number of mysql in connection string like this

    "Server = myServerAddress;
       Port = 1234;
   Database = myDataBase;
        Uid = myUsername;
        Pwd = myPassword;"