SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help > Help Archive

 
 
Thread Tools Display Modes
Old 16/01/2011, 03:36 PM   #1
Sascha
High-roller
 
Sascha's Avatar
 
Join Date: Jul 2009
Location: Germany
Posts: 1,494
Reputation: 70
Default How to connect to a mysql remote host?

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?
__________________
Don't bother to contact me, I'm out of SA-MP
Sascha is offline  
Old 16/01/2011, 04:56 PM   #2
Typhome
Gangsta
 
Typhome's Avatar
 
Join Date: Mar 2009
Location: Estonia
Posts: 950
Reputation: 10
Default Re: How to connect to a mysql remote host?

#define SQL_HOST "208.115.247.247"
#define SQL_DB "sgtadmin_hsaserver"
#define SQL_USER "sgtadmin_hsabot"
#define SQL_PASS "example123"
Typhome is offline  
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Connect Nonameman Scripting Help 7 19/04/2012 07:42 PM
MySQL don't connect exDDDD Help Archive 1 05/01/2011 04:30 PM
[MYSQL]Connect bug or...? [SF]Bamdude37 Help Archive 13 30/08/2010 08:45 PM
[HELP] Cannot connect to mysql Host.. DarrenReeder Help Archive 0 01/05/2010 03:13 PM
Can't connect to a 5 numeric host server. Andy_McKinley Client Support 0 20/12/2009 01:48 PM


All times are GMT. The time now is 05:43 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.