Connection To MySQL

jcoleuk · Post by **jcoleuk** » Sat Jan 21, 2006 4:41 pm

How can I use PureB to connect to a local MySQL database on my Windows machine.

Thanks,
Josh.

josku_x · Post by **josku_x** » Sat Jan 21, 2006 5:08 pm

Do you have MySQL and PHP installed on your machine?
And if yes, which versions?

Flype · Post by **Flype** » Sat Jan 21, 2006 5:09 pm

hello, i made this daily. it's quite easy.

1/ Download on the mysql website the 'ODBC MySQL Connector for Windows 2000/XP', and install it.

2/ Be sure you have opened the MySQL TCP Port 3306 on your firewall(s).

3/ Execute the native configuration ODBC software 'odbcad32.exe' provided by Windows.

4/ Create a new system file, specifying a connection name, user, pwd, ...

5/ Use OpenDatabase(0,'odbcname','odbcuser','odbcpwd').

jcoleuk · Post by **jcoleuk** » Sat Jan 28, 2006 12:16 pm

Thanks for the reply.

I'm still having problems, I tried to add an SQL server connection to the ODBC config software but it won't connect to the MySQL server...

I disabled my firewall and still it wouldn't work, it doesn't show up in the Select Server menu so I just put in "(local)" like the help file says.

I really need some help with this.

Thanks,
Josh.