Installing MySQL 5.x on Server 2008 x64 RC1

 01 Feb 2008 05:05:28 pm

If you’ve tried to install MySQL 5.x on Server 2008 x64 you’ve probably seen MySQLInstanceConfig.exe (The MySQL Server Instance Config Wizard process) bomb out with the following error:

“The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail.”

If you review the event log you see the corresponding error:

Source: SideBySide
EventID: 63
“Activation context generation failed for "…MySQLInstanceConfig.exe".Error in manifest or policy file "…MySQLInstanceConfig.exe" on line 6. The value "asAdministrator" of attribute "level" in element "urn:schemas-microsoft-com:asm.v1^requestedPrivileges" is invalid.”

This happens with both the x64 and the x86 versions of MySQL because both of them use the 32-bit version of MySQLInstanceConfig.

From playing around with it I haven’t been about to find a way to get the configuration wizard working. From some Google searches I hadn’t seen information out there about how to get around it either. The good news is that (so far as I know) all the work that the wizard does can be done manually and you can work around this problem. First let’s look at what the wizard does:


  • Builds the my.ini file that contains the MySQL settings (connection config, path to data files, etc.)
  • Modifies security (allowing you to set the root password)
  • Configures the MySQL process (mysqld-nt.exe) to run as a service

So to get MySQL running:

  1. Rather than trying to build the my.ini file from scratch I suggest starting with one of the examples that get installed to the root MySQL directory (by default 'C:\Program Files\MySQL\MySQL Server 5.0'). Choose which file makes the most sense and copy it to my.ini and edit appropriately. If you need more information on using the options file see:
    http://dev.mysql.com/doc/refman/5.1/en/windows-create-option-file.html
  2. From an administrator’s Windows command prompt install as a service and start it:
    Code :
    >'E:\MySQL\bin\mysqld-nt.exe' --install MySQL --defaults-file='E:\MySQLmy.ini' & net start MySQL

    (just make sure to update your path with wherever it is that you have MySQL installed)
  3. Using the MySQL Command Line Client set your root password and/or create new users as appropriate:
    Code :
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
    -> IDENTIFIED BY 'password' WITH GRANT OPTION;

    (Just replace ‘password’ with whatever you want your password to be, this will allow you to connect to the server as root from anywhere)

From here on connect to it like you would normally with tools such as MySQL Administrator, etc.

Cheers,
Erik

Category : General | Posted By : Erik | Comments [2] | Trackbacks [0]


Trackbacks

The URI to TrackBack this entry is :
http://www.spyordie007.com/trackback.php/23




Comments

Getting this too

By : Tim @ Time : 19 Mar 2008 03:07:38 pm : Email : Home

Yes, getting this same error message too, will let you know if I find a work around

No need for a work around, this is the solution.

By : Erik @ Time : 19 Mar 2008 03:49:03 pm :

Until the folks @ MySQL re-write MySQLInstanceconfig this is the solution.

Add Your Comment

Subject

Comments

Name

Email Address (Optional)

Home Page (Optional)

Security Code
Click to display security code
Note:Security Code valid for only 10 minutes!
Need to enable javascript & accept cookies to work
Please enter the security code as displayed :



NOTE: All comments are now moderated and will not immediatly appear.