Error in MySQL 'Update root password for all root accounts' task

[stefthoen]

Hi,

I got Phansible working correctly if I use vagrant up for the first time, but if I vagrant provision I get the following error message. Do you perhaps know what could be the problem? Please let me know if I can provide you with anything. Thanks!

==> default: TASK [mysql : mysql | Update root password for all root accounts] **************
==> default: failed: [192.168.88.02] => (item=paprikapatterns) => {"failed": true, "item": "paprikapatterns", "msg": "unable to connect to database, check login_user and login_password are correct or /********/.my.cnf has the credentials. Exception message: (1044, \"Access denied for user '********'@'localhost' to database 'mysql'\")"}
==> default: failed: [192.168.88.02] => (item=127.0.0.1) => {"failed": true, "item": "127.0.0.1", "msg": "unable to connect to database, check login_user and login_password are correct or /********/.my.cnf has the credentials. Exception message: (1044, \"Access denied for user '********'@'localhost' to database 'mysql'\")"}

[debo]

@baardbaard thanks for reporting this, I'm going to have a look into it as soon as I can.

[stefthoen]

My bad, I misunderstood the webapp and entered root with password root for my MySQL db user. I replaced it with a different user/pass, ran vagrant destroy and now vagrant provision doesn't give me any problems.

Maybe you could check for people who try to create a user root in the webapp, but perhaps it's just me who would do something that stupid. :)

[debo]

@baardbaard I'm going to leave it open otherwise I'm going to forget about it, but thanks for the heads up.

[naxhh]

Yep. if you change root password it will not able to connect anymore....
It's kind of obscure requirement. So maybe is worth thinking a bit more about it.