Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I'm trying to install MySQL 5.1 on a Windows Server 2008, but I'm just not getting even after trying a million different things.

The installation actually goes smoothly, but I can not start the service - it gives me an "Error 0" (but sometimes just an error)

Already tried uninstalling, deleting all folders, regs,etc. and reinstalling but still nothing.

Heres the my.ini:

[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port=3306
basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"
default-character-set=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=9M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=17M
key_buffer_size=10M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#skip-innodb
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=17M
innodb_log_file_size=10M
innodb_thread_concurrency=8

Does anyone have any idea about how to go ahead with this?

EDIT:

Looked up event viewer and got this:

Plugin 'InnoDB' init function returned error.

share|improve this question
    
does it start if you use skip-innodb? –  Jure1873 Nov 17 '09 at 20:33

4 Answers 4

I can't find the problem exactly but I can give you some hints to try out.

  1. Add a firewall exception.
  2. Disable UAC.

Those are the things that can make some strange problems. :)

share|improve this answer

Try to search in the event viewer an error about mysql, maybe you can find more details.

share|improve this answer

You can start mysqld on safe mode througt cmd shell to have a verbose execution!

share|improve this answer

make sure the C:/ProgramData/MySQL/MySQL Server 5.1/Data/ folder exists, and there really isn't supposed to be a space in "ProgramData".

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.