mysql server on windows computer

[proskater123]

I'm looking for a way to run a mysql server on my machine so i can test the webpages i build on the road without and internet connection. I have a web server that can run php but e107 (web site management I'm using) calls for a database. Yes i have looked threw google but to i didn't understand any of it.

So what I'm looking for is basically a mysql server that will run on windows. preferably a GUI to

[Sparda]

There is actually a native windows MySQL server (http://dev.mysql.com/doc/refman/5.0/en/win...stallation.html). However, because your website is likely to end up been hosted on not-windows, you may want to consider installing LAMP in a VM. The simplest (but least secure) way to do this is to use Ubuntu Server with the LAMP option enabled.

[proskater123]

k two things, about the mysql for windows do i use the comunity server download or what.

two can you tell me more about the lamp thing

[digip]

xampp for windows, lamp for linux. Just be sure to set passwords for everything after you install it.

[VaKo]

xammp is actually pretty good for windows, ran a small site off of it for a couple of months at one point, no reboots or restarts needed. It just sat there and did its job.

[puredistortion]

for MySQL it is easy download the community edition from the website:

http://mysql.org/downloads/mysql/5.0.html#downloads

There are the GUI tools that are the done by the Mysql guys:

http://mysql.org/downloads/gui-tools/5.0.html

BUT (and there is always one)

I prefer to use PHP My Admin which you can get from:

http://www.phpmyadmin.net/home_page/index.php

Though you will have to install PHP as well for your web server I use Apache in Dev and IIS in production.

[digip]

for MySQL it is easy download the community edition from the website:

http://mysql.org/downloads/mysql/5.0.html#downloads

There are the GUI tools that are the done by the Mysql guys:

http://mysql.org/downloads/gui-tools/5.0.html

BUT (and there is always one)

I prefer to use PHP My Admin which you can get from:

http://www.phpmyadmin.net/home_page/index.php

Though you will have to install PHP as well for your web server I use Apache in Dev and IIS in production.

Xampp will take care of all of those in one download. :)

[puredistortion]

for MySQL it is easy download the community edition from the website:

http://mysql.org/downloads/mysql/5.0.html#downloads

There are the GUI tools that are the done by the Mysql guys:

http://mysql.org/downloads/gui-tools/5.0.html

BUT (and there is always one)

I prefer to use PHP My Admin which you can get from:

http://www.phpmyadmin.net/home_page/index.php

Though you will have to install PHP as well for your web server I use Apache in Dev and IIS in production.

Xampp will take care of all of those in one download. :)

Ok that is sweet package then, I have not run a Windows Laptop for quite a while now so have not had a need for such a solution. Though I will run up a Windows DomU and have a look at it as that would be a great solution for some peopel I know that runa site/blog as a hobby and need a dev space to work in.