Create LINKED SERVER to MYSQL using SSH
HeidiSQL or DBeaver manage the SSH connection and not ODBC. You'll need to create your SSH connection with a port forward first.
Then test if you can connect a mysql client to the local ssh forwarded port.
Then attempt to create your linked server using ODBC to local end of the ssh forwarded port.