MySQL Problem. - Printable Version

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=551393)

MySQL Problem. - Ercha - 18.12.2014

Hello all. So i'm having a problem with loading the gm based on mysql from the host. When I run it on localhost, it works, all the username, database name and password, but when I try to run it with the Vortex Server host, It sends me this error in mysql log:

Код:

[MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'ErchaSdb'@'66.225.195.162' (using password: YES).

This is mysql connection info if i use the paid host:

Код:

mysql_connect("mysql.vortexservers.com", "ErchaS", "ErchaSdb", "s1j8Z23Xcr", connection, 1);

This is mysql connection info if i use the localhost, not the paid one:

Код:

mysql_connect("localhost", "cnrsf", "cnrsf", "cnrsf", connection, 1);

Re: MySQL Problem. - Luicy. - 18.12.2014

Simple. Your paid host is blockning connection out of allowed that they has made.

Re: MySQL Problem. - D1am0nd - 18.12.2014

had the same problem.

Re: MySQL Problem. - Ercha - 18.12.2014

Quote:

Originally Posted by Meller

Simple. Your paid host is blockning connection out of allowed that they has made.

So there's no possible way to fix this?

Re: MySQL Problem. - Luicy. - 18.12.2014

Nope, use free host or try contact your paid host

Re: MySQL Problem. - TRTDM - 18.12.2014

Use any MySQL host, many sites offer it for free

Re: MySQL Problem. - Vince - 18.12.2014

Yeah well, chances are you need to use "localhost" on the remote server, too. "Localhost" refers to the machine the server runs on, not your own PC. Connecting via the external IP is like knocking on your own front door.