installing mysql, attempting to start server, getting error!

[spewn]

i typed into the command line "bin\mysqld --console"...my firewall alerted me that it was trying to access a DNS...i clicked 'block this action', and then the command line shot me an error:

can't start server: Bind on TCP/IP port: No error
050306 [error] Do you already have another mysqld server running on port3306?
050306 [error] Aborting
050306 [note] bin\mysqld: Shutdown complete

and that's where i am.

now when i run it again, there is no prompt and it just gives me the error.

any idea of what to do?

- g

 

[chris13]

your operating system is windows?

don't know exactly, but I think your firewall does not pop up again because it has already buld a permanent rule to block this action. Delete this rule (mysqld -> DNS) and it should prompt again.

seems like mysqld wants to query dns for the name of the ip on which it is going to listen for clients.
OR you gave him a name (localhost?) to bind to and now it wants to query dns for the ip...

- configure it to bind to 127.0.0.1
- make apropriate entry (127.0.0.1 localhost) in the hosts-file (it's in \winnt\system32\drivers\etc)
- make windows query the hosts-file at first before querying the DNS