All geek questions in one place

Failed to connect to any of the specified MySQL nodes

I am working in C # through MySQL.Data.dll. Usually everything works fine, but sometimes the message "Unable to connect to any of the specified MySQL nodes" appears. What is this mistake and how to get rid of it?

+3
source share
3 answers

You can check if mysql server is working or not, and you can add mysql port number in the connection string, for example

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

Can you connect to MySql Host through MySql Workbench?

Using the same connection parameters in the application, do you get the same error?

Have you set up a user account, access, schema, and roles?

, , - 3306, , 'my.ini' .

0

MySQL HostGator 3306 . , web.config .

<system.web>
    <trust level="Full" />
</system.web>
0

Source: https://habr.com/ru/post/1784675/

More articles:


All Articles