How to connect to a mysql remote host? - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: How to connect to a mysql remote host? (/showthread.php?tid=212091)

---

How to connect to a mysql remote host? - Sascha - 16.01.2011

Hi...
I'm trying to connect my samp server to my website's mysql...
I entered the server IP as exception for remote accesses...

On pawno I entered:
#define SQL_HOST "208.115.247.247"
#define SQL_DB "sgtadmin_hsaserver"
#define SQL_USER "sgtadmin_hsabot@sgt-site.tk"
#define SQL_PASS "example123"

mysql_connect(SQL_HOST,SQL_USER,SQL_DB,SQL_PASS);

however on the mysql log I get: CMySQLHandler::Connect() - Access denied for user 'sgtadmin_hsabot@'@'lizard.serverffs.com' (using password: YES) (Error ID: 1045)

(using gstyle's plugin)
so what I did wrong?

---

Re: How to connect to a mysql remote host? - Typhome - 16.01.2011

#define SQL_HOST "208.115.247.247"
#define SQL_DB "sgtadmin_hsaserver"
#define SQL_USER "sgtadmin_hsabot"
#define SQL_PASS "example123"

---