Why i got this error ????

[ozzye]

I instaled yesterday mysql and sqlyog on my pc...i instaled Antrix..averything worked perfectly...i played on my server...but today when i wanted to connect to mysql server with sqlyog i got this eror:

Host "localhost" is not allowed to connect to this MySQL server
etc etc....

it say something about firewall too but i DONT have a firewall or something like a firewall....and it say that i have to open 3306 port...from were can i oped this port and why from yesterday to today got closed...wtf ???
please help me !!!!

[MentaL]

[ozzye]

no one can help me ??? :(((

[ATTILA888]

Can you make a screen shot please?

(When you get the error, press PRINT/Stamp on the upper right corner of the keyboard, than paste on some image editor and save)

I'm not so good in english, so SEEING it by myself would be better.

[ozzye]

[ATTILA888]

When you install SQLyog, did you entered any customized setting?
May i suggest you to reinstall?

FROM Karnage's guide: MySQL 5.0 Essentials and SQLyog.

Follow the basic default setup for both programs -- no special options are needed. To be excruciatingly specific:

* You want a Typical installation, not Complete or Custom.
* Agree to start the configuration wizard when it asks.
* You want a Standard configuration, not a Detailed configuration.
* You want to Install As Windows Service.
* You do not want root access from remote machines, and you do not want an Anonymous Account.

Then if you still get error, you may have windows firewall active (disable it from control panel) or some internet security antivirus (like avg/norton, wich includes a firewall).
If not, go to you gateway (usually 192.168.1.1 or 192.168.123.254 or more, check you router manual for this) trough a browser, and change forwarding rules, opening port 3306 in tcp.

That's all i can say from the screenshots :\

[ozzye]

man i instaled all programs at typicaly...recomandated...or something like....i dont have any firewalls and i have automaticaly detect network settigs.i dont have eny filters or other shits open.......yesterday....it works...i played on my server...for..few hours..i went to sleep....shudown the pc......and today when i started my pc and i wanted to open logonserver.exe and antrix.exe the logonserver started but in 2 3...seconds get closed. after i saw this i wanted to connect to my mysql server with sqlyog and i got the second picture error. i removed the mysql server and intalled once again (typicaly) and at the end i got the first picture error !!! :((( and now i cant make enything.... i think i worked yesterday for nothing

[ATTILA888]

Honestly, if yesterday worked and today not, the problem must be something like opened services/programs wich doesn't allow your port to comunicate... becasue i GUESS that your server can't change itself...

start-run-msconfig, uncheck all useless programs/services, apply, restart, then retry...

nothing else i can say..

[ozzye]

oke 10x...hope i can fix this....but anyway looks VERY strange to me whats happened....:D

[ATTILA888]

looks strange to me too O.o

[ozzye]

i removed MySQL server and deleted from Program Files too.....gave a restart to the pc...and after that i instaled the mysql server once again and worked....now i`m importing the sql files....and after i will restart my pc to see if i got same problem :D :))

[ATTILA888]

before restart, i suggest you to make a "restore point" (i'm not familiar with english windows, anyway there is an application wich allow you to restore a previous configuration of your pc, in case of problems. Do it if server works)

[ozzye]

yes i understand what u are talking about :P

[ozzye]

it works. BUT I CANT MAKE A PAGE FOR REGISTERING ACCOUNTS !! :))
i use antrixse and i can connect to db with this and create accounts but i CANT connect with no web template....or something like....that i took from this site

[aceindy]

try using old password system:


Could be due to old version of php?