Generate your own secure password by pasting the snipet below in your shell:

< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c${1:-32};echo;

Manage your Mysql grants as code using Ansible

About Mysql

Mysql is one of the most popular relational databases in the market. It's open source and free to use, popular Mysql alternatives like MariaDB, Percona, and Aurora Database from Amazon are all derived from Mysql and offer full (or very near) compatibility with the original Mysql.

Security/Other Concerns

The reason you want to create custom user/password and permission grants is 1) Security: you want restrict permissions of each application to the bare minimum, this will reduce blast radius of whatever problem you may face with exploits, 2) Monitoring: different users allows you to monitor database usage per application, impose limits, debug/troubleshoot problems, pinpoint the root cause earlier.

Mysql consulting

Looking for expert database admin consulting for your infrastructure? Founded by Peter Zaitsev, Percona is a database consulting company. They can provide support, advising or manage services for you. They maintain their own fork of Mysql, develop their own tools for live backups, Cluster management, and others. Active participants in the OSS community around Mysql and it's derivatives. Peter Zaitsev is the author of the most popular book about high performance Mysql and is a popular speaker at conferences. Percona employs over 100 database experts all over the world and can support any enterprise looking for improvements.