coolgamer48 Posted October 20, 2007 Share Posted October 20, 2007 Hey everyone,Okay - this is my first forum post. I just read through the SQL tutorial on W3 schools, and I want to try out SQL commands? What do I do? Could someone please tell me how to get from reading the tutorial to a place where I can actually use SQL commands. Also, I guess beggars can't be choosers, but please don't post things like "search free SQL hosting on Google". I've spent hours looking on the internet and got pretty much nowhere. So if possible, can you give specific sites that you found useful.Thanks! Link to comment Share on other sites More sharing options...
Synook Posted October 21, 2007 Share Posted October 21, 2007 Well, you can download an SQL implementation such as that contained in a AMP package, such as EasyPHP. Then (assuming you are using windows) use the command prompt (C:\windows\system32\command.com) and navigate to the mySQL\bin folder inside your installation. Run "mysql -u<username> -p<password>" and you will get the SQL query interface. Start commanding! Link to comment Share on other sites More sharing options...
coolgamer48 Posted October 21, 2007 Author Share Posted October 21, 2007 Okay - but where does the username and password come from? I'm guessing some sort of host, right? Where can I find a good one? Link to comment Share on other sites More sharing options...
Synook Posted October 22, 2007 Share Posted October 22, 2007 Well, on the localhost your databases are stored on your computer - no external host needed . I think the default username and password for EasyPHP is "root" and "", so try mysql -uroot Remember, SQL is just a type of database, like Access, and is not necessarily reliant on a third-party host. Your computer is he host in this case Link to comment Share on other sites More sharing options...
coolgamer48 Posted October 22, 2007 Author Share Posted October 22, 2007 Wow - thanks a lot. I figured that you could just run a database on your computer, but all the sites (and people) I went to made it sound like you needed a third party host. I can't try it right now, but I hope it works when I do. Link to comment Share on other sites More sharing options...
Nanaki Posted October 23, 2007 Share Posted October 23, 2007 if you're just in to learning some SQL, and aren't up to work too hard to get started there are packages with free open software to get you started locally on you computermacmamp - http://www.mamp.info/en/index.php and a sql client like http://cocoamysql.sourceforge.net/ (phpMyAdmin is included in mamp, if that suffice)windowsxampp - http://www.apachefriends.org/en/xampp-windows.htmlsql client like http://www.heidisql.com/linuxnot sure.. but http://lamphowto.com/ looks like a place to start. google is also your friend. the key word is lamp (linux, apache, mysql, php) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.