search

project-error / npwd

NPWD is a FiveM phone resource written entirely in TypeScript and React.
https://projecterror.dev
Other
338 stars 277 forks source link

Bug: Error executing (SHOW TABLES WHERE `Tables_in_s3801_r0p1x3l`LIKE ? ["users"]) with error message Access denied for user 'XXX'@'SERVER-IP' (using password: YES) #1009

Open necaz1337 opened 1 year ago

necaz1337 commented 1 year ago

Development Issue

Yes

Phone Version

latest

Issue Description

i censored the ip and user.

Issue Reproduction

starting script

Evidence

image

Certurix commented 1 year ago

I got the same issue today by installing NPWD.

mysql-async can connect to the database, so the script would be able to. But it is configured to a predefined IP, instead of the IP gave in mysql_connection_string in server.cfg.

necaz1337 commented 1 year ago

Solved. my password had special characters, now it works

jbdevic commented 11 months ago

Problem still exists. Many people have it.

Maxence1502 commented 11 months ago

I have the same error, without special characters it works but I'd like to be able to put some

coconutwatermelon commented 6 months ago

I also had this issue and can confirm it was related to special characters in password.