Fizo Posted May 20, 2016 Share Posted May 20, 2016 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 ? Quote Link to comment Share on other sites More sharing options...
0 DrenepiaWorld Posted May 20, 2016 Share Posted May 20, 2016 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 Quote Link to comment Share on other sites More sharing options...
0 Fizo Posted May 20, 2016 Author Share Posted May 20, 2016 i add them and i am waiting for Web host company to be sure for dedicated ip ! Quote Link to comment Share on other sites More sharing options...
0 Tessa Posted May 20, 2016 Share Posted May 20, 2016 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: Quote Link to comment Share on other sites More sharing options...
0 Fizo Posted May 20, 2016 Author Share Posted May 20, 2016 This... :lol: it was an example from a br site :-\ Quote Link to comment Share on other sites More sharing options...
0 Tessa Posted May 21, 2016 Share Posted May 21, 2016 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: Quote Link to comment Share on other sites More sharing options...
0 ๖ۣۜYoung ๖ۣۜthug Posted May 21, 2016 Share Posted May 21, 2016 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 Quote Link to comment Share on other sites More sharing options...
0 Tessa Posted May 21, 2016 Share Posted May 21, 2016 he has dedicated server the only he need to do is open 3306 from firewall but what protocol ? hmmm TCP is the default. Quote Link to comment Share on other sites More sharing options...
0 ๖ۣۜYoung ๖ۣۜthug Posted May 21, 2016 Share Posted May 21, 2016 TCP is the default. well is opened by default on dedicated server , how about using the remote MySQL connection secured with SSL? Quote Link to comment Share on other sites More sharing options...
0 Tessa Posted May 21, 2016 Share Posted May 21, 2016 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...). Quote Link to comment Share on other sites More sharing options...
0 ๖ۣۜYoung ๖ۣۜthug Posted May 21, 2016 Share Posted May 21, 2016 PDO accepts as a parameter an array of SSL authentication data (key, cert...). yes i know , it's more secure. Quote Link to comment Share on other sites More sharing options...
0 Tessa Posted May 21, 2016 Share Posted May 21, 2016 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: Quote Link to comment Share on other sites More sharing options...
0 ๖ۣۜYoung ๖ۣۜthug Posted May 21, 2016 Share Posted May 21, 2016 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 Quote Link to comment Share on other sites More sharing options...
0 Tessa Posted May 21, 2016 Share Posted May 21, 2016 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 monthI doubt if it gives you any warranties... :lol: Quote Link to comment Share on other sites More sharing options...
0 ๖ۣۜYoung ๖ۣۜthug Posted May 21, 2016 Share Posted May 21, 2016 I doubt if it gives you any warranties... :lol: not really >:D Quote Link to comment Share on other sites More sharing options...
0 Irelia#1 Posted June 23, 2016 Share Posted June 23, 2016 LOL! This "mysql_connect" (deprecated).Don't do that.. use PDO instead. Quote Link to comment Share on other sites More sharing options...
Question
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 ?
Link to comment
Share on other sites
30 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.