I just discovered HeidiSQL today and am still learning MySQL so I may have made a simple mistake. Anyway I installed the app and wanted to use the command line function to follow along in the textbook I'm using but I don't see the option listed in the menu. The text below from this site says that I can change where Heidi looks for the mysql.exe file, but I don't see anything in the Misc tab either.
"After having established a MySQL or MariaDB connection, HeidiSQL offers to launch a command line window (located in the "Tools" menu). This executes mysql.exe from the directory which is set in Tools > Preferences > Miscellaneous."
There is nothing pertinant to what I'm looking for in that tab. I installed HeidiSQL and then MySQL workbench (which appears to have the command line)
Command Line option missing? 7.0.0.4053
I did check for updates and am currently running the latest version.
It's saying that in order to launch mysql.exe shell I need to tell HeidiSQL the path to MySQL command line bianaries. Since I do not have a filename running a search will be near impossible. I've tried a general search of .bin files but I still have no idea which files I'm looking for.
It's saying that in order to launch mysql.exe shell I need to tell HeidiSQL the path to MySQL command line bianaries. Since I do not have a filename running a search will be near impossible. I've tried a general search of .bin files but I still have no idea which files I'm looking for.
Ok. Do you have installed the MySQL server locally (ie on this same windows), or on another (eg unix) machine ? If installed locally, mysql.exe should be in the server installation´s bin\ directory.
If not, download the 5.5.25 windows server MSI installer package (x86 64bit) from mysql or mariadb, and temporarily install it. Copy from its bin\ directory mysql.exe, then uninstall the server again.
Also, copy the libmysql.dll found in the Heidisql installation directory to where you put mysql.exe.
That should do it.
If not, download the 5.5.25 windows server MSI installer package (x86 64bit) from mysql or mariadb, and temporarily install it. Copy from its bin\ directory mysql.exe, then uninstall the server again.
Also, copy the libmysql.dll found in the Heidisql installation directory to where you put mysql.exe.
That should do it.
Please login to leave a reply, or register at first.