MySQL hangs after startup Windows 2003

Description:
After the MySQL service has started up, msqld-nt.exe starts taking more and more memory and “hangs” for about 30min. Meanwhile you can’t connect to the MySQL console nor will MySQL accept connections, meaning your databases are down for that time, which can be very critical.

Basicly it means after restart of Windosws, it will take 30min for MySQL to work again!

Environment:
Windows 2003 with Service Pack 1
MySQL 4x / 5.x (same error on both versions) - Slacky SUN!

Workaround:
I found out that if you set the MySQL service to start as Administrator, or make a independent account for it (with read/write rights), instead of starting as SERVICE (default), it will start instantly!

How to:
Go to Control Panel > Administrative Tools > Services
Choose MySQL > right click > Properties > Log on > This account

and write in your account login data. I’ll use the Administrator account for now…

Keywords:
Error establishing a database connection
MySQL hangs Windows 2003
MySQL hangs on startup
MySQL slow startup