search

gchq / stroom-ansible

A home for all stroom related ansible playbooks, roles, etc.
Apache License 2.0
4 stars 6 forks source link

non-docker mysql setup initial password #22

Open arterialplan opened 3 years ago

arterialplan commented 3 years ago

This is for dw-v7 branch The ansible scripts as they are set install mysql with temporary instead of blank passwords, the task "Update mysql root password for localhost" does not cater for this. I got around it by doing 

grep temporary /var/log/mysql*
mysql --socket /var/run/mysqld/mysql-stats.sock --password <temp stats root password>
ALTER USER 'root'@'localhost' identified by 'xxx';
exit
mysql --socket /var/run/mysqld/mysql-stroom.sock --password <temp stroom root password>
ALTER USER 'root'@'localhost' identified by 'xxx';
exit