How to create Mysql users

Quickly generate the commands to create users and manage their grants
  • Strong password
  • Least required permissions (SELECT only)
  • Pre-made permissions sets from least permissive to most.
  • Read only (SELECT)
  • CRUD (SELECT, INSERT, UPDATE, DELETE)
  • Full app (SELECT,UPDATE,INSERT,DELETE,CREATE,ALTER,INDEX,DROP)
  • Replication(REPLICATION SLAVE)
  • Admin (ALL PRIVILEGES)

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store