Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts

Tuesday, August 24, 2010

Connect Access Database to MySQL Database?

A company I work for has a lot of information stored in Access Databases. Ideally, we want this information on the web server so we can dynamically display tournament scores, points standings and more. So is there a way to connect a Microsoft Access database to a MySQL Database?
The answer, I found quickly, is yes.
I couldn't export the table data right away from my Access table, but after downloading the Connector/ODBC from the MySQL dev site, and following these simple instructions on the same site, I was able to connect to the MySQL server set up on my localhost with no problems.
This is exciting because now my company can use Microsoft Access as a front-end to our MySQL servers on our website.

Thursday, August 19, 2010

My life just got easier thanks to XAMPP

I decided to set up PHP5, Apache and MySQL on my localhost, so I could develop a new database-driven website completely offline. I could not seem to get these things to play together nicely. A friend recommended XAMPP, a nice little Apache distribution containing MySQL, PHP and Perl. After I removed my current MySQL instance, XAMPP worked like a charm.

Then I decided to install WordPress. Using XAMPP, I was able to easily access phpMyAdmin and create a database for WordPress. But where should I install the WordPress directory so everything would work nicely? A simple Google search led me to this tutorial and within minutes my new WordPress site was installed on my localhost.

Life can be easy sometimes.