Free Tutorials, Screencasts, Demos – Usage.cc

Create a user with limited permissions

GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, CREATE ROUTINE, ALTER ROUTINE,CREATE TEMPORARY TABLES,DROP,INDEX, LOCK TABLES  ON yourdb.* TO usr@localhost IDENTIFIED BY "pwd"

if you want to create a user that has access to databases that start with a certain prefix.

GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, CREATE ROUTINE, ALTER ROUTINE,CREATE TEMPORARY TABLES,DROP,INDEX, LOCK TABLES ON `clients_abc_%`.* TO client_user123@localhost IDENTIFIED BY "lalala"

Tags: grant | MySQL

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.