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.

mysql binaries location

samhill5215's profile image samhill5215 posted 2 months ago in General Permalink

I'm trying to setup the Heidi command line programs. Has anyone succeeded in defining this location when MySQL resides on a Linux server? In preferences Heidi is looking for mysql.exe which of course is meaningless under Linux.I suspect this works on a Windows machine only.

ansgar's profile image ansgar posted 1 month ago Permalink

That path setting in HeidiSQL is used for starting a MySQL prompt, using "mysql(.exe)". This is of course the client of MySQL, but there must be a path where that binary resides. Probably the client is seperately installed from the server. Did you already try whereis mysql or similar?

A second feature where that path setting is used is the SQL export window, where you can copy a mysqldump command line for the current settings.

samhill5215's profile image samhill5215 posted 1 month ago Permalink

The connection to MySQL for Heidi is via plink and SSH. I connect to MySQL from windows via SSH only. I know where my binaries are but entering their Linux path in preferences seems nonsensical. In any case it doesn't work.

Perhaps if I knew the command to launch the command line I might be able to figure out how to make it work. It's really not critical. I can issue the same SQL statements in Heidi as I would in the client. I'm just curious.

ansgar's profile image ansgar posted 1 month ago Permalink

Ah I see, then this is just a misunderstanding. You enter the path to your local MySQL/Windows binaries, which you downloaded from mysql.com or mariadb.com:

Description

Only the SSH tunnel could make the mysql.exe process not to connect, as the tunnel is not created separately for the prompt.

samhill5215's profile image samhill5215 posted 1 month ago Permalink

Got it. I kind of thought it's this way. I thought I was being clear in my original message but who knows? Maybe not. We can always do better. Thanks Ansgar.

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




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.