Posted by:
c2dan
(---.15-1.cable.virginmedia.com)
MySQL Workbench needs to be configured. It is not a wamp issue.
Here is how I configured MySQL Wordbench version 5.2.16.
Download and install MySQL Workbench. Once installed Start MySQL Workbench and make sure WAMP is running.
Once started got to the Server Administration section (right hand side of the window). Click New Service Instance.
For the Specify Host Machine and Database Connection screens just click next. On the Test DB Connection screen the wizard will prompt for the password for your root user, enter the password if you have set one up. If you have not set a password leave the password field blank.
Upon successful login the wizard should correctly identify the Server version and what OS mysql is running on.
Click Next to go the Operating System screen. For the MySQL Installation Type choose
Windows (MySQL x86 zip Package
Click Next. The wizard will now attempt to find the mysql configuration file. You will see an error. Ignore the error we'll fix this next. Click the Next button and we'll be taken to the MySQL Config File screen. For the Path to Configuration File set it to
C:\wamp\bin\mysql\mysql5.1.36\my.ini
NOTE: mysql1.5.36 may differ to your mysql version. I'm using wamp 2.0i which comes with 5.1.36
Click the Test button underneath to see if the path is correct. It should turn green. If you see an error you'll need to manually find the my.ini file in C:\wamp\bin\mysql
For the Server Instance change it to
wampmysqld
Click Next. In the three input boxes change where it says mysql to
wampmysqld.
Click Next. And finally click FInish. MySQL Wordbench is now configured correctly to work with mysql that comes with WAMP.
Double click the new server instance under the Server Administration section to connect to MySQL.