encryption

What's the best way to encrypt entire DB's using HeidiSQL?

You can encrypt column by column, e.g. by inserting row values with a ENCODE('string value', 'secretpassword'), but that requires you to DECODE() all these values at runtime.

You should not do that. Instead, make the database readable only for specific users. Set up other users so that they cannot select something from that db. And use a cryptic, long password for users which can access that db.

the DB is readable my the programs that are on there, IE Wordpress, Hmailserver, but in case someone does pull the files I need to encrypt them.

The column by column seems a laborious process any solution to encrypt all of it?

No, not that I knew of, at least not via SQL. You can of course encrypt the files on the servers filesystem with some external application.

in case someone does pull the files

Hell, you should of course take care nobody is able to do that. The server files should be privileged to some specific user + MySQL itself, nothing more. If you do so, nobody should be able to steal or delete your data.

so like truecrypt or axcrypt?

i just don't want to make the files unreadable by mysql software itself.