I recently built a MMORPG and I have quickly hit GM's data management limits so I have started learning C++ for managing the data, but I need a easy to browse as well as easy to load and save to method of storing the data. My SQL came to mind as a database that would be kept server side and linked to the server to load and save information at intervals by the server.

I have downloaded and set up a My SQL database but I am unable to find anyway of accessing it via GML, GMSQL errors saying that it does not support the authentication method of the database (Which is passworded), So could someone please assist me in pointing me in the direction of a DLL that can connect to the most recent version of MySQL (5.1) or some other method that I could read and write to MySQL database

Unrelated: If you know how to write bytes to a buffer in C++ PLEASE PM me...

EDIT: Sorry about posting in the wrong forum, thank you ragarnak


SOLUTION
Johnjoe's solution of updating the libmysql.dll worked perfectly, I simply googled for a new version of the dll and the first link had a copy that connects to MySQL 5.1 so thank you very much.

GMSQL uses the library of MySQL... I doubt GMSQL would give such error. I've tried it myself, and was successful of doing so.

Download the usage example for GMSQL (I presume it is included with GMSQL), it uses queries as you would in MySQL Command Line cient.

Also, try replacing the libmysql library in GMSQL folder to a newer version.

In my opinion, the MySQL C library is easier to use then others. It isn't very hard and basic tutorials do exist. This page helped me get started.

First off, I do not recommend using GMSQL or any other dynamic link library to access your db directly, first off, it is longer, and second, more insecure.

I would recommend PHP to then retireve the values, and echo them back in the client.

GMSQL translates MySQL for GameMaker. I would not say that there is noticable difference between using MySQL directly and using MySQL with GMSQL (GmSql.dll, spicifically) because there is but slightly.

I can as assure you, using PHP's GET or POST is worse than using GMSQL/MySQL at server's side.