note 16625 added to function.mysql-escape-string
| From: | karl at katzke dot net | Date: | Wed, 07 Nov 2001 04:03:52 +0000 |
| Subject: | note 16625 added to function.mysql-escape-string | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-20540@lists.php.net to get a copy of this message | ||
While mysql_escape_string is great for checking yourself, if you have your mysql user permissions
set such that a malicious user COULD drop the database, you need to reexamine your whole security
setup.
I suggest creating a couple of different usernames with different permissions, and using them as
needed. For instance, if you have a form that needs to select and insert, connect to the database as
a user that can only select and insert... at no time should you allow an outside user to have access
to anything that could let enter a malicious delete or drop query.
--
http://www.php.net/manual/en/function.mysql-escape-string.php
http://master.php.net/manage/user-notes.php?action=edit+16625
http://master.php.net/manage/user-notes.php?action=delete+16625
http://master.php.net/manage/user-notes.php?action=reject+16625