note 16625 deleted from function.mysql-escape-string by jimw

From: Date: Thu, 08 Nov 2001 00:03:00 +0000
Subject: note 16625 deleted from function.mysql-escape-string by jimw
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-20569@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.

« previous php.notes (#20569) next »