[How To]SQL Database Secure

01/20/2018 20:20 PlugMan#1

Hello E*PvP

While reading some tutorials in elitepvp
i want to know how to secure database from hack and threads
only by closing port's in firewall or what ?
I'm sorry but as first time i touch shaiya i want to know
before i attempt to make a public server

Thank you !

01/20/2018 20:33 {Skrillex}#2

Hi,
normal just close your SQL Port ( 1433) then nobody can use sql server for bad things. But when you use PHP Scripts that connect to your mssql Server then you have to watch for sql injection. It�s more secure the php files then the sql server.

Regards

01/20/2018 20:48 PlugMan#3

Quote:

Originally Posted by .:Skrillex:.

Hi,
normal just close your SQL Port ( 1433) then nobody can use sql server for bad things. But when you use PHP Scripts that connect to your mssql Server then you have to watch for sql injection. It�s more secure the php files then the sql server.

Regards

I'm using all scripts from epvp and those who release say's are 100% SQL Injection fixed , em i safe with that ?

01/20/2018 22:49 killer2p#4

nothings 100%

01/20/2018 23:40 MC Flip#5

Close remote SQL ports as Skrillex suggested.

If you want an additional layer, change game and login ports.

01/21/2018 02:23 XareL#6

if u want sql secure u setup local or change shaiya - shaiya123 and do what these people say

01/21/2018 16:19 {Skrillex}#7

Quote:

Originally Posted by MC Flip

Close remote SQL ports as Skrillex suggested.

If you want an additional layer, change game and login ports.

Still useless when don�t changing game.exe Version and Moleboxed it. It takes 10 Seconds to get the connected game ports

01/21/2018 16:59 MC Flip#8

Quote:

Originally Posted by .:Skrillex:.

Still useless when don�t changing game.exe Version and Moleboxed it. It takes 10 Seconds to get the connected game ports

True, forgot to mention that.