Membership Membership:
Latest New User Latest: vpros
Past 24 Hours Past 24 Hours: 0
Prev. 24 Hours Prev. 24 Hours: 0
User Count Overall: 137

People Online People Online:
Visitors Visitors: 0
Members Members: 0
Total Total: 0

NakedMCSE Computer Tech Support Forums

So you have passed all of the exams and you are now out in the real world of windows servers, linux servers and freebsd servers faced with a tech support problem you have never seen before...

Find free online tech support in the forums below, respecting that advice is free, but work beyond advice is not...

The General forum is provided for off topic discussion.

You need a user account to post - please Register or Login.

Online Tech Support Forums
  Forum  Open Source Tec...  MySQL Server  Installing MySQL 5.1.36 on Windows Server
Disabled Previous
Next Next
New Post 7/31/2009 3:10 PM
119 posts
10th Level Poster

Installing MySQL 5.1.36 on Windows Server 
Modified By Walker  on 9/24/2009 4:29:09 PM)

If you use the .MSI installer for MySQL 5.1.36, on the vast majority of todays hardware the installation will fail.  It will tell you that it 'prematurely ended'.  This is due to the fact that for some reason the installer does not work with hyperthreading or multiple processors.

The only way to install 5.1.36 is to use the zip file download and do the following:

  1. Extract the contents of the zip file to where you want MySQL to live in the filesystem.  Typically this is c:\mysql, but it can be anywhere - C:\Program Files\mysql is also popular.
  2. Edit the permissions on the directory where you have extracted the files to give 'Local Service' full control.
  3. Navigate to where you extracted the files and copy one of the mysql.ini files to C:\Windows.  There are four different files based on the memory usage you want.  Rename the file in C:\Windows to 'mysql.ini'.
  4. Open up mysql.ini for editing and make sure that the following is set in the [mysqld] section:
    basedir=c:\mysql (or whereever you extracted the files to)
    datadir=c:\mysql\data (or whereever you will be keeping the datafiles)
  5. Open up a command prompt and navigate using 'cd' to the bin directory under the directory where you extracted the files to.  So if you extracted the files to c:\mysql then you would open the command prompt and type 'cd c:\mysql\bin'.
  6. In the command prompt type 'mysqld.exe --install MySQL --defaults-file=c:\windows\my.ini --local-service'.
  7. This should create the MySQL service.
  8. Type 'net start MySQL' and MySQL should start.
  9. Now you need to set the root password - it is currently blank.
  10. At the command prompt type 'mysqladmin -u root password 'realpassword' ' where you replace 'realpassword' with the password you want to set.
  11. Install is complete.

Youtube Video can be found here.

Lairds Computer Services

Disabled Previous
Next Next
  Forum  Open Source Tec...  MySQL Server  Installing MySQL 5.1.36 on Windows Server
Send me One Million FREE Guaranteed Visitors