LinkShare Referral Program

New

Advertise ad Here
learn more
            PHP > Installing MySql on Vista

PHP


Useful

Links


Free technical Tutorials At techtutorials.net



Link Exchange at iWEBTOOL.com

 



The PHP Resource Index


iBuyOfficesupply.com Inc. There are N. 10 Comments for this Article
Ask any relevant question in the Comments or leave your valuable feed-back

printer  Print version of this article

star  Add it to your favourite!

mail email this page to a frend
LinkShare Referral Program

How to Install and Configure MySql on  Windows Vista and Apache



    •  MySql 5.0.45 with Apache running on Vista

    1st part - Installation

    

    Find more tutorials at



    Scripts.com

    To install MySql on Vista is not much different than installing it on Windows XP.Just be aware of which version of MySql you will download.There are many versions available on the net,and I used the MySql for Windows ZIP/Setup.EXE (x86) fthat you can find here at the MySql website, Scroll down the page and find this version , a file of 42.5 MB and download it.

     

    1. Log in  with administrator permissions. Turn UAC (User Account Control) off , if you don't know how , read this How to turn UAC off and Windows Firewall off, temporally or any other Firewall software you have on your computer .See this Manage Windows Firewall When your download is complete,go to the location where you saved the file and double click it.
    2. The installation process begins
      3. .When you get to the window below,check Typical and click Next

      MySql 1




    3. On the window below click Install

      4. Sql Wizard 2



    4. Then, the installation is complete .Uncheck Configure the MySql server now and click Finish
      5. .Before you go ahead with the configuration,it's better to set Windows Firewall to allow MySql on port 3306 ,

      Sql Wizard 3



      Comments

      Post your comment here or ask any question that is rilevant on what is shown in this page.
      Thank you for visiting this website

      N. 10 Comments for this page!   add a comment

      From:  sze   Comment Nr 1    
       Posted on  16/03/09
      		  
       TOO SIMPLE
      From:  Informer   Comment Nr 2    
       Posted on  21/03/09
      		  
       Too simple and incomplete.Why do you say one should uncheck "Configure the MySql server now " .How else will they configure the root p****word?
      From:  admin   Comment Nr 3    
       Posted on  21/03/09
      		  
       Dear Informer,it isn't incomplete,it's only the first part,since we are talking about installing in this part,please read the second part Configuring MySql on Apache and Vista. You may find the answer to your question ..... Too simple you say,well,I can't see any good reason to make it complicated when it works perfectly in this way.
      From:  siva   Comment Nr 4    
       Posted on  24/03/09
      		  
       Thank you very much my friend for reminding me on turning of troublesome UAC and firewall in vista. i tried many times but failed in configuration stage with error 1045 - "access is denied" even after allowing the port 3306 under firewall. finally i turned off both the culprits UAC and firewall while installing as well as configuring and it worked. great!!!
      From:  mimie   Comment Nr 5    
       Posted on  22/05/09
      		  
       wow.. thanks a ton admin..i cant believe ive been struggling with the installation for the past 2weeks, i almost went crazy! It actually never crossed my mind it might be prob with vista security coz i had already configured my firewall for port 3306 but it kept giving me a headache.. i even had to take a few days off duty to try work on it when thre's no one on my case.. LOL Thanks so so so much once again, u r such a life saver!
      From:  Ram   Comment Nr 6    
       Posted on  09/06/09
      		  http://www.smartstudentscollection.com
       You have asked to add mysql port for windows firewall. I am using MCCUFFE total protection. Should this be added in the firewall of this.
      From:  admin   Comment Nr 7    
       Posted on  09/06/09
      		  
       Yes,you have to open the port for MySql on any firewall.
      From:  Koa   Comment Nr 8    
       Posted on  30/06/09
      		  
       For two months I have tried to get MySQL to work on Vista 64 with every combination of PHP4, PHP5, MySQL 5.1, MySQL 5.4, Apache 2.2, and IIS. I have tried going through this tutorial, but am still getting "Call to undefined function mysql_connect()". Any other suggestions before I reinstall Windows XP where I had it working perfectly? Thanks.
      From:  jp50   Comment Nr 9    
       Posted on  14/07/09
      		  
       Hi,this tutorial has not been tested for Vista 64,therefore it may not work.Try the one for win server 2003 64bit on this site.
      From:  play roulette for fr   Comment Nr 10    
       Posted on  23/07/09
      		  
       Really i am impressed from this post....the person who create this post he is a great human..thanks for shared this with us.i found this informative and interesting blog so i think so its very useful and knowledge able.I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well..... http://www.onlyfreeroule tte.com
    i