Tag Archive for "MySQL" tag

MySQL Grant

April 11th, 2009 by usage | 0

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, […]