Connecting to MYSQL through HeidiSQL
-
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.
-
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.
-
I have the same problem here
-
On my.ini, please add show_compatibility_56=on
Suggestion from @kaxias
Ref: https://forum.laragon.org/topic/220/mysql-ini-tpl
-
nice it's worked
thanks
-
@leokhoa if I could upvote you 10 more times I would. TY!
-
-
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.
-
tried all the solutions here and none worked for me...