KeyNotFoundException SQL database in Unity.

Been a while since I asked here which I assume is a good sign haha. Now I want to start this off with I’m aware im out on deep end here and I am probably way in over my head but this is more of a learning thing for me than an actual project.
I am aware theres alternatives like mirror and such but again I’m half trying play around with more in depth things to learn a little.

Now I am making an online RPG (Won’t dare to call it mmo but ya know haha) for that I made a database and a server. I got pretty far. I have a login server which then sends you to the appropriate map server. The map servers are being ran in unity and thats where the errors comes up. The code is taken almost directly from the C# login server console app where its clearly working there but not in unity.

Database.cs

The first problem is I dont have to use the characterSet variable in my server it just works but it keeps giving me KeyNotFoundException if its not there. Ok that is solved then when a player join we of course register the player who logged in and we get another KeyNotFoundException when we try to call: MySqlDataReader reader = cmd.ExecuteReader();

Call order:
Player gets redirected and server gets a PlayerSyncRequest packet.
NetworkManager sees an incoming packet at line 89 and calls it onrecieve function:

PlayerSyncRequest Calls PlayManager.PlayConnect at line 26:

PlayerManager throws error at line 35:

Error:

If you have any question or i dont make sense or you got an answer dont hesistate ask for clearification! I do struggle at making myself clear for these more techinical conversations ^^"

Posting an answer to this myself. If anyone ever finds this through the angry googling like I have done. The things you want to check is if Unity and your database is using same characterset. You can change this in your connection string. Besides that, you may wanna check if your database and your MYSQL.DATA.DLL is running same version cause otherwise this error may also occur. In my case it was the latter. I needed to update my DDL