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 | Chef | Puppet
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.
Mysql is known for its speed, reliability, and flexibility. It's also one of the most popular database engines used in web applications. Many popular web applications like WordPress, Drupal, Joomla!, and Magento use Mysql as their primary database back-end.
Why manage users/grants as code?
This is part of the devops movement where you move from having servers that are manually configured and expected to run for years to infrastructure and configuration as code, where any server is easily reproduced via code. This brings the best software engineering practices to the typical SysAdmin work. Any code changes can and should be peer reviewed, and version controlled. Managing changes across multiple environments becomes easier as it's easier to diff simple YAML config files instead of trying to find out the difference between servers. Among many other benefits.
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.