Hey there,
Trying to deploy a staging server.
Running on a windows machine, i am running the ansible-playbook server.yml -vvvv -e env=staging
from within Vagrant, in /vagrant .
I think i’ve set up everything there is to set, but still i get this error:
failed: [ip-address] => (item=localhost) => {"failed": true, "invocation": {"module_args": {"append_privs": false, "check_implicit_admin": true, "config_file": "~/.my.cnf", "encrypted": false, "host": "localhost", "login_host": "localhost", "login_password": null, "login_port": 3306, "login_unix_socket": null, "login_user": null, "name": "root", "password": "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER", "priv": null, "ssl_ca": null, "ssl_cert": null, "ssl_key": null, "state": "present", "update_password": "always", "user": "root"}, "module_name": "mysql_user"}, "item": "localhost", "msg": "unable to connect to database, check login_user and login_password are correct or /root/.my.cnf has the credentials. Exception message: (1045, \"Access denied for user 'root'@'localhost' (using password: NO)\")"}
It appears 4 times; for me set hostname, localhost, 127.0.0.1, and ::1 .
I’ve even tried hardcoding my mysql_root_password in the mariadb task - but each time i get this error which specifies using password: NO
…
Its similar to a few old issues i’ve seen but none of the suggested fixed helped me.
I’m new to the great roots pack - maybe im not getting something …
I’ve tried sshing and apt-get removing the all mysql repos, and ran the playbook again, got the same error, and then tried mysql -u root -p
to check - but my set password doesnt work.
Any tip in the right direction would be greatly appreciated - it’s been hours . . .