[Free] oxmysql - asynchronous MySQL wrapper

FiveM Releases
, , , ,
348

Looks like you need to put in a password in your server.cfg in the mysql line
set mysql_connection_string "mysql://user:password@localhost/your_database"

1 Like
349

I have this same issue, Just double checked that the string has correct details and its still not connecting

350

Did you start xampp

351

I just tried to log into phpMyAdmin, thats where zap has the database, and cant login? its saying “Access denied for user”

352

image
any1 know how to fix?

353

Hmm, I dont know Zap that much, but if it was in my setup, it would be xampp related, hope you´ll sort it out.

354

I Got it sorted. i opened ticket with zap they made a new database for me and moved the files over and that fixed it.

1 Like
355

i need help with oxmysql datebase

356

Please read the documentation. Its fairly clear on installation.

357

Unable to establish a connection to the database (ECONNREFUSED)!
Error -111: connect ECONNREFUSED 127.0.0.1:3306
See Common issues ¡ Issue #154 ¡ overextended/oxmysql ¡ GitHub for more information.
{
“connectTimeout”: 60000,
“trace”: false,
“supportBigNumbers”: true,
“jsonStrings”: true,
“user”: “root”,
“password”: “******”,
“host”: “localhost”,
“port”: “3306”,
“database”: “fivem”,
“namedPlaceholders”: false,
“flags”: [
“CONNECT_WITH_DB”
]
}

How do I fix this because it doesn’t show on how to do it in the documentation plus there is literally no videos whatsoever to help out on this.

358

Hi, does anyone know how to make a search query?
Column selection does, now search does not
I’m doing something like this:
But it’s not working

local result = MySQL.query.await("SELECT * FROM users WHERE ? LIKE ?", {type, "%"..text.."%"})
SELECT * FROM users WHERE ? LIKE ? ["lastname","%Justo%"]

Does anyone have a solution?