Mysql protection ?
#1

Hi everybody,


I wanted to know what should I do to protect my server if I'm using a mysql database. What type of protection ?

That's all, thank you !
Reply
#2

BUMP
Reply
#3

Apart from a secure host, with a secure firewall and a secure password there's not many things you can do about external security. I am not an expert in security so I can't really tell;

About script security make sure you escape any string that the a player may send into a query or you may suffer SQL injections which can crash your server or DB.
Reply
#4

Quote:
Originally Posted by CuervO
Посмотреть сообщение
Apart from a secure host, with a secure firewall and a secure password there's not many things you can do about external security. I am not an expert in security so I can't really tell;

About script security make sure you escape any string that the a player may send into a query or you may suffer SQL injections which can crash your server or DB.
How can I do please ?

Thank you
Reply
#5

Quote:
Originally Posted by anou1
Посмотреть сообщение
How can I do please ?

Thank you
On blueg's plugin:

https://sampwiki.blast.hk/wiki/MySQL/R33..._escape_string
Reply
#6

Thank you, but I don't understand what have I to do ?

For exemple for a register system, when I have to save the player password, I should use this ?


If I use "mysql_format" Is that secure ?
Reply
#7

Use mysql_format everytime you pass a string as an argument in a query.
Reply
#8

Thank you !

So that will protect me of any sql injection in game ?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)