what MySQL permissions are required for mysql_real_escape_string()?
what MySQL permissions are required for mysql_real_escape_string()
?
i want to create a db user with the minimum abilities specifically for using with mres()...
It's done on the client side, so the only permission needed is usage (since all you need is a connection, not even read permissions)...
EDIT, after comments of "ircmaxell":-
You will require the following permissions / privileges to be set:-
- INSERT
- SELECT
- UPDATE
- CREATE TEMPORARY TABLES
The above privileges are the minimum ones that should be provided to any user account of each & every database of MySQL.
If administrator wants to create just a basic simple account, where the user will need to view / select the records, then only the "SELECT" permission is just required. No other permissions are needed to be given (as regards to the comment of "ircmaxell").
Hope it helps.
精彩评论