What is OxMySQL?
This guide will cover the basic installation for OxMySQL on a FiveM server. OxMySQL is an alternative to other database wrappers such as GhmattiMySQL or MySQL Async. Features include; improved performance and compatibility, resolves issues when using MySQL 8.0, returns callbacks immediately – removing up to 50ms overhead and more.
How to Install OxMySQL
- To start off with, you’ll want to head over to the OxMySQL GitHub page, and download the .ZIP file that’s shown in the image below. It’s often best to go with the most stable build shown, and not the most recent.
- You will now want to head over to your ‘/resources’ directory and then extract the contents of the .ZIP file you just downloaded to this folder. To upload resources, this can either be done via the Iceline Game Panel file manager or via an FTP application such as FileZilla or WinSCP.
- Once you’ve uploaded the .ZIP file to your resources directory, head back to the root directory (‘/container’) of your server, and open the ‘server.cfg’ file. As shown in the image below, make sure you add the line ‘start oxmysql’ to your server.cfg.
As well as adding the line to start the resource, you’ll also want to add your MySQL connection string which can be located within the ‘Databases’ tab of the Iceline Game Panel under the eye symbol. OxMySQL doesn’t allow the ‘=’ symbol in database passwords, so you may have to keep regenerating yours until you get one without.
To reset your database password, simply select your database password within the game panel and press the ‘Reset password’ button.
That pretty much covers the installation of OxMySQL to your FiveM server. If you’ve got a successful database connection in your console from OxMySQL you’ve correctly installed this resource. We hope you found this guide useful.
Facing any issues?
If you’re still unsure about the installation of OxMySQL, or are having issues with resetting your database password – don’t hesitate to reach out to our support team who are always more than happy to assist you with any queries/concerns you may have.
Haven’t got a FiveM™ server yet, or thinking about starting one? Here at Iceline Hosting, we offer premium hosting for great prices. If you’re unsure or need any help, contact a member of staff for sales assistance via support ticket or live chat.