Hosting my own MySQL database

8BaLL · 10 Jun 2015 at 07:31

Hi all I am currently studying a module on introduction to databases and MySQL at university.
Last night we started working on queries in a database now our tutor wants us to study everything we did in the last four weeks on creating databases and managing them we have been using MySQL workbench.
I have a spare system at home doing nothing I have thought about hosting my own database to practice on listing films I own actors descriptions year and so on for good practice, can anyone point me in the right direction what I should do to setup my own host for a database Linux or windows to start from I would also like to be able connect to this database from any machine
Thank you in advance

antijoke · 10 Jun 2015 at 07:35

Follow something like this:

http://arstechnica.com/gadgets/2012/11/how-to-set-up-a-safe-and-secure-web-server/

There's other guides out there to, just google create your own web server. That will talk you through everything!

leigh_boy · 10 Jun 2015 at 11:04

if you follow the above link and go ubuntu, make sure to enable ssh as it will make entering the commands so much quicker with copy and paste

kaku · 10 Jun 2015 at 15:23

It might be a bit overkill for what you're doing, but you could use a pre-packed L/W-AMP stack like XAMPP: https://www.apachefriends.org/index.html

It also includes PHP and a webserver so you can admin the database through phpMyAdmin or practice making your own connection to the DB via PHP to show things on a web page.

8BaLL · 10 Jun 2015 at 17:11

I will look into all these tonight thanks for your input