Beginner in MySQL

[old.Massive M]

I'm plannin on learning MySQL, cause from what I've heard, you need to combine PHP and MySQL to do really neat stuff

Any1 out there knows any good tutorials for beginners? And I'm really a beginner, I know basically nothing about it.

And is it possible to run MySQL locally with PWS the way you can run PHP locally with PWS? Or do I need to setup Apache?

 

[Teaser]

Aye you can run the whole shoot'n'match on your own machine.

You can use personal webserver (might aswell, no point in faffing with Apache) to run your web server, then install php and mysql.
Goto www.mysql.com to get the windoze binaries, then www.php.net to get the PHP installer (it's eaiser - does stuff for you). PHP will set-up PWS for you (so install PWS first). Now install php and mysql (doesnt really matter in which order).

There is an ini file you will need to edit and there is documentation on the php.net and mysql.com about this.

 

[old.Massive M]

Thanx!

ah, thanx! I'll try that! If I'll get any problems, I guess I'll post here again

 

[old.Massive M]

Exact address?

could someone plz give me the exact address to the file on mysql.com that I should download to make MySQL to work on PWS?

 

[SoWat]

You *may* be better off using something like the Xitami server. php406 has built in support for it, and edits the server files direct (like PWS).

As for the mysql file, go here and look at the section headed

Latest version is: 3.23.40

Standard binary (tarball) distributions:

The file you need is the one at the bottom of the list (Windows95/98/NT/2000 INTEL).

 

[old.Massive M]

tnx

Thanx man!

But there aren't anything named exactly like that you wrote there... there is one Win95/98/2000 though, but it's not at the bottom of the list...?

 

[SoWat]

Hmmn, the page has changed.

Lemme snoop around and see if I can find it!

Later...
Aha, it's moved down the page as they've a new incremental release.

The direct link to the file is below (right-click and save):

http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.40-win.zip

 

[old.Massive M]

Tnx!

Thanx man! (again) And that file does work with PWS, right??

damn I ask a lot... hehe

 

[SoWat]

I use it on xitami server, but I see no reason why it shouldn't work on PWS.

Grab the manuals from here:

http://www.mysql.com/documentation/index.html