Database connection unavailable when first installing fog server

[weidongyan]

Hi team, I just installed Ubuntu 18 and trying to install fog server. And the installation was getting well until these command appeared:
You still need to install/update your database schema.
This can be done by opening a web browser and going to: MyIP/fog/management
Press [Enter] key when database is updated/installed.

But when I opened my browser and entered the address, it said database connection unavailable. And I tried the method in the article.

But when I entered the mysql with root, I came to MariaDB instead of mysql. And I could not run that command because of SQL syntax( I think maybe there are some differences between MariaDB and MySQL)

So what should I do to finish installing fog server?

[weidongyan]

This is image that I took.
https://drive.google.com/file/d/1Ov4O9qw32CmGKSzV7DP7SSt_XdwolAaf/view?usp=drivesdk

[weidongyan]

And I set up mysql password while installing fog server

[Sebastian Roth]

@weidongyan Unfortunately the installer script has an issue. When you tell it to set a password for the database it will try to but fails. So it’s still running with an empty password. But in the configs it holds the password you have told it.

[Sebastian Roth]

@weidongyan Try the following commands on your FOG server/mysql/mariadb console:

shell> mysql -u root -p
Password:
...
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY "your-password";
...
mysql> FLUSH PRIVILEGES;
...
mysql> QUIT

When logging into the mysql/mariadb command line just hit ENTER for an empty password. The markers shell> and mysql> are just meant to show you at which command line interface you are. Don’t type those.

[weidongyan]

@Sebastian-Roth Hi Sebastian, when I entered “mysql -u root -p”, I entered the password and I got the error.
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

[Sebastian Roth]

@weidongyan As I said in the post before: When logging into the mysql/mariadb command line just hit ENTER for an empty password.

[weidongyan]

@Sebastian-Roth It works!!! Thank you.