MySQL - completely lost!

Going to Cali · 25 Oct 2007 at 20:51

Bit of background, I'm doing some work in java involving several large text files. I figured it would be a good chance to get to understand JDBC so I've downloaded MySQL on a GPL.

I've installed MySQL ODBC, MySQL J and MySQL gui tools 5.0

Now I am completely lost! I have tried to run MySQL Admin but it asks for servers, usernames etc. I just want to create some tables and access them in java. How do I do this?

Many thanks in advance!

SiriusB · 25 Oct 2007 at 22:06

The server refers to the MySQL server. If you were running MySQL with apache the severname would be localhost.

Going to Cali · 25 Oct 2007 at 22:08

How do I setup the username and password for local host?

RobH · 25 Oct 2007 at 22:21

This for the dictionary project thingy again?

JDBC is quite confuisng at first because it involves constructing a few different objects to get things going. I never understood it fully until we covered it in an Internet Programming module at uni. I found that seeing working examples helps learn how to use it.

First off, MySQL management is a complex task itself if you have never dealt with it before, it can be a nightmare to setup. I'd highly recommend downloading something like xampp lite which is a single executable that allows you to run MySQL preconfigured and also comes with Apache, PHP, Perl and phpMyAdmin which can all be enabled or disabled. The benefit of this is that it comes pre-configured ready to use and has a nice web management interface, plus it installs nothing so you can remove it at any time or terminate all running services so it doesn't hog resources.

XAMPP (lite): http://www.apachefriends.org/en/xampp.html