Error 1045! And Mysql Errors (3 Errors)

[peterlaursen]

I think I understand that the mySQL server is running on your local machine?

1) When installing (using the MSI installer) you entered a root password. With that root password you should be able to connect! If you forgot it will only take 5-10 minutes to uninstall the server and reinstall!

DO NOT EVER FORGET THE ROOT PASSWORD!!

2) Firewall

–> first try to disable the WinXP firewall to see if that is the problem. If it is then configure like this. Open 'Windows firewall' from Control Panel, to to the 'Exceptions' TAB, click 'Add port' and add the MySQL port (normally 3306) here.

3) You are talking about executables int the bin folder under the installation folder. You cannot execute any of the .exe's by double-clicking for instance. There are two types of binaries here:

—>The Server binaries, they are normally run as Services in Windows. To start the Mysql service from command line type 'net start mysql'. But if you chose to let the Server start with Windows when installing it should be running. Do you see any proces like 'mysql*****.exe' in Task Manager

—>Clients and Utility progams. They are command line programs only and you will need to give the correct parameters with them.

[Notowning]

Thanks, but do I need Service Pack 2 for this, because right now I have no Windows Firewall in my control panel…

[peterlaursen]

don't you have a 'security center' icon then?

[Notowning]

peterlaursen wrote on Dec 15 2006, 12:03 AM:

don't you have a 'security center' icon then?

Alright, well I downloaded SP2…Kind of, it didnt fully work, but I know have a Windows Firewall, and I did the exception stuff, and opened port 3306, but Im still getting the same problem when I try to reconfigure the MySQL Server, the Apply security settings won't check, and I get error Nr. 2003 saying the port is closed… Any other Ideas?

[Author]

Posts