#how to connect server to database

95 messages · Page 1 of 1 (latest)

white nymph
#

How do i connect my server to database so all of the things would be in there

pseudo roostBOT
#

Hi there 👋
Thank you for creating a post on our Community Forum. Please keep in mind that we don't provide official support on Discord. This is a forum for the community, by the community. Meaning that help is not guaranteed. Now let's wait and see if someone of our lovely community can help you out!

newtip TIP: Need actual official support? Reach out to our customer care: zaplivechat
https://zap-hosting.com/en/customer/support/

glass yoke
#

Which type of server?

white nymph
#

Fivem

#

Qbcore

granite mango
#

Do you have the Mysql Async Plugin installed?

white nymph
#

i had but it disappeared

#

wtf can you link the real one

granite mango
#

You can easily install it via your dashboard

pliant trench
#

VPS or game server?

granite mango
glass yoke
#

If you have oxmysql installed you do not need async fyi

white nymph
#

i dont have oxmysql

white nymph
#

so what do i do now i installed oxmysql and the async

granite mango
#

You only need one

#

Take oxmysql

#

If its not already in your server config add the two lines in it (at the very top):

set mysql_connection_string "mysql://root:12345@localhost:3306/es_extended"
set mysql_connection_string "user=root;password=12345;host=localhost;port=3306;database=es_extended"

And change the following values:
1. Line: "12345" to you database password, "es_extended" to your database name
**2. Line: **the same as in 1. Line

#

The password and database name you can get from the database tab in your server dashboard if you have a fivem gameserver

granite mango
white nymph
#

okay let me try

#

i only have that 1 line in my config

#

so do i add the other one also

granite mango
#

yes

white nymph
#

just after the 1 one?

granite mango
#

no nvm you can choose between those

#

my bad

white nymph
#

oh ok

granite mango
#

but check the password and database name

white nymph
#

yeah i know those

#

so now do i just start my server?

granite mango
#

yes

white nymph
#

okay

#

still doesnt work

granite mango
#

any error in console?

white nymph
#

not joined but nothing in zap shitty console

#

sad to see nothing in phpmyadmin

#

only the zap user but aint got no files there

granite mango
#

you dont use your txadmin console?

white nymph
#

i dont have txadmin

granite mango
#

every fivem server has txadmin?!

white nymph
#

dev server

granite mango
#

a zap-hosting game server?

white nymph
#

ye

granite mango
#

then you should have txadmin

white nymph
#

nah its costs 10 euro more

granite mango
#

oh nvm you have a non txadmin server

white nymph
#

yep

#

which is crazy but

granite mango
white nymph
#

yeah

#

only the zapuser thing but nothing inside it

granite mango
#

then you have to import the sql files from your qbcore scripts

white nymph
#

how do i do that

granite mango
#

ignore the installation of mysqlasync

white nymph
#

hmm okay

granite mango
#

the sql files have to be in the script folders

white nymph
#

yeahh

#

i got them in

granite mango
#

and if you import them i should work

white nymph
#

i changed my phpadmin skin to a fucking retard one thats my biggest problem currentlyu haha 😄

granite mango
#

xD

white nymph
#

goddamn how do i change it back

#

cant get anything out of this shitr 😄

granite mango
#

go on the phpmyadmin logo in the upper right corner

#

and then in the middle of the screen

#

there should be a theme option

white nymph
#

thanks

#

illl go join if everything works

#

but now my problem is that when i join the server it says mounted and some addon but it takes so long

#

i deleted my cache so idk what happened after it

#

but other servers work just fine

#

4 out of 94 addons takes a long time

granite mango
#

could you send a screenshot?

white nymph
granite mango
#

did you restarted the server?

white nymph
#

yeah it was before the database trhing

granite mango
#

did you changed anything in webpack

white nymph
#

i dont think so

granite mango
#

pls check if the resource is in this folder
server-data/resources/[system]/[builders]/webpack

white nymph
#

yeah i got webpack there

#

but i just found out that i didnt put the

#

set mysql_connection_string "mysql://root:12345@localhost:3306/es_extended" thing into my config so i did it now

granite mango
white nymph
#

imma try

#

so did i had to put that mysql connection shit string thing into server config or just the oxmysql config if there is one

#

i put it into server.cfg

granite mango
#

server config

white nymph
#

well i got in

granite mango
#

and you also have to start oxmysql

white nymph
#

i got in

#

i used my backup so now it also deleted some files that my brother configured so now i can do everything bymyself

granite mango
#

very nice

white nymph
#

thanks bro

granite mango
#

np your welcome