Pedro Gomes

It’s only a matter of time when Ethereum becomes the number one crypto currency and all products are priced in gweis. In some measures Ethereum already beat Bitcoin. In others, it’s well underway to become #1.

It’s already doing 6x as many transactions as the Bitcoin network.

It has almost…

--

--

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.

--

--