There is a default mylsq root user which is configured without a password after running production playbook. Is this by design? I’m getting this warning when checking mysql status
service mysql status
Nov 16 16:33:18 example_com-production /etc/mysql/debian-start[14928]: WARNING: mysql.user contains 1 root accounts without password!
And if I check the mysql table I actually see the root user w/o password:
MariaDB [mysql]> select User,Password from user;
+----------------------+-------------------------------------------+
| User | Password |
+----------------------+-------------------------------------------+
| root | *XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |
| root | |
| root | *XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |
| root | *XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |
| debian-sys-maint | *YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY |
| root | *XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |
| example_com | *ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ |
+----------------------+-------------------------------------------+