Try searching for "mysql" on galaxy.ansible.com and you'll see a lot of roles that set up MySQL>
In this case it sounds like you have a MySQL specific config issue and it's not specifically an Ansible issue, but I agree it's not the best possible experience from the tool. (Note that you'll really want to see this fully automated anyway, hence why I recommend researching MySQL roles. Having to manually run the interactive step to configure it isn't the long term goal, etc) On Fri, Aug 29, 2014 at 7:23 AM, Urgen Sherpa <[email protected]> wrote: > Greetings! > I am new to ansible and im trying to install mysql-server below is my > playbook [im in a vmware10 using two centos 6.5 x64 machines one as > ansible-Node and another as client] > > --- > - hosts: webservers > gather_facts: False > - name: install apache > yum: name=httpd state=latest > > * - name: install mysql yum: name=mysql-server state=installed * > > * - name: Install MySQL-python yum: name=MySQL-python > state=installed* > > > * - name: Ensure MySQL is running service: name=mysqld state=started > enabled=true* > > the installation goes fine, but when i go to client node and try to do > mysql_secure_installation , even though i havent set any password , it > shows access denied / password incorrect > [root@monitor1 ~]# service mysqld restart > Starting mysqld: [ OK ] > [root@monitor1 ~]# mysql_secure_installation > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: NO) > > Please help > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ansible-project/585f5db7-0a84-458d-a728-2e988640e5a0%40googlegroups.com > <https://groups.google.com/d/msgid/ansible-project/585f5db7-0a84-458d-a728-2e988640e5a0%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CA%2BnsWgwCsoWyppJ8EzWTTJ77AfZeiVeZxfovUr95RUU02Kw6Yw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
