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?


  • | 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.

  • | 12 points

    I have the same problem here

  • administrators
    | 56177 points

    On my.ini, please add show_compatibility_56=on
    Suggestion from @kaxias

  • | 12 points

    nice it's worked

Log in to reply

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