Connecting to MYSQL through HeidiSQL


  • | 955 points

    I am getting error when I am trying to connect to the MYSQL in Laragon through HeidiSQL.

    SQL Error (1146):
    Table 'performance_schema.session_status' doesn't exist
    

    Does anyone know the proper steps to connect HeidiSQL with the MYSQL in Laragon?

    Thanks.


  • | 840 points

    I use WebYog, but I downloaded the portable version of Heidi and was able to connect without any problem. I took a look at the performance_schema database and I don't see a "session_status" table (not sure where you are defining session_status - but that could be your problem).

    Steps I used :

    • Downloded HeidiSQL portable.
    • Extracted to a folder, ran executable.
    • Pressed the "New Session" button.
    • Provided MySql username/password for connection.
    • Pressed the "Open" button.

    Connected, no issue.

    EDIT : session tables available in performance schema db.
    0_1473788167424_upload-bb2da29a-4d8b-48bd-b4b8-a6db6456f055


  • | 12 points

    I have the same problem here


  • administrators
    | 46775 points

    On my.ini, please add show_compatibility_56=on
    Suggestion from @kaxias
    Ref: https://forum.laragon.org/topic/220/mysql-ini-tpl


  • | 12 points

    nice it's worked
    thanks


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.