Connection string for MySQL in C#

Viewed 49

I'm trying to connect to MySQL, implementing a Web Application using C# and ASP.Net

Currently, I'm connecting to my DB in localhost using the default port 3306 I'm using the following connection string, this is for version 5.7.2.2

"server=localhost;user id=root;Pwd=Mypwd; persistsecurityinfo=True;database=cc;convert zero datetime=True"

Now, I want to use version 8.0.2.5 For this version, I use server 127.0.0.1 and port 3320

I tried changing the connection string to:

"server=127.0.01;user id=root;Pwd=Mypwd; persistsecurityinfo=True;database=cc;convert zero datetime=True"

And also:

"server=localhost;port:3320;user id=root;Pwd=Mypwd; persistsecurityinfo=True;database=cc;convert zero datetime=True"

But they didn't work, it's not connecting

I found this example on https://www.connectionstrings.com/mysql/:

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

But that doesn't work either.

Do you know another way, or what am I missing?

0 Answers
Related