Geek Answers Handbook

What MySQL permissions are required for mysql_real_escape_string ()?

What MySQL permissions are needed for mysql_real_escape_string() ?

I want to create a db user with minimal features specifically designed for use with mres () ...

+4
source share
2 answers

This is done on the client side, so the only permission is to use (since all you need is a connection, not even read permission) ...

+5
source

EDIT, after comments by "ircmaxell" : -
You will need the following permissions / privileges: -

  • INSERT
  • SELECT
  • UPDATE
  • CREATE TEMPORARY TABLES

The above privileges are the minimum that should be granted to any user account of each MySQL database.

If the administrator wants to create just a basic simple account, where the user will need to view / select entries, then only the " SELECT " permission is required. No other permissions are required (regarding the comment "ircmaxell").

Hope this helps.

-1
source

More articles:


All Articles