我最近将我的流浪汉从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/r