You can't.
HSQL is NOT a database server, it is a local fileset that can appear to be a database if you have the right drivers. It doesn't offer itself up like other servers, although a lot of tools will allow you to connect to it LOCALLY, and there are tools around to make it available remotely.
Think of it this way - with Oracle, MySQL, PostGreSQL, Microsoft SQL Server and the others, there is a process running on the database server that you connect to because the process is built to respond to remote accesses over a network. With HSQL, there's just some files on a disk.
Note, this is only a dev/test server anyway, so I'm not sure why you're trying to access the database this way. It begs the question "Why are you looking at the database?". As there's probably a much better way to do what you need to do.
I encountered two problems. First, Now embedded HSQL is used in production,i want to migrate to other database such as MySql. Second, I can't login confluence with admin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, you've asked this twice in two different ways. Let's stick to one thread over at https://answers.atlassian.com/questions/11443010/i-can-not-log-in-with-admin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.