AFAIK, you don't change /etc/mysql/conf.d/my.cnf
.
It contains a password created by WordOps on db install.
Some newer DB installations by default use password-less login (only) for users at localhost.
You have to change root db login configuration to use password.