I want to explicitly document changing the password for root for MySQL without needing to re-run the installer as the Wiki suggests.
mysql_secure_installation
Enter current password for root: <enter>
Set root password? y
New password: <new password>
Remove anonymous users? y
Disallow root login remotely? y
Remove test database and access to it? y
Reload privilege tables now? y
Then we need to change everywhere FOG references the old password without rerunning the installer.
sed -i.bak "s|snmysqlpass='<oldpassword>'|snmysqlpass='<newpassword>'|g" /opt/fog/.fogsettings
sed -i.bak "s|DATABASE_PASSWORD', \"<oldpassword>\"|DATABASE_PASSWORD', \"<newpassword>\"|g" /var/www/html/fog/lib/fog/config.class.php
reboot
I’m working on that second sed command’s escape sequence just now. EDIT - completed
Is there anywhere else that needs to be changed? The purpose of this is to avoid re-running the installer just for the sake of a changed MySQL password.