SOLVED Database connection unavailable when first installing fog server
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?
@Sebastian-Roth It works!!! Thank you.
@weidongyan As I said in the post before: When logging into the mysql/mariadb command line just hit ENTER for an empty password.
@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)
@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
mysql>are just meant to show you at which command line interface you are. Don’t type those.
@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.
And I set up mysql password while installing fog server
This is image that I took.