在ubuntu安装mysql_在ubuntu上安装MySQL

我在安装MySQL时遇到问题，

这是我的MySQL部分

---

- name: Install MySQL

apt:

name: "{{ item }}"

with_items:

- python-mysqldb

- mysql-server

- name: copy .my.cnf file with root password credentials

template:

src: templates/root/.my.cnf

dest: ~/.my.cnf

owner: root

mode: 0600

- name: Start the MySQL service

service:

name: mysql

state: started

enabled: true

# 'localhost' needs to be the last item for idempotency, see

# http://ansible.cc/docs/modules.html#mysql-user

- name: update mysql root password for all root accounts

mysql_user:

name: root

host: "{{ item }}"

password: "{{ mysql_root_password }}"

priv: "*.*:ALL,GRANT"

with_items:

- "{{ ansible_hostname }}"

- 127.0.0.1

- ::1

- localhost

我有这个错误

failed: [default] => (item=vagrant-ubuntu-trusty-64) => {"failed": true, "item": "vagrant-ubuntu-trusty-64"}

msg: unable to connect to database, check login_user and login_password are correct or ~/.my.cnf has the credentials

failed: [default] => (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

failed: [default] => (item=::1) => {"failed": true, "item": "::1"}

msg: unable to connect to database, check login_user and login_password are correct or ~/.my.cnf has the credentials

failed: [default] => (item=localhost) => {"failed": true, "item": "localhost"}

msg: unable to connect to database, check login_user and login_password are correct or ~/.my.cnf has the credentials

我的.my.cnf是

[client]

user=root

password={{ mysql_root_password }}

并在服务器上复制时

[client]

user=root

password=root

我不明白为什么，〜/ .my.cnf被创建

谢谢