HeidiSQL portable: MySQL GUI client for Windows, to remote MySQL hosts.

1
Download it.

http://www.heidisql.com/download.php
http://heidisql.googlecode.com/files/HeidiSQL_7.0_Portable.zip

"heidisql portable"
[12:24:15 PM] leeubill: mysql lightweight client for Windows.
[12:24:23 PM] leeubill: use it to remote connect to mysql database.
[12:24:30 PM] leeubill: got GUI ^^

2 ENABLE REMOTE ACCESS
On your Debian6, enable remote access to your MySQL service;
Restart the service.
(Note: on my Debian6, this had already been enabled.)
Ref: for old version of mysql config file, this:
http://www.debianhelp.co.uk/remotemysql.htm

Google searchstrings:

• how to remote access mysql server
• how to enable serving out mysql?

3 IN YOUR MYSQL, GIVE THE USER REMOTE ACCESS PRIVILEGES
- to find out your FULL username, use the heidisql to connect to that IP, using arbitrary username and password. It will fail, and it will show the FULL USERNAME that was generated for your user on your PC.

4
For that username, enter your mysql server using this command line:

Ref: http://www.ghacks.net/2009/12/27/allow-remote-connections-to-your-mysql-server/
mysql -u root -p

GRANT ALL PRIVILEGES ON *.* TO username@address IDENTIFIED BY “password”;

Here put username @ address to be those that you got from HeidiSQL's error message.

More Ref and Explanation:
http://richbui.com/2009/03/06/how-to-enable-remote-access-to-mysql-server-on-windows-server/

Enter in

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';

What this will do is create a new user with ROOT privileges, so be very careful what account you are creating. If you are just using the root account, then replace USERNAME with root. And just so we are clear, USERNAME is the account you wish to create or use. IP is the physical IP address of the computer you wish to grant remote access to. If you enter ‘%’ instead of an IP number, that user will be able to remote access the MySQL server from any computer. PASSWORD is the password you wish to create if it’s a new user or the existing password of an existing account. And yes, you need to use the single quotation.

And finally, you want to run this last command:

mysql> FLUSH PRIVILEGES;

To exit, just type:

mysql> quit;

http://wiki.gandi.net/en/hosting/using-linux/tutorials/ubuntu/remote-mysql