Help Connect Server With Site - Status

[Fizo]

Hi from me !!!

 

I am new to that , i wanna connect site with the server so the first step it to take a hosting ! 

 

i took hosting with cpanel ! then cpanel > Remote MySQL > Then i enter my IP 

 

Also in my Navicat i made a new User with my ip Also a custom User.

 

What infos i need to enter inside of script ?

 

My Own ip or dedicated ip from host company ? 

[DrenepiaWorld]

i know about db but i need to found a way to connect my site with server ! did i need to open a 3306 as a port ! also if i am right with Remote MySQL i can connect them easy !

3306 is the mysql port, if it's not open it won't make connection

[Fizo]

i add them and i am waiting for Web host company to be sure for dedicated ip ! 

[Tessa]

 

with this !

<?php
/***
***/
include('conexao_PDO.php');

//Valor Minimo para realizar a SOMA ( Player FAKE )
$var_min_soma = 3;

//Valor da soma, (Player Fake)
$var_soma = 10;

$buscar_player_on = $conexao_PDO->prepare("SELECT online FROM characters WHERE online = '1'");
$buscar_player_on->execute();

if($buscar_player_on->RowCount() >= $var_min_soma){
	$resultado = $buscar_player_on->RowCount() + $var_soma;
	
	//Exibir
	echo $resultado;
}else{
	echo $buscar_player_on->RowCount();
}
?>

This... :lol:

[Fizo]

This... :lol:

 

 

it was an example from a br site  :-\

[Tessa]

it was an example from a br site  :-\

You should (if you didn't) open port 3306 on your server, not on your web hosting. Then, in your script put the server IP and the port, along with the db account data. This is it... :lol:

[๖ۣۜYoung ๖ۣۜthug]

You should (if you didn't) open port 3306 on your server, not on your web hosting. Then, in your script put the server IP and the port, along with the db account data. This is it... :lol:

he has dedicated server the only he need to do is open 3306 from firewall but what protocol ? hmmm

[Tessa]

he has dedicated server the only he need to do is open 3306 from firewall but what protocol ? hmmm

TCP is the default.

[๖ۣۜYoung ๖ۣۜthug]

TCP is the default.

well is opened by default on dedicated server , how about using the remote MySQL connection secured with SSL?

[Tessa]

well is opened by default on dedicated server , how about using the remote MySQL connection secured with SSL?

PDO accepts as a parameter an array of SSL authentication data (key, cert...).

[๖ۣۜYoung ๖ۣۜthug]

PDO accepts as a parameter an array of SSL authentication data (key, cert...).

yes i know , it's more secure.

[Tessa]

yes i know , it's more secure.

But the SSL Certificate costs money (at least those with stronger encryption), and it's practically useless until you start working on something serious. :lol:

[๖ۣۜYoung ๖ۣۜthug]

But the SSL Certificate costs money (at least those with stronger encryption), and it's practically useless until you start working on something serious. :lol:

My webhosting provider has SSL for free it's not about money if u want to be secured...It cost less than 0,50$ per month

[Tessa]

My webhosting provider has SSL for free it's not about money if u want to be secured...It cost less than 0,50$ per month

I doubt if it gives you any warranties... :lol:

[๖ۣۜYoung ๖ۣۜthug]

I doubt if it gives you any warranties... :lol:

not really  >:D

[Irelia#1]

LOL! This "mysql_connect" (deprecated).
Don't do that.. use PDO instead.