My Blog

HeidiSQL on cloud

1-click AWS Deployment    1-click Azure Deployment  1-click Google Deployment



Overview

HeidiSQL is a database query tool that supports MySQL, Microsoft SQL Server and PostgreSQL databases. It allows you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Features include managing multiple servers from one window, exporting from one database server into another, bulk editing, an advanced SQL syntax editor, and database optimization and repair functions.

HeidiSQL on Cloud runs on Amazon Web Services (AWS) and Azure and is reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL.

HeidiSQL is owned by HeidiSQL (https://www.heidisql.com/) and they own all related trademarks and IP rights for this software.

Cognosys provides hardened images of HeidiSQL on all public cloud i.e. AWS marketplace and Azure.

HeidiSQL on Cloud For AWS

Features

Major Features Of HeidiSQL

  • Free for everyone, OpenSource since 9 years of active development.
  • Connect to multiple servers in one window
  • Connect via SSH tunnel, or pass SSL settings
  • Create and edit tables, views, stored routines, triggers and scheduled events.
  • Export from one server/database directly to another server/database
  • Manage user-privileges
  • Import text-files
  • Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
  • Browse and edit table-data using a comfortable grid
  • Bulk edit tables (move to db, change engine, collation etc.)
  • Batch-insert ascii or binary files into tables
  • Write queries with customizable syntax-highlighting and code-completion
  • Pretty reformat disordered SQL
  • Monitor and kill client-processes
  • Find specific text in all tables of all databases of one server
  • Optimize and repair tables in a batch manner
  • Launch a parallel mysql.exe command line window using your current connection settings

AWS

Installation Instructions For Windows

Note: How to find PublicDNS in AWS

Step 1) RDP  Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows  instance on AWS Cloud

1) Connect to the virtual machine using following RDP credentials:

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password: Please Click here to know how to get password .

Step 2) Click the Windows “Start” button and select “All Programs” and then point to HeidiSQL

Step 3) Other Information:

1.Default installation path: will be in your root folder “C:\program files\HeidiSQL”

2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

Installation Step by Step Screenshots


Google

Installation Instructions For Windows

Installation Instructions for Windows

Step 1) VM Creation:

  1. Click the Launch on Compute Engine button to choose the hardware and network settings.
  2. You can see at this page, an overview of Cognosys Image as well as estimated cost of running the instance.
  3. In the settings page, you can choose the number of CPUs and amount of RAM, the disk size and type etc.

Step 2) RDP Connection: To initialize the DB Server connect to the deployed instance, Please follow Instructions to Connect to Windows instance on Google Cloud

Step 3) Database Login Details:

The below screen appears after successful deployment of the image.

successful deployment of the image

For local MySQL root password, please use the temporary password generated automatically during image creation as shown above.

i) Please connect to Remote Desktop as given in step 2 to ensure stack is properly configured and DB is initialized.
ii) You can use MySQL server instance as localhost, username root and password as shown above.

If you have closed the deployment page you can also get the MySQL root password from VM Details  “Custom metadata” Section.

Step 4) Click the Windows “Start” button and select “All Programs” and then point to HeidiSQL

Step 5) Other Information:

1.Default installation path: will be in your root folder “C:\program files\HeidiSQL”

2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

Videos

HeidiSQL on cloud

Related Posts