Setup MySQL : Apache2

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.

INSTALLATION

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.

—-Madan 

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s