HOW TO INSTALL HEIDISQL

DOWNLOAD AND INSTALL MARIADB

1

DOWNLOAD MARIADB

• VISIT THE OFFICIAL MARIADB WEBSITE

• SELECT YOUR OPERATING SYSTEM (WINDOWS, LINUX, MACOS)

• DOWNLOAD THE RECOMMENDED STABLE VERSION

2

RUN THE INSTALLER

• OPEN THE DOWNLOADED FILE AND START THE INSTALLATION PROCESS

• ACCEPT THE TERMS AND CONDITIONS

3

CONFIGURATION DURING INSTALLATION

• SELECT COMPONENTS: ENSURE "MARIADB SERVER" AND "COMMAND LINE TOOLS" ARE SELECTED

• USER SETUP: SET A PASSWORD FOR THE ROOT USER (ADMINISTRATOR). SAVE THIS PASSWORD SECURELY

• CONNECTION PORT: DEFAULT PORT IS 3306. KEEP UNLESS ANOTHER SERVICE USES IT

4

COMPLETE THE INSTALLATION

• FOLLOW THE INSTALLER’S INSTRUCTIONS TO FINISH THE SETUP

• MARIADB WILL BE INSTALLED AS A SERVICE AND START AUTOMATICALLY

---

DOWNLOAD AND INSTALL HEIDISQL

1

DOWNLOAD HEIDISQL

• VISIT THE OFFICIAL HEIDISQL WEBSITE

• DOWNLOAD THE LATEST VERSION FOR WINDOWS

2

RUN THE INSTALLER

• OPEN THE DOWNLOADED FILE AND START THE INSTALLATION PROCESS.

• FOLLOW STANDARD STEPS (ACCEPT TERMS, CHOOSE FOLDER, ETC.)

3

SET UP A CONNECTION IN HEIDISQL

• OPEN HEIDISQL AFTER INSTALLATION

• CLICK "NEW" TO CREATE A NEW CONNECTION

FILL IN THE FIELDS AS FOLLOW

• NETWORK TYPE: MYSQL (TCP/IP)

• HOSTNAME/IP: LOCALHOST (OR YOUR SERVER'S IP)

• USER: ROOT

• PASSWORD: USE THE PASSWORD SET DURING MARIADB INSTALLATION

• PORT: 3306 (OR CONFIGURED PORT)

• CLICK "SAVE" AND THEN "OPEN" TO CONNECT.

---

IF YOU HAVEN’T DONE IT YET, HERE IS A SHORT INSTALLATION GUIDE FOR MARIADB AND HEIDISQL