Cant connect to my local mysql server from c# console application

Asked Jan 15 '19 at 18:01

Active Jan 15 '19 at 18:10

Viewed 104 times

I am trying to connect to my local mysql server from my console, but whenever I try to open a connection it gives me a file not found exception. The connection string should be correct.

MySqlConnectionStringBuilder cstring = new MySqlConnectionStringBuilder();
cstring.UserID = "root";
cstring.Password = "MyPassword";
cstring.Database = "MyDatabase";
cstring.Server = "localhost";
cstring.Port = 3306;



MySqlConnection connect = new MySqlConnection(cstring.GetConnectionString(true));
connect.Open(); //Here I get a file not found exception

Exact error message: Could not load file or assembly 'System.Security.Permissions, Version=0.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51

EDIT: The server has .NET Connector installed

edited Jan 15 '19 at 18:10

asked Jan 15 '19 at 18:01

asd

1

Where is your connection string? cstring.ToString() is not a string it is a class object. – jdweng Jan 15 '19 at 18:06
Fixed it but it still doesn´t work – asd Jan 15 '19 at 18:11
[May be useful](https://stackoverflow.com/questions/44844798/could-not-load-file-or-assembly-system-valuetuple-version-0-0-0-0-or-one-of-i) – Jaskier Jan 15 '19 at 18:23
What does the connection string look like? You still are getting a bad connection string. – jdweng Jan 15 '19 at 18:27
"user id=root;password=MyPassword;database=MyDatabase;server=localhost;port=3306" – asd Jan 15 '19 at 18:40

Cant connect to my local mysql server from c# console application

0 Answers0