Installing mysql on Win XP

[stovio]

I know this is as basic as it gets but if someone would care to help me i'd be greatful.

I have never worked with mysql (i come from a ASP-Access backgrond) and am trying to install it on winxp. Im following a step by step tutorial. After installing the binary the tutorial says this:

"If you are a MySQL virgin and you've never installed MySQL before, you need to create the default permissions, so type ... scripts/mysql_install_db to set these up. "

Where should i type this? In the command line? That doesn't work because mysql_install_db is not an executable. Do i need to install some perl interpretor?
The tutorial later says:

"Typing mysql.server start starts the server, and mysql.server stop stops the server."

Where should this be written and how do i make sure it works? Being used to Access's easy to use GUI, mysql is confusing me.

Again, sorry if im taking up your time with basics but no basic tutorial i've seen explains this so that i get it. Thanks.

[raf]

This is what i read when i started using MySQL on my own machine


http://www.sitepoint.com/article/228/2

Just run through these chapters. There used to be a pdf with the first chapters, but i dont find it anymore on the web.


Also, try firepages package + combine it with the turorial to set everything up

[krycek]

Just remember that the MySQL manual is geared towards a Linux installation.

For Windows, most of the time you can simply download and run the installer, and it all gets done for you :)

Make sure you have PHP installed first, and afterwards test it with phpMyAdmin or something.

Oh yeah and to start MySQL, head over to mysql/bin and run winmysqladmin.exe

That's pretty much it :)

Any trouble, we can help you a bit further...

::] krycek [::

[raf]

For Windows, most of the time you can simply download and run the installer, and it all gets done for you

Hmm. Not on my machine (win 2000 pro) it didn't the previous time. The link i posted covers both windows and linux.

The last time, i just installed one of firepages packages and hardly had to do anything to get it running.

[krycek]

I did say MOST of the time ;)

It's worked fine for me on a number of different Windows systems... and I didn't actually follow your link, sorry :o

I don't like firepages' package because I like to install and configure everything myself, but from what I hear it's a very suitable offering for most people :thumbsup:

::] krycek [::

[raf]

and I didn't actually follow your link, sorry

Hmm. You think you've seen it all hé.:D

I don't like firepages' package because I like to install and configure everything myself, but from what I hear it's a very suitable offering for most people

I hear ya. I'm not an expert in configuring and finetuning all that stuff, so i go with the defaults and adjust it when necessary. (Sometimes read about these things in "debugging PHP books" and that stuff.


stovio,
did this get you any further or are we just chitchatting here? Let us know if you run into other problems/have questions.

[stovio]

Yeah, thanks for all the help. I guess the Unix commands confused me enough to not realise that it actualy already was up and running (it seems to be, the service is running now anyway). Now on to using it, I might consult you all later...

[missing-score]

Hope Im not stealing thread:

Can you install Apache and PHP on Windows XP Home. I posted here cos I think its on the same topic.

[raf]

You are steeling his thread;) and thou should be condembded to the PHP forum (this has nothing to do with MySQL) were thou should read the second sticky.
Thou shall open the link and select the package you want.
Then select the package for win XP

you'll probably and up here
http://www.firepages.com.au/phpdev4.htm

(don't hit the link, you'll miss out on all the warnings)

[missing-score]

I have tried but it doesn't seem to work. I will now stop stealing and start a new thread if I need to...

Sorry!