SA-MP Forums Archive
MySQL/Streamer Help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL/Streamer Help (/showthread.php?tid=628042)



MySQL/Streamer Help - CountryTrooper441 - 05.02.2017

Hello,

I'm having problems loading MySQL into the server.. Everything says it's loaded, When I get in game, its not there.. and when I go into my local host, Everything is loaded and works...


Can someone possibly help me?

Thanks!


Re: MySQL/Streamer Help - Astralis - 05.02.2017

Because you connect to 127.0.0.1 in your script, try to change this to your phpmyadmin/MySQL IP.

And if you are not using 127, then enable the EXTERNAL MySQL connections.


Re: MySQL/Streamer Help - Vince - 05.02.2017

What a load of BS. Localhost or 127.0.0.1 refers to the system the server is running on. If the script is uploaded then localhost refers to that system and not your local PC. Connecting to your own external IP is like knocking on your own front door every time you want to get something out of the fridge. Just go to the fridge directly.


Re: MySQL/Streamer Help - CountryTrooper441 - 05.02.2017

When I put in "localhost" for the host it doesn't work. When I put in the IP for the host's MySQL it works but the 'gates' don't want to load in game, everything else does like the houses and dynamic doors and stuff..


Re: MySQL/Streamer Help - Astralis - 05.02.2017

Quote:
Originally Posted by CountryTrooper441
View Post
When I put in "localhost" for the host it doesn't work. When I put in the IP for the host's MySQL it works but the 'gates' don't want to load in game, everything else does like the houses and dynamic doors and stuff..
Gates loaded ever before or not?


Re: MySQL/Streamer Help - CountryTrooper441 - 05.02.2017

Quote:
Originally Posted by Astralis
View Post
Gates loaded ever before or not?
Gates worked once before, and when I load up my local host everything works fine.. Just not on the host...