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]