Configuring mysql Server and mysql connector

Tools we are going to use are:
Visual Foxpro (ver 6.0 up)
mysql server-5.0.x - download mysql server-5.0.81-win32.msi
mysql connector 5.1 - download mysql connector 5.1
mysql tools for 5.0(Administrator)- download mysql toos for 5.0

● Configuring mysql server

click standard configuration




root password: inv
confirm : inv




click execute

note: if the service is not successfully installed. you need to re-configure it again. otherwise you will not be able to access the mysql server

● Run mysql connector windows installer package
after installation go to control panel->administrative tools->data sources(ODBC)

under user dsn click add. select mysql connector 5.1 server


next screen

data source name: inventory
server: your computer name
(in my case i use rca)
user: inv
password: inv
database: leave blank
if you have already created a database select from the drop down list.
click ok

● run mysql tools for 5.0 installer and follow installation process