[SOLVED] mySQL on localhost?

[clown[NOR]]

well... i'm about to install php on my computer but I have some ok knowledge about it, so I wanted to tryout MySQL now since i'm going to learn it anyway so what i wonder is if there's any posibility to download MySQL and install it on my computer.. btw... i do need apache right?

 

and how big are Apache & PHP? the partition I've made for  hosting my test sites is currently on aprox 30GB... should that be enough or should I give it more space?

[Wildbug]

There are packages for *nix and binaries for Win32.  You don't need Apache; MySQL stands alone.  There is a MySQL client program included with the installation; you can type queries to the MySQL server via that program.

[Wildbug]

Oh, you will need Apache for PHP, though.  I think the download for MySQL is around 40MB.  I don't know about the others.  30GB should be plenty for testing.  I think I only have 4GB for mine, and only a fraction has been used.

[clown[NOR]]

oh ok.... well i just downloaded something called wamp5 ... it was recommended on a post on here... should i just uninstall it and download apache, php & mysql and set everything up myself?

[Wildbug]

Well, it looks like WAMP is Apache, MySQL, and PHP (for Windows), so I think you have everything already -- no need to mess with the individual bits.

[clown[NOR]]

cool... thanks =) yeah I've finally started working with MySQL =) really looking forward to this =)

[Wildbug]

Do you have some good resources for learning MySQL?  I don't know how much you've used the language/database before, but the manual is actually pretty accessible.  Especially read/review chapters 3 and 11-13.  I'm sure there's plenty of material online, but the book by Paul duBois was very helpful to me, too.  And typing in queries and seeing the output in the MySQL client gives you a good sense of what's happening.

 

Hope that's helpful.  Have fun with it!

[clown[NOR]]

I dont have that book, but I have google and you guys..haha =) I've made a complete address book now (w/edit and delete) =) not that impressive, but my first ever..hehe..

 

but I have an ability to pick up things pretty fast... never thought that MySQL was so "easy"... all you need to do is using your head and think logic =)

 

like... how much do you need to understand than this? SELECT FROM, UPDATE, WHERE, etc... it's really logical =)

 

but when I first looked at it.. like the very first time it looked like rocketsience written in latin =)

[jfs0479]

I currently use my localhost for testing sites in php, mysql, apache but to make the job of setting it up i used http://vertrigo.sourceforge.net/ . it is great and its free it sets it up automatically every time u log on and you have php myadmin sql lite aphache manager

 

Its a must Have!

 

James

[clown[NOR]]

thanks for the tips m8... that's exactly what wamp provides to... i just click on the little system tray icon and select phpmyadmin from the menu and from there I access whatever I want =)