Connecting to MYSQL through HeidiSQL

[DarkSpirit]

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.

[landjea]

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.

[rasyidstat]

I have the same problem here

[leokhoa]

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

[rasyidstat]

nice it's worked
thanks

[RhRU]

@leokhoa if I could upvote you 10 more times I would. TY!

[leokhoa]

@RhRU: Nice! I got it from @kaxias

[Tomas Gonzalez Mendivelzua]

Just happened to fix this problem with the help of Stack Overflow.

I ran this command:

# windos terminal, mysql bin folder
mysql_upgrade -u root -p --force

Then completely stopped Laragon and started it again.

- Reference Here -