开发者

what MySQL permissions are required for mysql_real_escape_string()?

what MySQL permissions are required for mysql_real_escape_string()?

开发者_JAVA技巧

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:-

  1. INSERT
  2. SELECT
  3. UPDATE
  4. 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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜