MySQL Basics

Resources

• Web server address hulk.osd.wednet.edu
  • Your database is titled your OSD username and password
  • Accessing the Hulk Web Server on the Internet
    • Putty - Free SSH (Secure Shell) Clientto Access the Web Server
    • Tunnelier - Free SCP (Secure Copy Protocol) Program to Upload Files to the Web Server
    • WinSCP - Another SCP (Secure Copy Protocol) Program to Upload Files to the Web Server
• Tutorials
  • http://www.w3schools.com/sql/default.asp
    • Learn and experiment with the basics of a database
    • Great place to try out your basic query skills
    • Start here and then move to W3schools PHP and MySQL below
  • http://www.w3schools.com/PHP/php_mysql_intro.asp
    • A good place to start with PHP web publishing and MySQL
  • Command Line Help with Examples
    • http://dev.mysql.com/doc/refman/5.1/en/mysql.html
    • http://www.petefreitag.com/item/584.cfm
    • http://www.pantz.org/software/mysql/mysqlcommands.html
  • http://www.freewebmasterhelp.com/tutorials/phpmysql/
    • Very good tutorial to get started with some nice scripts to run
  • http://www.irphe.am/docs/PHP_MySQL/PHP_MySQL_Tutorial.html
    • Tutorial with a little more depth, careful it could hurt your brain
• 
• PHPMyAdmin Resources for managing your database from the web
  • http://www.youtube.com/watch?v=1-81n_vuwug
    • Good basic overview of a cool visual management environment
• MySQL Web Site
  • The makers of the language

Tags: MySQL, Programming