Go to: administrative tools-> ODBC-> User DSN -> Add to which you want to connect, select an option like MySql ODBC driver. Data Source name: name of db. server: localhost user: root click on test. It'll notify if the connection is established or not.
The blog will contain all the Technical knowledge I have to share and I welcome & would appreciate others for sharing their knowledge :0)