Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

SQL error on tbale lock check

croshad's profile image croshad posted 1 year ago in General Permalink

So i'm running a local environment with Laragon and after creating and saving the initial session and connecting to the db, every subsequent connection attempt using that saved session results in a SQL syntax error pointing to the line "SHOW OPEN TABLES FROM DATABASE WHERE in_use!=0;". I then have to delete the session and create a new one and it works again until next time it checks for table locks. I figured out it's because the database isn't in backticks. I am using the latest MySQL 8.0.15, it works fine in version 5 and i tried different db names just in case. I thought backticks weren't needed when it's a normal non reserved db name but i don't know anymore. Is there a way to make Heidi always add backticks to db names ?


croshad's profile image croshad posted 1 year ago Permalink

Sorry for the title typo.

Please login to leave a reply, or register at first.