How to connect My SQL database Using Heidi SQL Tool

HeidiSQL connectivity tool

In this article, i am going to explain how to connect My SQL database using Heidi SQL Tool. Before connecting, my sql server and Heidi SQL tool needs to be installed.

Procedure to connect My SQL database Using Heidi SQL Tool

  1. Download Heidi SQL tool from here.
  2. after downloading install the Heidi SQL tool by double clicking on it.
  3. click on next button.

Heidi SQL setup

4. Accept the license agreement and click on next button.

Heidi SQL setup

5. click on next button.

Heidi SQL setup

6. click on next button.

Heidi SQL setup

7. click on next button.

Heidi SQL setup

8. click on install button.

9. click on finish button.

Heidi SQL setup

10. then launch the Heidi SQL, click on new option, to create a new session.

Heidi SQL setup

11. then provide the details below in specific fields as shown

  •  Network type as : My SQL (TCP/IP), because we are connecting my sql server.
  • Host name/IP as: 127.0.0.1
  • Default user as : root
  • Password as      : **********  (note: My SQL Server  Password)
  • Port number as: 3306  (note: the default port number value for My SQL Server)

Heidi SQL setup

12. after that click on open button, to connect to the My SQL server database using Heidi SQL tool.

Heidi SQL setup

i hope you guys understand how to connect My SQL server database using Heidi SQL tool. If you like this article, feel free to share with others. If you’ve got anything to say or discuss with me just leave a comment below.

Hi, this is kumar, Founder & Chief Editor of www.alltechmedhas.com, working as Senior Software Engineer in QA Automation Process, Robotic Process Automation Developer. I have total experience of little more than 6 years. I have worked on variety of test automation projects and development projects.

3 thoughts on “How to connect My SQL database Using Heidi SQL Tool”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.