gh0st
commented
2 years ago I find I'm running into the same issue. Originally maybe it seemed as though a mysql install left the root password empty as ''. Or perhaps that the install was not performed with some package manager like yum for example on RHEL. But using yum on RHEL7 to install mysql from the rpm files it does as @jgainey describes. The default installation password is written to /var/log/mysqld.log. I can scrape that and write it to a var in ansible but this still doesn't seem to yield results and fails. I've tested this and found it true for mysql 5.7 and 8.0.
stale[bot]
jgainey
github-actions[bot]
kedare
I'm trying to install mysql5.7 from the community repo. everything seems to go fine until it tries to access the mysql database with the mysql command line client
TASK [mysql : Disallow root login remotely] ***** failed: [css-mfgweb1-t7.cookgroup.nao] (item=DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')) => {"ansible_loop_var": "item", "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.012698", "end": "2022-03-18 13:32:49.616623", "item": "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')", "msg": "non-zero return code", "rc": 1, "start": "2022-03-18 13:32:49.603925", "stderr": "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)", "stderr_lines": ["ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"], "stdout": "", "stdout_lines": []}
i looked through the code it seems like it should need to:
here's the snippet from the log with the randomly generated temporary password:
2022-03-18T17:32:45.659519Z 1 [Note] A temporary password is generated for root@localhost: 0,h0pQfs7J8l
i'm not familiar with new versions of mysql and whether this is the same or not.