This issue, in my opinion, has been resolved in this thread : https://fusionauth.io/community/forum/topic/1086/how-may-i-see-the-name-of-database-created-used-by-fusionauth-in-local-mysql?_=1623774571813.

If anyone has the same issue, I hope it will be helpful. Thank you.

@robotdan Thank you @robotdan and @dan , I appreciate your time.

I have installed MySQL/J connector. Then I got an error saying : The database and schema exist, but for some reason the ordinary user you specified cannot connect to it. Perhaps the user already existed and you provided the wrong password. The error from the database was [Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.]..

This is how Maintenance Mode Database Configuration looks :

I once provided a user credentials with superuser privileges but it still did not work and got the same error. Could you please give a clue ? Thank you...

I think you missed to put FusionAuth Tenant ID.

In my case, I create a file called appConfig.json :

The file contains :

• FusionAuth URL (where you deploy your FusionAuth app such as https://login.mywebsite.com)
• FusionAuth Tenant ID
• FusionAuth App ID
• FusionAuth Client Key

Afterwards, I create a new instance of FusionAuth like this (in another file):

I pass FusionAuth Tenant ID here as a parameter.

Hence, I can fire a login function like below :

This issue, in my opinion, has been resolved in this thread : https://fusionauth.io/community/forum/topic/1086/how-may-i-see-the-name-of-database-created-used-by-fusionauth-in-local-mysql?_=1623774571813.

If anyone has the same issue, I hope it will be helpful. Thank you.

@marcasellkhelaifi My bad, after I tried, I was redirected to a page like this :

If I go to http://localhost:9011/admin, the login form shows up :

To answer my question, you do not configure database in maintenance mode once the configuration is successful.

one question, if I logout from admin dashboard and shutdown Fusionauth then I start it again with ./startup.sh, do I enter maintenance mode database configuration again ?

I would like to recap what I faced :

Steps to reproduce :

1. I downloaded Fusionauth here : https://fusionauth.io/download/.
2. I ran Fusionauth by executing fusionauth/bin/startup.sh.
3. Open http://localhost:9011 and enter maintenance mode configuration.
4. Having the superadmin credential section blank, using MySQL on port 5432, I clicked the submit button.
5. I saw an error but I did not know what happened.

My very first trouble was I did not have MySQL/J connector that bridges MySQL and its client which in this case, Fusionauth. I knew this by looking at Fusionauth logs that was present in fusionauth/logs/fusionauth-app.logs. Therefore, I downloaded it here : https://dev.mysql.com/downloads/connector/j/. Before downloading, I was required to register and login into my Oracle account.

I installed MySQL/J connector with :
sudo dpkg -i mysql-connector-java_8.0.25-1ubuntu20.04_all.deb.deb.

Still, I was not successful in running Fusionauth. This time, it was about Database. I followed this guide : https://fusionauth.io/docs/v1/tech/installation-guide/fusionauth-app/. I recommend this to anyone who forgets MySQL superadmin user password.

After that, please fill in Superuser credential section with your database superuser credentials that you have.

Finally, if you use MySQL, please make sure you run on port 3306 instead of 5432. I have no idea whether this is a must or not but it was noted in Fusionauth docs. Click submit then proceed to setup wizard to set superadmin credential. Click submit button so you will be redirected to Fusionauth admin dashboard.

You can also see MySQL to make sure you have successfully created a database named fusionauth.

Hopefully this can be helpful for anyone facing the same issue to get started to Fusionauth.

Thank you for your support @joshua , I appreciate your time!

Thank you @joshua , I will continue this thread in that post.

@robotdan Thank you @robotdan and @dan , I appreciate your time.

I have installed MySQL/J connector. Then I got an error saying : The database and schema exist, but for some reason the ordinary user you specified cannot connect to it. Perhaps the user already existed and you provided the wrong password. The error from the database was [Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.]..

This is how Maintenance Mode Database Configuration looks :

I once provided a user credentials with superuser privileges but it still did not work and got the same error. Could you please give a clue ? Thank you...

Thanks @joshua !

But if I do not have a database called fusionauth after running ./startup.sh in fusionauth/bin directory, does it mean there is something wrong ?

This is confusing because the error says : The database and schema exist, but for some reason the ordinary user you specified cannot connect to it. Perhaps the user already existed and you provided the wrong password. The error from the database was [Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.]..

Pardon me, would you mind helping this issue @dan ?... Otherwise, could you please give me a documentation link that cover this ? Thank you..

After I checked, I decided to run ``./shutdown.shand executed./start.sh`.

Next, I found this error : ERROR com.inversoft.maintenance.db.JDBCMaintenanceModeDatabaseService - No [MySQL] Driver found. The [Connector/J jar] may be missing or not be accessible.

How should I fix this ?