[Question] Mysql - Printable Version

[Question] Mysql - 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: [Question] Mysql (/showthread.php?tid=282055)

[Question] Mysql - tony_fitto - 09.09.2011

Hey Everyone,

Sorry about the last post, but I got the answer.
Anyone here know how to create a mysql connection with a port?
Cause my database are only allow external connections by porst 80.

Regards Tony

Re: [Question] Mysql - iJumbo - 09.09.2011

mysql port its 3306 not 80 ... 80 its http

Re: [Question] Mysql - Vince - 09.09.2011

That was not the question. Try it like this:

pawn Code:

mysql_connect("xxx.xxx.xxx.xxx:80", ...);

Re: [Question] Mysql - tony_fitto - 10.09.2011

Quote:

Originally Posted by Vince

That was not the question. Try it like this:

pawn Code:

mysql_connect("xxx.xxx.xxx.xxx:80", ...);

Thanks, mate for the great answer

Re: [Question] Mysql - skullmuncher1337 - 10.09.2011

To Learn MySQL Basics, I'd direct you to this wonderful tut made by [HiC]TheKiller

https://sampforum.blast.hk/showthread.php?tid=159785

Re: [Question] Mysql - [M]onsieur - 10.09.2011

Quote:

Originally Posted by [ISS]jumbo

mysql port its 3306 not 80 ... 80 its http

The port can be any one (but it can not be used)
He probably should be using the 80, in http, once an error has occurred.

Re: [Question] Mysql - tony_fitto - 10.09.2011

Quote:

Originally Posted by [M]onsieur

The port can be any one (but it can not be used)
He probably should be using the 80, in http, once an error has occurred.

Well no, I have created an UCP and my connection to the website doesn't work cause of a secuirty reason they firewall only works on port 80 for external connections.

It's as well the same for the UCP to connect to my host, it doesn't work cause of the fire wall.

Anyways this didn't work mysql_connect(*******.mysql:80, ....);

Code:

[20:44:33] MySQL Error (0): Failed to connect. Unknown MySQL server host '**********.mysql:80' (3).