Access MySQL using HeidiSQL

HeidiSQL, previously known as MySQL-Front, is a free and open source client, or frontend for MySQL (and for its forks like MariaDB and Percona Server), Microsoft SQL Server and PostgreSQL. HeidiSQL is developed by German programmer Ansgar Becker and a few other contributors in Delphi. To manage databases with HeidiSQL, users must log in to a local or remote MySQL server with acceptable credentials, creating a session. Within this session users may manage MySQL Databases within the connected MySQL server, disconnecting from the server when done. Its feature set is sufficient for most common and advanced database, table and data record operations but remains in active development to move towards the full functionality expected in a MySQL Frontend.

From my previous tutorial I will show you how to access MySQL using this application. I use heidiSQL ver4.0 because it is more powerful and easy.

1. Open HeidiSQL, click 'New' give whatever name in 'Session Name' then press 'OK'. 

If you use my 'MYSQLKU' 
Hostname / IP : 127.0.0.1
User : root
Password: 123
Port: 3306.
Databases: Leave it blank.
Click 'Save+Connect'

2. Now you will see the databases and tables on your server. 

You can create new databases/ tables, assign user, change password, etc.

3.HediSQL can be downloaded for free at the official website

http://www.heidisql.com/download.php?download=installer

Tweet