Creating a practice MySQL server.

Jeebus

Howdy,

I have an exam on Multiple relation queries and subqueries in SQL this Wednesday and I'm finding it pretty abstract. So I was wondering if someone here would be nice enough to help me set up my own little server so that I could practice a bit ?

Any help would be very much appreciated!

I have a practice table made in word, to create the actual tables I would be practicing on within the server, but actually setting up the database is proving to be more trouble than I anticipated.

Thanks a lot for your help, sorry for the stupid question !

Tom Dunne

Download Virtual Box, download a Linux distribution that includes MySQL and away you go.

It's actually fairly straight forward.

Alternatively, you can download MySQL itself and install it on Windows. Might be the lesser of two evils.

Eoin

Or see if you can get a free / trial hosting account somewhere online that has MySQL

A quick google gave me this:
http://www.000webhost.com/free-mysql-hosting

feylya

A really simple way to install it is to get WAMP

http://www.wampserver.com/

1 install file and it's all preconfigured.

Webmonkey

feylya wrote: »

A really simple way to install it is to get WAMP

http://www.wampserver.com/

1 install file and it's all preconfigured.

+1

newholland

Webmonkey wrote: »

+1

Or you could try easyphp or xamp

waraf

newholland wrote: »

Or you could try easyphp or xamp

+1 for xampp

kenbrady

http://dev.mysql.com/downloads/mysql/5.1.html#win32

Download Windows Essentials (x86)
Just double click download and follow instructions to install

You can then use the command line tool to run queries & create tables.

Also consider adding a GUI program on top of your mySQL to make it a bit more user friendly. I use HeidiSQL quite a bit on windows, and it's great to speed up the creation of tables, entry of data and viewing resultsets.

MOH

Deleted User wrote: »

Also consider adding a GUI program on top of your mySQL to make it a bit more user friendly. I use HeidiSQL quite a bit on windows, and it's great to speed up the creation of tables, entry of data and viewing resultsets.

+1, I've been using Toad for mySQL for the same thing

Evil Phil

+1 for wamp/xampp. It's the easiest way to go.

DonkeyStyle \o/

+1 @ wampserver
It even has phpMyAdmin installed.

Webmonkey

There all the same.

sicruise

Try out http://dev.mysql.com/downloads/gui-tools/ after installing mySQL

You can use the GUI to make the changes you require and before commiting change it will display the query to you. It is the mySQL administrator that you will be looking for.

Roryhy

Hi, im trying to get zencart to run on my laptop through xampp but im obviously missing something, any tips?

Eoin

More details on the problems you're having? If you've IIS running as well, I think you might have to change the port that the PHP webserver runs on.

Roryhy

Hi Eoin. Ok details, using Xampplite v1.7.2, Zen Cart v1.3.8a. In Xampp i am running Apache and Mysql. I have placed the zencart files in C:/xampplite/htdocs/. I am able to find these files in my browser but i cant run them. Theres a file called zc_install that should take me through the installation but its not running for me. I have installed zen cart on a server twice before, it was pretty straight forward, but this i cant figure. Can you tell me more about IIS? would my machine be running it itself? if not, i havent installed it myself. Also the ports, Apache (http) Port 80 Status system, Apache (webdav) Port 81 Status Free, Apache (https) port 443 Status free, MySql Port 3306 Status System. This make sense?

Webmonkey

First of all, obvious I know, but is the server running at http://localhost/.
I would also do a simple PHP test page then to see if it's parsing PHP...

Roryhy

Mr Monkey, you just solved my problem, thank you very much. Only a newbie to all this so stating the obvious is often the answer.

Now, i have installed zencart, on the last page of the installation it gives me two options.

Click here to go to store. link is blank

Click here to go to admin. after which i get this line repeatedly

Deprecated: Function ereg() is deprecated in C:\xampplite\htdocs\includes\classes\db\mysql\query_factory.php on line 177

followed by

Deprecated: Function ereg() is deprecated in C:\xampplite\htdocs\includes\classes\db\mysql\query_factory.php on line 412

followed by

Fatal error: Cannot redeclare date_diff() in C:\xampplite\htdocs\admin\includes\functions\general.php on line 3001

Help please

Roryhy

It seems my version of Xampp is new and doesnt support zencart anymore, going to get older version of Xampp now

Roryhy

In the end downloaded Xampp v 1.7.1, not available on the ApacheFriends site, had to google it to find a copy. Re-installed zencart, working perfectly now.