How can i learn MySQL without a server setup?
Feb 23rd, 2009 | By KC | Category: My SQL RelatedIf i only have my mount alone computer, how can i use regulating MySQL as well as observation a web pages?
-
We Are This Fast!
-
Who writes
You can install a server on your computer for practicing (recommended) or you can get an account at a free hosting site with MySQL, like http://www.freehostia.com and use that.
As I said, I recommend the first option. There are several WAMP packages (Windows) or LAMP packages (Linux) that you can install to get everything you need, hence the acronym.
WAMP = Windows + Apache + MySQL + PHP
LAMP = Linux + Apache + MySQL + PHP
Just search your favorite search engine to find one.
Alternatively you can install each individual component yourself which is a little more difficult but at least you know your getting the latest version of everything. If you're going to do that then you want to install Apache, then PHP, then MySQL.
[edit]
Also, if you install a server on your computer I would recommend looking into PHPMyAdmin. It's a tool that allows you to manage your MySQL databases and tables from a web interface. I would still recommend trying to learn the MySQL commands but PHPMyAdmin can be very useful. Also, any time you do anything with PHPMyAdmin, like delete a table or row or create a new table, it shows the command it used to perform that task and the MySQL response, so it can help you learn the commands.