Pedro Gomes

Aug 13, 2021

1 min read

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

Additionally:

  • Pre-made permissions sets from least permissive to most.

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.