Once you have done with php as i explained here you would want to use SQL database through your PHP to mke your programming more sophisticated. Well this post will help you setup your own SQL on your computer. Apache2 , Php , and now MySQL will give you a complete test environmment for your codes on your desktop.
Setting up MySQL is relatively much easier than the other two but then you'l find no reason for installing MySQL not having Apache and PHP . Well in short let me tell yowhat MySQL is. It is just another database system where you can run a database server on your computer (or online) . You can use this databse system to help you store username/passwords , comments, scrapbooks etc. You may store and retrieve data from these tables. You may do it from your PHP page itself presenting to the user a very dynamic page.
1) Download : goto http://dev.mysql.com/downloads/mysql/4.1.html and get a Windows 95/98/NT/2000/XP/2003 (x86) binary "Windows Essentials (x86)" version
My file was named : mysql-essential-4.1.20-win32.msi actually there will be too many options , make sure you download the right one .U may see it in the pic below
2) Instal :
Juat run through the options during installation as below
- Typical Setup
- Skip Sign-Up
- make sure "Configure the MySQL Server now" is checked
- "Detailed Configuration"
- "Developer Machine"
- "Multifunctional Database"
- "InnoDB Tablespace Settings" – leave everything default
- "Decision Support (DSS)/OLAP"
- make sure "Enable TCP/IP Networking" is checked and leave the port number at 3306 (at this point, if you have a firewall, it will usually try to access itself on the localhost)
- "Standard Character Set"
- check "Install As Windows Service"
- I recommend leaving "Include Bin Directory in Windows PATH" unchecked
- enter your root password and I would recommend checking "Root may only connect from localhost" most importantly remember your password!!
- then hit "execute" and it'll install and set it up.
3) openning and checking it installed :
go: Start –> programs –>MySQL–> MySQL saerver 4.1–>MySQL Command Line Client
You should be able to see his:
just enter your password and then press"enter" which should show you this
Hey good work. job done. This is is , now get to work man. One site that particularly hellped me learn sql propely was 'php-mysql-tutorial.com' i guess you'l also find it usefull.
P.S :- First get to learn how to manually create, edit ,delete dabases and tables and then step into doing all this using PHP pages.That'l take you through easily.