Timeline for Ansible: How to change MySQL server root password by reprovisioning the server
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 3, 2020 at 12:54 | comment | added | Palantir | I got it. On Ubuntu 20.04 and MariaDb, you need to add: "login_unix_socket: '/var/run/mysqld/mysqld.sock'" to each call to mysql_* modules. | |
| Aug 1, 2020 at 14:36 | comment | added | Palantir | Anyone figured this out? The playbook worked fine with 18.04, but for MariaDB on Ubuntu 20.04 it fails. | |
| Jun 29, 2020 at 12:47 | comment | added | Loenix | This solution is no more working with Ubuntu 20.04 | |
| Sep 26, 2018 at 21:23 | comment | added | hlovdal |
List all root users: mysql --database mysql --execute "select host from user where user = 'root';". This post does the same as this answer but has code for setting all passwords.
|
|
| Jun 9, 2017 at 21:57 | comment | added | robo | This is handy, but on many systems there are actually 4 'root' users created, with Hosts 127.0.0.1, localhost, ::1, and whatever the local hostname is. The above only modifies root@localhost, leaving three other root accounts with blank passwords. | |
| Apr 27, 2016 at 18:47 | comment | added | ydaetskcoR | I quite like this approach and it's much better than the version in my answer. It should probably be the accepted answer. | |
| Apr 27, 2016 at 16:21 | review | First posts | |||
| Apr 27, 2016 at 17:41 | |||||
| Apr 27, 2016 at 16:20 | history | answered | Markus | CC BY-SA 3.0 |