[HELP]How Can i Get Online My DB? For The Web?

[EvadeTube]

Hello Guys my Qustion is That

 

 

How Can i Get my DB From Navicat Online!!

For My Web Site That it Host on another PC?

 

Like to See on the web The Stat Of Server Online Offline,Seven Sings And all the stuff like that

 

If some one Know Please Post an Answer Here!

 

Thanks a Lot!

[ServeSATAN]

you have web and server different pcs?

 

answer is simple put in web servers configs gameserver ip and ports what is hard?

[EvadeTube]

yes in a diffrent pc ine a diffrent country i just change the web and i need to add scipts like for The Castle status etc but i dont know what i have to do .....

 

 

 

EDIT:  i Know with the scipts i Dont know how to connect them with the server db!

[DarkKnightCZ]

supermac: you have to do three things

 

1) open mysql configuration file (my.cnf,  for linux /etc/mysql/my.cnf), find "bind-address" (without "), edit ip 127.0.0.1 to your internal IP or rem it (add # before)

2) set up port forwarding on router to your internal IP and port 3306

3) create new user (you have to add ip of your webserver like this, you have site google.com, ip of google.com is 74.125.87.106 -> create this user - webstatus@74.125.87.106    => this will limit connection from given IP)

 

but, this is extremly dangerous, you will be vulnerable to many attacks, point 3 will help only for some type of attacks

 

 

//edit Leki: yes, it is hard cause mysql can listen on one ip or on all ips (cant listen on only 2)

  supermac: if you wont be able to start lineage server after step 1, rem that line (add # before bind-address), this will set mysql to listen on every internal IPs