I want to create a limited user to access the databases for my forums and some other things rather than using root (I see this as a security risk). I've been looking around and this is what i've come up with so far, do you see anything wrong with it?
| Code: |
| GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,REFERENCES,INDEX,LOCK TABLES,CREATE TEMPORARY TABLES
ON phpbb.* TO 'admin'@'localhost' IDENTIFIED BY 'xxxxxxxxx'; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,REFERENCES,INDEX,LOCK TABLES,CREATE TEMPORARY TABLES ON eqdkp.* TO 'admin'@'localhost' IDENTIFIED BY 'xxxxxxxxx'; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,REFERENCES,INDEX,LOCK TABLES,CREATE TEMPORARY TABLES ON eqbkp.* TO 'admin'@'localhost' IDENTIFIED BY 'xxxxxxxxx'; |
