Downloading and Installing Heidi SQL

Recently, John and I have been doing a lot of database work using MySQL and have had to connect to several large databases and manage them correctly. This can be a daunting task without a tool to easily do so. This is where Heidi SQL comes in. This tutorial will walk you through downloading, installing, and configuring Heidi SQL to use against your MySQL databases.

Let’s begin by going to Heidi’s download page and downloading the installer.

installing_heidi_sql_01

Once the site loads, you will see the link to download the installer as shown above. Click on that link and save the file somewhere on your computer so that you can install it.

installing_heidi_sql_02

This is what the downloaded installer should look like. Double-click on it to start the installation process.

installing_heidi_sql_03

This is the welcome screen. Click on Next.

installing_heidi_sql_04

Read the agreement and check the radial button to accept the terms and then click on next. Click on Next.

installing_heidi_sql_05

This is where to install the files for the application. Leave this default if you are unsure of where to put them. Click on Next.

installing_heidi_sql_06

This is where you can pick what it names the start folder in the Start Menu where the application shortcuts will be located. Click on Next.

installing_heidi_sql_07

This screen will allow you to select the additional options you would like such as desktop and quick launch icons. Click on Next.

installing_heidi_sql_08

This is the final screen before installation will occur. Review the settings and ensure they are all correct. Click on next to start the installation.

installing_heidi_sql_09

You will see the above screen while the installation completes. It should only take a few seconds.

installing_heidi_sql_10

Once installation is complete, you will get the screen. Keep the box checked to launch as soon as you hit finish.

installing_heidi_sql_11

This is the connection manager. You can add several databases to the application and manage them by selecting them here. You can also enter the information for a one time connection. To create a connection that you will save, click on New at the top of the screen.

installing_heidi_sql_12

This box will pop up asking what you want to name the session. I named mine Tutorial. Click on OK to continue. It will now take you back to the main screen to fill in the options for the connection.

installing_heidi_sql_13

Fill in the fields with the information. The default port for MySQL is 3306. Once the information is all filled out, click on Save + Connect and it will connect you to the database as well as save it for the next time.
*Note: If you are unable to connect, you will need to configure your server to allow incoming connections and/or contact your host. MySQL does not allow remote connection by default and will need to be configured to do so.

installing_heidi_sql_14

This is the main window of Heidi. The left pane is the server you are connected to as well as the databases it contains. The pane on the right it the information pane that will change based on what you have selected on the left. It will allow you to browse the data, view the settings, and write queries to run against the databases. The bottom pane is the log pane and it will show you what the application is currently during.

That concludes this tutorial. Heidi is a powerful tool with everything you need to manage, manipulate, and update your MySQL database. Play around with it and get used to it and you won’t regret it. Thanks for reading.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join the TeamTutorials mailing list and get the latest tips, tricks, and special discounts for members only.

Thanks! Please click the link in the email we just sent you to confirm.