I have 2 EC2 server instances where 1 I am using ansible to install mysql
on the other ec2 instance.
ISSUE TYPE
Bug Report
COMPONENT NAME
- Installing mySQL on AWS EC2 Linux
ANSIBLE VERSION
ansible 2.6.5
CONFIGURATION
So this is what I have so far
- hosts: database
sudo: yes
tasks:
- name: Install mySQL repo
yum:
name=http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
state=present
- name: Install mySQL
yum: pkg={{ item }}
with_items:
- mysql-community-server
- mysql-community-client
- MySQL-python
- name: start mySQL service
action: service name=mysqld state=started
- name: copy my.cnf
template: src=.my.cnf dest=/root/.my.cnf owner=root mode=0600
- name: Create database user
mysql_user: name=bob password=12345 priv=*.*:ALL state=present
login_user=root login_password=Password123_#
And this is my .my.cnf
[client]
user=root
password=Password123_#
Im getting this error everytime
fatal: [FAILED! => {"changed": false, "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)\")"}
to retry, use: --limit @/etc/an
OS / ENVIRONMENT
Linux AMI
Is this supported on EC2 AWS?
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to ansible-project+unsubscr...@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/25f91ac6-d49c-4db4-b996-cecd90c8c27e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
