Idiot With 1045 Error

[disco]

I have no experience with MySQl what-so-ever, but I would like to become familiar with it and run a private server for a game using my computer.

I am using SQLyog, but I also have Navicat.

When setting up my first connection, i get the 1045 error, saying “Error No. 1045: Connection denied for mangos[which is my username i guess]@localhost (using password: YES)”

I was reading other posts, but they don't seem to help…

Im using port 3306, which I have made an exception for in my firewall (i think… I'm a bit sketchy on making exceptions using ZoneAlarm) and I have forwarded the port to no avail.

I am very confused about the whole mess and hope spmeone can help me out. 😛

[peterlaursen]

Two ideas:

1) wrong password ..

2) user does not have a password …

Actually we have had a lot of issues with ZoneAlarm over time.  I used it myself but stopped when i started running Server programs.  It had a tendency of blocking when it should not!  Try to disable it (or even uninstall) temporarily once you are sure that your details are correct.

[disco]

my details are correct.

i tried disabling zonealarm but i still got the 1045 error.

im running off of these instructions: http://www.sapphiresbar.com/guides/server.html

scroll halfway down the page until there is a table that says “SQLyog Installation”

also, i forgot to mention that i'm specifying which databases I'm using, could that effect my initial connection?

[disco]

also, i am able to connect using my root account (ie root@localhost) but I don't know it that means anything since i may not need any open ports to establish that connection…

I have no idea…

[peterlaursen]

I saw this page earlier this day as our Server statistics stool told me that we had quite a lot of referrals from it.  You are referring to this description, I think:

Quote:

MySQL host address: localhost

Username: mangos

Password: mangos

Port: 3306

Database: mangos;realmd

While SQLyog is open, first connect (fig7, fig8, fig9, fig10) and then create two databases MANGOS and REALMD(fig11, fig12, fig13);

However how was the user 'mangos' created? The instruction tells you to create a VERY STRONG password for 'root' but nothing about creating the user 'mangos'. Actually now it looks to me that the instruction totally skips the creatio

 of user 'mangos' and his privileges.

Try to log on as 'root' (with the password you gave him), go to tools .. user management ..edit user.  Is 'mangos' there? If not go to tools .. user management … create user (mangos).  Give the password (twice).  Can you now log on as 'mangos'?

Also there is nothing told about what privileges 'mangos' will need for the game server to be functional.  I would start to give him ALL available privileges to the two databases “mangos” and “realmd”, but NO privileges anywhere else.  Do that from tools .. user management .

 management permissions.  Locate the two rows of the databases and check all boxes in the two rows only.

[disco]

i successfully created “mangos”, but i still can not connect with that user.

i have disabled zonealarm. for some reason my bit torrent client has also stopped working, but disabling zonealarm didn't help. I can still connect to the internet obviously) but it appears that I can't open or close ports.

have you ever heard of this before or know what I'm doing wrong?

also, can i just use the root user instead of mangos, or would that be too risky? Or would it even work at all?

The databases are also not listed under management permissions

[peterlaursen]

“but i still can not connect with that user”

If you can connect to MySQL as 'root' I can only see wrong password as the reason why you cannot with 'mangos'.

I have no experience of my own with bittorrent.

Did you try to UNINSTALL Zonealarm!  My experience (from when I used it myself) is that you cannot trust it when it says it is disabled!  If you do not have a router, enable the Windows firewall so that you are not totally unprotected.  

BTW: Windows Firewall .. enabled??

If so port 3306 must be opened here too!

[disco]

I have windows firewall's ports already opened for my p2p, and i added 3306 for MySQL, but it still doesn't work.

The password i know is correct.

I thought now to run my antispyware, and i found 14 infections (which is ALOT for my computer). But now everytime i run my antisoyware, the same infections are found even though SpyBot says it fixed them earlier.

I will run antivirus and post results.

[disco]

ok, i ran antivirus, found nothing.

but now it works o_O

I don't know what happened, but I'm just glad it's working now

thank you for all your help!

[Author]

Posts