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?