How to encrypt Stringconnection to a Mysql remote database in C#

Question

I am developing an application that I intend to sell, and so I created a serial verification system, which checks if that activation code is already associated with the PC MAC. I do this by connecting to a remote database. If anyone has a better and easier idea of how to create this type of serial activation, I am accepting hehehe suggestions

My question is, how do I protect the login information provided by the Connection String.

I have there

connString "SERVER=xxx;PORT=3306;DATABASE=xxx;UID=xxx;PASSWORD=**xxx**;";

I believe that leaves it willing in the code allow you to steal the access data to my database. Is there any way to encrypt this? Or you’d have to do it right on the bank server.

Answer 1

If the ConnectionString is stored in app.config can always follow this very detailed tutorial on Codeproject: https://www.codeproject.com/Articles/15392/Implementing-Protected-Configuration-With-Windows

If you only want to encrypt/decrypt a string, the same way it would with a password, there is the possibility to use an AES encryption: https://msdn.microsoft.com/en-us/library/system.security.cryptography.aes(v=vs.110). aspx