Help with Heidi Use

lukinhaspm's profile image lukinhaspm posted 1 month ago in General Permalink

I'm migrating hosting, and today I have about 15 MariaDB databases, and that number should grow soon.

The problem is that with the new hosting, they require creating a user per database (the server and port are the same).

What would be the best way to handle this in Heidi? Will I really have to create one connection for each database and open them one by one every time if I want to do a comparison?

I'm quite discouraged by this, am almost asking for my money back!

ansgar's profile image ansgar posted 1 month ago Permalink

If you need different user/password combinations you need one session for each of them.

Once you have created these connections, you can open more than one in the main window. You could even enable the checkbox Tools > Preferences > General > "Automatically reconnect to previous sessions" . That way you only have to connect to all of them once and then just close HeidiSQL. When you start HeidiSQL, it should auto-connect to the previously open sessions again.

I'm afraid if the connections need SSH tunneling, the connection process for 15 or more connections will take a significant amount of seconds or minutes.

lukinhaspm's profile image lukinhaspm posted 1 month ago Permalink

Thank you! I will try

Please login to leave a reply, or register at first.