How to create Mysql users

Because who wants to go through 1000+ words SEO optimized articles in Digital Ocean everytime? We all know what we want, two lines of code to copy paste. Hence my new website: https://howtocreateusermysql.com/

Quickly generate the commands to create users and manage their grants

It gives you, by default:

  • Strong password
  • Least required permissions (SELECT only)

Additionally:

  • 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)

In the future, may also support additional database engines.

This is great if you just want to quickly copy paste a command and have your new Mysql users and database privileges ready at once .

As usual, managing this in code should be the preferred way of doings things, and in the end I’ve also added a page with instructions on how to create mysql users/grants with Ansible, Chef and Puppet.