CentOS 7: Fails: Disallow root login remotely.

[fubarhouse]

I keep coming across this error on your CentOS7 image, I can't speak for any others right now.

config.vm.box = "geerlingguy/centos7"

TASK [geerlingguy.mysql : Disallow root login remotely] ************************
failed: [localhost] (item=DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')) => {"changed": false, "cmd": ["mysql", "-NBe", "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')"], "delta": "0:00:00.074163", "end": "2016-12-12 09:59:40.229321", "failed": true, "item": "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')", "rc": 1, "start": "2016-12-12 09:59:40.155158", "stderr": "ERROR 1142 (42000) at line 1: DELETE command denied to user 'root'@'localhost' for table 'user'", "stdout": "", "stdout_lines": [], "warnings": []}

- hosts: localhost
  roles:
  - role: geerlingguy.mysql
    become: yes

[geerlingguy]

Closing in favor of #57 — I hope we can consolidate all these connection issues there. Some of the quick possibilities:

• MySQL isn't actually running
• MySQL is running on a socket instead of a port (or vice-versa)
• This isn't the first time the playbook is being run on the server (sometimes that can make things weird).

[fubarhouse]

I'm not surprised, but I am thankful that you're on top of it.

Thanking you kindly Jeff!