Installing MySQL as a Service Under Windows Vista

Dec 14, 12:56 am
tags:

I upgraded to Windows Vista this past Sunday, and while the experience has been generally positive, there certainly are several new features which require some familiarization. For instance, even when logged in as an administrator, it’s not possible to execute administration-level commands via the standard Windows command-prompt. Rather, you need to navigate to the prompt menu entry via Start > Programs > Accessories, and then choose “Run as administrator” via the context menu (right-click on the menu entry).

I ran into this problem when attempting to install MySQL 5.1.4-beta on the laptop this evening. After receiving several “Access denied” messages when attempting to install it as a service, I investigated the matter further and turned up this nugget of information. Once done, the service installed without a problem.

UPDATE: Windows guru Jon Hassell pointed me to a recent blog entry on his Vista: Beyond the Manual website showing readers how to create an elevated command prompt. Here’s the link.

Permanent Link
by Jason Gilmore

    1. raghs says:
      Feb 9, 07:09 am

      Hi

      (HP labtop) (OS – windows VISTA) while setuping the MYSQL – stage EVALUATE. it will select 4 options , it will rightup first and second for third and fourth it will showing the error (windows firewall problem) Message is Retry or SKIP. Open the command prompt we enter the password – THE field cannot be access.
    1. Lucas Henrique says:
      Mar 1, 09:25 am

      It works great for me:
      Start > Control Panel > Network > Firewall > “Allow a Program…” (sorry 4 my english, my windows is in Portuguese) > Exceptions > Add Port… > MySQL5/3306/TCP > OK


    1. Rainman_02 says:
      Mar 2, 01:29 am

      Tried Lucas’ solution – several times. running Vista Ultimate, PHP, MySQL, with IIS7. Cannot seem to get past the ‘firewall’ issue. Still searching…


    1. Wayne says:
      Apr 11, 10:17 pm

      I am a software developer and decided to switch to Vista today. Installation went smooth, until I started to install MySQL. The InstanceConfig wizard cannot connect to the Database. Found a fix after playing for a little while. In Vista, open your Task Manager, find the mysqld-nt process. Right click on it, select properties. Change the compatibility mode to Windows XP-SP2. Save and end the process. Now, run the InstanceWizard again. It should work now!


    1. Rainman_02 says:
      Jun 1, 03:20 pm

      Wayne, THAT DID IT! Thought I had already tried that to no avail but, tried it again and config went quite smooth. Thanks is not enough.


    1. febry says:
      Oct 17, 03:43 am

      its great, May God Bless You. I’ve been frustated cause of my mysql wont work on vista. until you share the way to on it. thanks again to you “Wayne”


    1. saimatkong says:
      Dec 18, 01:13 pm

      I still can’t connect to mysql in vista
      Fatal error: Call to undefined function mysql_connect() in C:\inetpub\wwwroot\testconnection.php on line 2

      any advise?


    1. Roger says:
      Jun 3, 08:09 am

      I tried all the above solutions with no success.

      This one worked for me.

      I uninstalled MySQL, deleted all files from MySQL installation path, run a new installation and before I run configuration setup and starting MySQL as a service I added an exception for mysqld-nt in Windows Firewall. After that I finished the configuration setup and started MySQL as a service. Voila!


    1. Raja Shahed says:
      Jun 23, 08:32 am

      HI saimatkong
      I doubt your extension_dir is not correct. your configuration can not reach to mysql.dll files. For that reason you may have such an “Fatal error: Call to undefined function mysql_connect() in C:\inetpub\wwwroot\testconnection.php on line 2”
      regards
      Raja shahed




Add your comments

Please keep your comments relevant to this blog entry: inappropriate or purely promotional comments may be removed. To add hyperlink, please follow this example: "your link text":http://your.link.url