Eisbärs Eisberg

I tried to install the MySQL-ODBC driver under windows, but it diden’t appear in the list for new connections. This trick by Harun Eren that I’ve found on http://bugs.mysql.com/bug.php?id=5678 helped:

[2 Nov 2004 21:43] Harun Eren
The following steps can be use as background for the bug:
 --------------------------------------------------------
 1.Call "regedit" programm under WindowsXP
 2.The registry structur [HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers] must export to the .reg file.
 3.After then deleted the structur [HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers] in the registry.
 4.Edit the exported .reg file, with deleted following line  >>> @="" <<<,
 5.Save the .reg file
 6.Import the .reg file with the registry programm or call the .reg file to be save the Driverskey

After these steps the drivers are listed correctly in the Microsoft Driver Manager.

MySQL needs to grant permission for the user on the remote hosts. So on the mySQL-prompt one needs to enter something like:

GRANT ALL ON databsename.* TO username@’host-ip’ IDENTIFIED BY ‘PASSWORD’;