MySQL C# connection to localhost:'System.NullReferenceException'

Question

VS 2017 user here. I'm trying to connect a C# console app to MySQL 5.7. However there is no connection established. A suggeste solution is to look at undeclared objects, but I do not think that is the case here. Pls advise if it is.

MySqlConnection conn;
string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;

public Connection()
{
    conn = new MySqlConnection(connStr);
}

<connectionStrings>
<add name="myConnectionString"  
  connectionString="server=localhostdatabase=store;user=root;
  password=pass;port=3306" />
</connectionStrings>

If I run this in the debugger I get the follow information on conn:

IsPasswordExpired' threw an exception of type 'System.NullReferenceException'
ServerThread' threw an exception of type 'System.NullReferenceException'
ServerVersion' threw an exception of type 'System.NullReferenceException'

There is very little to be found on this, just that the password was set one year ago (I do not really believe that is causing this problem) and some guy that solved it by reinstalling MySQL server. I did that, to no avail.

From the command line everything is working fine.

Possible duplicate of What is a NullReferenceException, and how do I fix it? — Progman
– Progman, Commented Sep 28, 2017 at 21:42
thanks progman for the reference, but the cause stated there are generally objects not declared before used, I do not believe that is the case here. — ADBF
– ADBF, Commented Sep 28, 2017 at 21:48
It's possible the connection string is invalid. It appears to be missing a semi-colon between the server name and database connectionString="server=localhost;database=store;user=root; password=pass;port=3306" — JConstantine
– JConstantine, Commented Sep 28, 2017 at 21:52
The code is not following best practice anyway: the connection should be instantiated each time it is going to be used and then disposed of immediately afterwards. The using construct is useful for that. — Andrew Morton
– Andrew Morton, Commented Sep 28, 2017 at 21:56

Vijunav Vastivch · Accepted Answer · 2017-09-29 00:26:47Z

1

If you are confirmed that your password expires, you can try to create or alter:

CREATE USER 'jeffrey'@'localhost' PASSWORD EXPIRE NEVER;
ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE NEVER;

Your Guide is here.

answered Sep 29, 2017 at 0:26

Vijunav Vastivch

4,2111 gold badge18 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ADBF Over a year ago

thanks reds for taking the time to answer me. Pls see my comment above. Will crawl back under my stone now.

Collectives™ on Stack Overflow

MySQL C# connection to localhost:'System.NullReferenceException'

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related