Hi, though I have installed Flarum before with some shared hosting with SSH access, now I am having some difficulties while trying to install it in Google Cloud. I want to install Flarum in compute engine. So I created a Debian based VM in Compute Engine, configured SSH, installed Flarum. It gave some error of directory permissions which I resolved using the chmod commands. At last somehow the default Flarum installation form appeared.
But Flarum requires a created database. So I navigated to Cloud SQL in Google Cloud Console and created a MySQL database instance and set a root password for that. There I created a database in that instance. Then when I tried to fill the Flarum installation form using that database as a root user, it gave me a error of "Something went wrong: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)". I even tried creating another user or even replacing the DB Host with database's ip address with no luck.
I am fairly new in web technology and very beginner in cloud computing. So if someone can help me, please explain your point descriptively because I don't have any prior knowledge about these aspects. I am wondering is there anything I'm missing and would be utterly thankful to anyone who could help.