How to connect C# WPF app to remote SQL database?

Question

MySQL

I have a SQL database (created with phpmyadmin) on a remote server. You need to connect to it from C# WPF application to process the data. Tried connectionstring in app.config - error appears (Connection to server was successfully established, but then an error occurred during the pre-login confirmation process. (provider: TCP Provider, error: 0 - The remote host forcibly terminated the existing connection.))

Answer 1

It can be anything: timeout, rights, packet loss. If there is a necessary provider, then it is possible to connect directly to a remote database from VS and even the connection itself will form a string. Those. you can check the connection first.