[Solved] Connection string for MySQL in C#

by


The below connection string might be helpful for your problem.

"server=localhost:3320;uid=root;pwd=Mypwd;database=cc;persistsecurityinfo=true;convertzerodatetime=true"

Else remove persistsecurityinfo and convertzerodatetime then try.

"server=localhost:3320;uid=root;pwd=Mypwd;database=cc"

Refer this too in MySQL documentation.

// Sessions
MySQLX.GetSession($"mysqlx://user@host/schema")
MySQLX.GetSession($"mysqlx://user@host/schema?connection-attributes")
MySQLX.GetSession($"mysqlx://user@host/schema?connection-attributes=true")
MySQLX.GetSession($"mysqlx://user@host/schema?connection-attributes=false")
MySQLX.GetSession($"mysqlx://user@host/schema?connection-attributes=[attr1=val1,attr2,attr3=]")
MySQLX.GetSession($"mysqlx://user@host/schema?connection-attributes=[]")

// Pooling
MySQLX.GetClient($"mysqlx://user@host/schema")
MySQLX.GetClient($"mysqlx://user@host/schema?connection-attributes")
MySQLX.GetClient($"mysqlx://user@host/schema?connection-attributes=true")
MySQLX.GetClient($"mysqlx://user@host/schema?connection-attributes=false")
MySQLX.GetClient($"mysqlx://user@host/schema?connection-attributes=[attr1=val1,attr2,attr3=]")
MySQLX.GetClient($"mysqlx://user@host/schema?connection-attributes=[]")

Reference: https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html

solved Connection string for MySQL in C#