What is the correct connection string to MariaDB which is on Synology?

Question

Hi all, I am trying to connect from my PC to MariaDB which is installed on Synology. Both device are connected to same WIFI. What I am doing wrong. Thanks. Till now I tried this:

using MySql; 
using MySql.Data.MySqlClient; 
string conString = "server=192.168.100.53:3307/run/mysqld;userid=root;password=password;database=test"; 
try 
{ 
	using (MySqlConnection con = new MySqlConnection(conString))
	{ 
		con.Open(); 
		Console.WriteLine("OK"); 
	} 
} 
catch(Exception ex) 
{ 
	Console.WriteLine("NOT OK : \n" + ex.Message); 
}

Answer 1

Hi,@Takeshi.Welcome to Microsoft Q&A.

Your connection string appears to have a couple of issues.

You could try the following string.

   string conString = "Server=192.168.100.53;Port=3307;Database=test;Uid=root;Pwd=password;";

//or

 string conString = "Server=192.168.100.53;Port=3307;Database=test;User ID=root;Password=password;";

Added Port=3307 to specify the port number. By default, MySQL/MariaDB uses port 3306, but if your MariaDB instance is configured to use port 3307, you need to specify it explicitly.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.