So, the mysql-fix postet by Tom Elliot helped. No need to rerun the fog installer.
@tom-elliott said in Ubuntu is FOG’s enemy:
TLDR; … or run the ALTER USER syntax shown below.
As a note, it seems this problem is specific only when the mysql account is the 'root' user AND the password is blank.
The “fix” if you must do it manually is to open a terminal and obtain root:
Super (Windows Key) + T then sudo -i (in most cases).
From there, open mysql with mysql -u root
NOTE: MySQL MUST be run with ROOT.
Run:
ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY ''; AND
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
It’s okay if one of them fails. This is going to fix Most people’s issues.
I would highly recommend removing the unattended-upgrades as many of these “sudden” issues came as a security patch ubuntu pushed out. By default Ubuntu typically set’s this for you as enabled and it can cause havoc on you as you (the admin) may not have “done” anything.
To prevent this problem from happening in the future you could run:
apt-get -y remove unattended-upgrades (AS Root again).