MySQL problem - 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: MySQL problem (/showthread.php?tid=481009)
+- 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: MySQL problem (/showthread.php?tid=481009)
MySQL problem - Jimmy0wns - 13.12.2013
Hey,
I've been trying to setup my new SA-MP server today.
It almost works, except for the MySQL part, thats because my database is not allowing me to connect, only via localhost.
My database is hosted at 0100dev (Dutch) and is there a way to allow my server connect to the database without having trouble?
I can't exactly show what the error is, because it includes my dynamic IP and such.
Re: MySQL problem - Astralis - 13.12.2013
If you are a root user in your phpmyadmin, then go to "users" > add new user, choose your username, enter password, and click on "any host" - that will allow any IP's to connect to the database using a username and password. If not, you would need to contact your provider to allow the IP to connect.
Re: MySQL problem - [MG]Dimi - 13.12.2013
MySQL Root has to enable remote connections to DB as far as I remember.
Re: MySQL problem - Jimmy0wns - 13.12.2013
----
Re: MySQL problem - Jimmy0wns - 13.12.2013
Problem has been fixed