Discover Centmin Mod today
Register Now

[Guide] How to access your MYSQL databases using HeidiSQL instead of phpMyAdmin

Discussion in 'Centmin Mod User Tutorials & Guides' started by ljseals, May 25, 2017.

  1. ljseals

    ljseals Member

    88
    22
    8
    Dec 20, 2016
    Ratings:
    +43
    Local Time:
    4:17 AM
    HeidiSQL is a free and open-sourced tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers. ..

    I find it easier to use this program instead of phpMyAdmin because of both the remote access and the availability of simply opening the program and having the setting saved. However, as a newb it took me a while to set the program to connect to the remote database. Since it is also remotely connected it seems that it may be safer than phpMyadmin. At any rate..

    Download and install HeidiSQL
    https://www.heidisql.com/download.php?download=installer

    Download and install Plink

    https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html
    32 bit version https://the.earth.li/~sgtatham/putty/latest/w32/plink.exe
    64 bit version https://the.earth.li/~sgtatham/putty/latest/w64/plink.exe

    Once downloaded and installed note the location the you installed or placed plink. I put it at C:\plink.exe.

    Open HeidiSQL and click File then click Session Manager. Then click New.
    [​IMG]

    For Network Type:
    Select "MySQL (SSH tunnel)"
    For Hostname / IP: Enter "127.0.0.1"
    User: Enter "root"
    For password : Enter "Mysql Root Password"
    Port: "3306"
    If you do not know your mysql root password you can find it by entering this command.
    Code (Text):
    nano /root/.my.cnf


    Next click on SSH Tunnel Tab near the settings tab.
    [​IMG]

    For plink.exe location:
    "the location you place plink.exe earlier" Ex. C:\plink.exe
    SSH host + port: "Enter you ip address and your port number"
    Username: "root"
    Password: "root password"
    Local Port: "3307"

    Click Save and at this point you should be able to connect to your mysql database. God bless you!
     
    Last edited: May 25, 2017
    • Like Like x 2
    • Useful Useful x 1
  2. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    7:17 PM
    Nginx 1.13.x
    MariaDB 5.5
    Very nice guide @ljseals (y)

    HeidiSQL is nice to use and yes remote SSHTunnel connections safer than phpmyadmin installs :)

    I'll move this guide to user tutorials forum :)
     
    • Like Like x 1