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?
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
nice it's worked
@leokhoa if I could upvote you 10 more times I would. TY!
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.