keith27

Sigh....

I've spent all morning on this problem and have gotten no where. I'm trying to install MySQL onto my webserver. I just did a fresh install of Server 2003. I have PHP 5.2x install already and it works fine.(tested with an info page) Now MySQL won't configure properly. I run through the automatic config and choose all the correct options but when it comes to starting the service it says "Error 0". So I stopped the MySQL service myself and that seemed to get my past that error. But when it came to applying the security settings I get an error that it cannot connect, telling me to make sure the port is open. Error 1045.

What gives? Oh forgot to say I'm using IIS 6.0.

keith27

Well I'm pulling what's left of my hair out.

I had it with the errors so I reinstalled Server 2003. Same problem. I hate, hate MySQL.

tgxiii

Have you given XAMP a try? http://www.apachefriends.org/en/xampp-windows.html

BLinux

well, you could always install some Linux distribution like CentOS and then install MySQL on that... it's always worked for me!

when MySQL fails to start or has problems, it will usually log the problem somewhere. in the Unix/Linux world, it's usually a log file in /var/log or in MySQL's home directory (e.g., /var/lib/mysql). I don't know about MySQL in windows world... maybe check your system application logs? (run 'eventvwr' and click on application logs)

that might get you more information about what's causing your problem...

PinkPenguin

The last error, error 1045 is a security error:

Did you try to login with mysql -u root?

MySQL users are stored in the MySQL table 'user' in the database called 'mysql'.

__________________

Need an item shipped to the UK or US territories from the US? PM G|F.E.A.D|Killa for more info

keith27

Thanks fellas.

Just to fill in the blanks. I do have a linux server running other software. I like Windows for Web Services. Makes editing very graphiclly fun.

After much research it appears the latest version of MySQL is having install issues with Server 2003. So I just rolled back a bit. No big deal. Works perfect now. Thanks for the help guys.