Error 1045! And Mysql Errors (3 Errors)

[Notowning]

I'm trying to set up a database, but everytime I try to connect with SQLyog Community Edition (5.21 Binary) I get this error:

Error No. 1045

Access denied for user 'root'@'localhost' (using password: YES/NO)

I've tried not using a password, and using a password, and always the same error…

The only idea I have, is that while I was installing MySQL, on the last step, where it checks off 4 things

1. Prepare Configuration

2. Write Configuration file

3. Start Service

4. Apply Security Settings

It does the 1st 3 without any problem, but on the 4th one an error comes up:

Error Nr. 2003

Can't connect to MySQL server on 'localhost' (10061)

It says that “If a personal firewall is running, then please open port 3306”

Since I have Windows XP Service Pack 1, it has a built-in firewall, if I get SP2 and turn off the personal firewall you think that might solve the problem?

3rd problem:

In my MySQL folder, I can use any of the .exe's, I try to execute them, and none of them open, how can I fix that? I can see one .exe, its the MySQL Server Instance Configuration Wizard…..

So if anyone could help to fix ANY of these three problems, I'd GREATLY appreciate it

-Zach

[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