[ script:mysql-async] [MySQL] [ERROR] [esx_vehicleshop] An error happens for query "SELECT * FROM vehicles : []": ER_BAD_DB_ERROR: Unknown database 'fivem'

[josevloxx1]

If anyone got this problem fix Reply back please!.

[Nophobia09]

What does the connection string look like in your server.cfg? This looks like its pulling the default login which is
host: '127.0.0.1',
user: 'root',
password: '',
database: 'fivem'.

If this is the issue then to correct it, fix the connection string to this format
set mysql_connection_string "server=YOURDBSERVER;database=YOURDATABASENAME;userid=USERNAME;password=PASSWORD"
Replace the all caps with your information. Hope this helps.

[josevloxx1]

What does the connection string look like in your server.cfg? This looks like its pulling the default login which is
host: '127.0.0.1',
user: 'root',
password: '',
database: 'fivem'.

If this is the issue then to correct it, fix the connection string to this format
set mysql_connection_string "server=YOURDBSERVER;database=YOURDATABASENAME;userid=USERNAME;password=PASSWORD"
Replace the all caps with your information. Hope this helps.

mines's is a local host and how can i create a date base with es_extended it only show me this

[Nophobia09]

Looks like you have created a database named essentialmode with tables addon_account, addon_account_data, addon_inventory, addon_inventory_items, billing, and users. You need to setup your connection to this database, even if it's local host. @josevloxx1

[josevloxx1]

Looks like you have created a database named essentialmode with tables addon_account, addon_account_data, addon_inventory, addon_inventory_items, billing, and users. You need to setup your connection to this database, even if it's local host. @josevloxx1

the one you told me to put on server.cfg can you make it local host please to i can put it because local host i don't have password sorry im new too all this i'm learning

[josevloxx1]

Looks like you have created a database named essentialmode with tables addon_account, addon_account_data, addon_inventory, addon_inventory_items, billing, and users. You need to setup your connection to this database, even if it's local host. @josevloxx1

does this have to be all caps where it say yourname

set mysql_connection_string "server=YOURDBSERVER;database=YOURDATABASENAME;userid=USERNAME;password=PASSWORD"

[josevloxx1]

Looks like you have created a database named essentialmode with tables addon_account, addon_account_data, addon_inventory, addon_inventory_items, billing, and users. You need to setup your connection to this database, even if it's local host. @josevloxx1

[Nophobia09]

Looks like you have created a database named essentialmode with tables addon_account, addon_account_data, addon_inventory, addon_inventory_items, billing, and users. You need to setup your connection to this database, even if it's local host. @josevloxx1

set mysql_connection_string "server=127.0.0.1;database=essentialmode;userid=root;password="
Should be something close to this. Change what you need to, such as password if you have one set.

[josevloxx1]

Looks like you have created a database named essentialmode with tables addon_account, addon_account_data, addon_inventory, addon_inventory_items, billing, and users. You need to setup your connection to this database, even if it's local host. @josevloxx1

set mysql_connection_string "server=127.0.0.1;database=essentialmode;userid=root;password="
Should be something close to this. Change what you need to, such as password if you have one set.

i haven't put password yet do i have to

[josevloxx1]

set mysql_connection_string "server=127.0.0.1;database=essentialmode;userid=root;password="

why it say this bro all jobs item inventories are in idk

[josevloxx1]

Looks like you have created a database named essentialmode with tables addon_account, addon_account_data, addon_inventory, addon_inventory_items, billing, and users. You need to setup your connection to this database, even if it's local host. @josevloxx1

set mysql_connection_string "server=127.0.0.1;database=essentialmode;userid=root;password="
Should be something close to this. Change what you need to, such as password if you have one set.

it doesn't not let me conect to my server give me alot of errors bro

[Nophobia09]

Still looks like it's trying to connect to serverdurango2.0 also when your server starts it should not be creating the database or adding columns or tables, which it looks like your is. If you can send me a link to your server folder I can set it up for you. Send me your email address and I'll email you.

…

________________________________ From: josevloxx1 ***@***.***> Sent: Thursday, June 17, 2021 10:42:44 PM To: brouznouf/fivem-mysql-async ***@***.***> Cc: Nophobia09 ***@***.***>; Comment ***@***.***> Subject: Re: [brouznouf/fivem-mysql-async] [ script:mysql-async] [MySQL] [ERROR] [esx_vehicleshop] An error happens for query "SELECT * FROM `vehicles` : []": ER_BAD_DB_ERROR: Unknown database 'fivem' (#175) Looks like you have created a database named essentialmode with tables addon_account, addon_account_data, addon_inventory, addon_inventory_items, billing, and users. You need to setup your connection to this database, even if it's local host. @josevloxx1<https://github.com/josevloxx1> [Captura de pantalla (1466)]<https://user-images.githubusercontent.com/85920394/122338269-1a6bf180-cf05-11eb-8a1a-c112a9a2ca82.png> set mysql_connection_string "server=127.0.0.1;database=essentialmode;userid=root;password=" Should be something close to this. Change what you need to, such as password if you have one set. it doesn't not let me conect to my server give me alot of errors bro — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#175 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ARDHD6E6L2ELDYBUR5WJ5IDTTKXCJANCNFSM46YQHEEA>.

[debugferro]

@sopergoras123 @Nophobia09 I'm facing the same issue. But I have configured everything just like that.

Inside my config file:

set mysql_connection_string "server=localhost;user=fivem;database=es_extended;password=mypass"

I do have this user "fivem" with the password "mypass" in`my localhost MySQL db. And I conceded full perm to the this user. I also tried:

set mysql_connection_string "mysql://fivem:mypass@localhost/es_extended?waitForConnections=true&charset=utf8mb4
set mysql_connection_string "mysql://fivem:mypass@127.0.0.1/es_extended?waitForConnections=true&charset=utf8mb4
set mysql_connection_string "host=localhost;user=fivem;database=es_extended;password=mypass"
## etc...

Using HeidiSQL, I ran the file es_extended.sql with this user, and created some tables. But it stills complains when I run the server:

[  script:mysql-async] [MySQL] [ERROR] [esx_vehicleshop] An error happens for query "SELECT * FROM `vehicle_categories` : []": ER_ACCESS_DENIED_ERROR: Access denied for user 'fivem'@'localhost' (using password: YES)

Do I have to run other .SQL files? If I do, then what is the order? Because I tried to run some, and many of them complain that another table doesn't exist, so I have to run other SQL files because they depend on the existence of another table. All of this is not very friendly to new developers, because I couldn't find updated documentation about it. My version is the legacy one (https://github.com/esx-framework/esx-legacy)

I will be very happy if one of you could point me in the right direction regarding this.

Thank you.

[sarmad-gaming]

https://cdn.discordapp.com/attachments/748504801540571137/883135480928043068/Untitled.png
I have this problem any help?

[sarmad-gaming]

[boermansjo]

There is nothing wrong with your server @colector-user
Stored queries are amazing and normal :)

[Nynag]

im having the same exact problem, im the only one that can enter the server the other people it says awaiting scripts then my remote control starts to pop out all this mysql things, how do i fix it if someone can add inbox me with the help.

[Nynag]

tnx El mar, 7 de dic. de 2021 a la(s) 11:34, Konstantinos Gkoras ( ***@***.***) escribió:

…

im having the same exact problem, im the only one that can enter the server the other people it says awaiting scripts then my remote control starts to pop out all this mysql things, how do i fix it if someone can add inbox me with the help. [image: image] <https://user-images.githubusercontent.com/94886994/142974737-5cf9bd6f-5c17-4256-903c-0ebb6b56d49e.png> When this error appears it means the re is sometihng wrong with the backend of the database. Restart the server. If the problem persists re-do the whole database from the beginning as I do when something like this happens, or before that check if the database can handle the load of the server. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#175 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AWT5YUXRX2APT7MTDCTN4VTUPYZQFANCNFSM46YQHEEA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.