"Database connection unavailable" during installation script "install/update database schema"

[coryjfowler]

I installed a fresh Debian installation yesterday and followed the instructions for FOG found here today.

I get to the point where the installation script informs me that I need to install/update the database schema, but I am met with the “Database connection unavailable” message on my web browser when I navigate to the link provided.

The mysql troubleshooting page leads me to believe the fog database does not exist, but does not appear to mention what my next step should be…

#uname -a
Linux fogtest 4.9.0-7-amd64 #1 SMP Debian 4.9.110-3+deb9u2 (2018-08-13) x86_64 GNU/Linux

[george1421]

@coryjfowler Well lets start with:

1. Is mysql running?
   ps aux|grep mysql
2. can you log into the mysql client using
   mysql -u root -p and then press enter at the password prompt?

[matijn]

You have to set a (very strong) mysql password first, topic:

https://forums.fogproject.org/topic/12445/please-help-ubuntu-updates-screwed-up-my-mysql-root-password/7