Wrong user name or password on freshly installed h2 database

[Bartek]

Hello,

I'm trying to use h2 database (version 1.4.197, last stable) on Windows 10 but stumbled upon problem so simple that I'm even embarrassed about asking.

I can't log in to the database using default settings as presented:

Driver class: org.h2.Driver

JDBC URL: jdbc:h2:~/test

User Name: sa

Password: 

I've got istalled java properly, tried to reinstall H2 Database and some other things but nothing helped. Maybe reinstalling doesn't reset settings?

[Evgenij Ryazanov]

Hello.

It looks like you already have a database in the file with name test.h2.db or test.mv.db in your home directory and that database doesn't have a user with same sa and empty password. If you need this database, use the recovery tool, it should be able to restore unencrypted database without knowing its password. If you sure that you don't need it, just delete the database file.

[Evgenij Ryazanov]

You can also change the file name in JDBC URL to a different one to create a new database.