Newbie to Mysql, need some connection help

Do you have Apache or anything else installed or are you going through PWS?
If you have MySQL and PHP etc it has phpmyadmin built in that you can set up database tables etc

I believe it is PWS. I am just trying to set up a local server on my machine, since I want to sooner or later begin coldfusion development. Like I said, I am on a Windows 98 machines and I think I have to go through the ODBC data source in the control panel. I really don't think its apache.

if you think you'd be using Apache etc later on it might pay for you to install a bundle (Mysql, PHP and Apache) one place is firepages.com.au there a few others out there. And they install on windows (I have mine running on win98se).
PWS (personal web server) is a real pain in the butt and causes alsorts of problems (no suprise since its a windows thing)

Mine is more or less a way to get me learning how to put databases together using Mysql. If I was going to take it online, then i would obviously set it up that way, but this is just setting up a learning thing for me.

I think you misunderstood me
if you download the bundle (PHP, MySQL and Apache) you can have it offline so you can learn to make databases, learn to code server side languages etc while offline, then if/when you ever want to use it on a web site it's there to use (the stuff you make) as most servers (web hosts) use apache these days. without it you'll be able to run php scripts or which ever language you choose to run the mysql.
I started off using pws and it taught me some rubbish, using the bundle mentioned I can now create stuff offline, and when happy just upload the .php, .sql files to my site without any changes.
to run server side languages on your puter you need a server (apache), you need a database (mysql) and you need a language (php, asp ...) you can learn and write the code etc without them, but can;t test or run them without the above.
there have been some threads about learning off line, wanting info etc, try a search for "offline" or "pws" etc

Ok, thanks Busy. Where can I download the bundle?

Thanks
Bryan

firepages.com.au is one place that I know of, others have been mentioned on the forums

Check these out: http://www.hotscripts.com/PHP/Scripts_and_Programs/Installation_Kits/

I use firepages phpdev myself, but other popular bundles include PHPTriad and EasyPHP. But I can't recommend anything else as I only have experience with phpdev.

Quote: Originally posted by jag5311
Well, i wanted to create a test so I opened up the winmysqladmin and have it running (i.e, green light in lower right hand corner). Then I start up Navicat and enter my information that I can see in WinMysqladmin. So I put the following:

The Host name/ip address
Port : 3306
username
password

and then I do a connect, and it says connection won't work. I can't figure out what I may be doing wrong.

Odds are that your host won't allow connections from remote locations. Most hosts only allow connections from localhost.