我最近将我的流浪汉从ubuntu / trusty-64升级到了bento / ubuntu-16.04.随着MySQL更新到5.7.我已经对我的剧本进行了几次更新,但在设置root用户的密码时我一直遇到困难.
在过去(5.7之前),以下就足够了:
- name: MySQL | Set the root password.
mysql_user:
name=root
host=localhost
password={ { mysql_root_password }}
become: true
在我的剧本中,这是通过尝试删除匿名用户来测试的.
- name: MySQL | Delete anonymous MySQL server user for { { server_hostname }}
mysql_user:
name=""
host="{ { server_hostname }}"
state="absent"
login_user=root
login_password={ { mysql_root_password }}
但是,现在我的剧本在这一步失败了,返回:
“Access denied for user ‘root’@’localhost'”
TASK [mysql : MySQL | Delete anonymous MySQL server user for vagrant] **********
task path: /Users/jonrobinson/vagrant/survey/playbooks/roles/mysql/tasks/mysql.yml:51
fatal: [vagrant]: FAILED! => {"changed": false, "failed": true, "msg": "unable to connect to database, check login_user and login_password are correct or /home/vagrant/.my.cnf has the credentials. Exception message: (1698, \"Access denied for user 'root'@'localhost