How should i fill in this MySQL?

How should i fill in this MySQL? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: How should i fill in this MySQL? (/showthread.php?tid=425067)

How should i fill in this MySQL? - Eminem 2ka9 - 24.03.2013

I'm not sure how to fill in the MySQL information into my gamemode, so i will give you all the information i have with my MySQL database and we'll see if you can fill it in for me correctly.

I want to use the Database "8081_objects" - The password to my database is "Hello123" (not really)
This is a photo of my current database information. (I'm using Volt-Host MySQL)
http://prntscr.com/xnhyf

Below is what i currently have filled into my gamemode, which doesn't work because when i try to use the database in-game, the dialog closes and nothing happens, which is a sign the database doesn't work.

PHP код:



#define SQL_HOST                     "66.85.149.50"

#define SQL_USER                 "8081_objects"

#define SQL_PASS                 "hello123" //Not real

#define SQL_DB                          "8081_objects"

Re: How should i fill in this MySQL? - Vince - 24.03.2013

If the database is on the same box as your SA-MP server then you should be able to connect with '127.0.0.1' (localhost). Some providers block external connections to the database. If that doesn't work then you'll need to check the logs.

Re: How should i fill in this MySQL? - Eminem 2ka9 - 24.03.2013

Quote:

Originally Posted by Vince

If the database is on the same box as your SA-MP server then you should be able to connect with '127.0.0.1' (localhost). Some providers block external connections to the database. If that doesn't work then you'll need to check the logs.

I entered in

Код:

#define SQL_HOST                     "127.0.0.1" 
#define SQL_USER                 "8081_objects" 
#define SQL_PASS                 "hello123" //Not real 
#define SQL_DB                          "8081_objects"

Sadly.. still no luck. The dialog just closes

Re: How should i fill in this MySQL? - Eminem 2ka9 - 24.03.2013

still not working, i don't know what the problem is.