RE: cannot start mysql - error 1067 (also after de- and -re-installation)

[Armando]

If you can't access the mysql server on the local machine, then Gerald
is right, it's a Norton problem guaranteed and the only way you can fix
it is to allow port 3306 (which in the case of Norton may also possibly
allow access to your mysql server from outside your machine as well). In
my opinion, I'm guessing that Norton's Internet Security is like a
'dummy' firewall (no offense to you) which prevents connections to a
machine, even if the connection request originates from the same machine
it's installed on. I'm not overly familiar with the product (simply
because I refuse to run most Norton products on my machines), but I am
guessing it is one of these typical off-the-shelf 'Install Me and I will
protect your machine, even from you' software packages ... Sure it might
be OK for your typical home user, but in my experience it often hinders
more experienced users.

To expand on Gerald's comments, port 3306 should really only need to be
opened on a firewall/gateway/etc. when a remote machine needs to access
your mysql server. On the local machine, it shouldn't matter. My network
is behind one of those basic SOHO routers which performs NAT. So by
default it blocks all incoming connections to all ports except for the
ones I specify in the configuration. Port 3306 is not one of them, so
while I am still able to work with mysql locally, machines outside of my
network (ie; anyone on the internet) cannot connect to it.

Armando

-----Original Message-----
From: Gerald Jensen [mailto:gjensen@stripped] 
Sent: Friday, January 02, 2004 7:47 AM
To: 'Daniel Leibacher'; win32@stripped
Subject: RE: cannot start mysql - error 1067 (also after de- and
-re-installation)


Sounds like a Norton problem ... has nothing to do with MySQL.

Hint: MySQL (by default) needs port 3306 open on any firewall, gateway,
etc.

-----Original Message-----
From: Daniel Leibacher [mailto:daniel.leibacher@stripped]
Sent: Friday, January 02, 2004 6:47 AM
To: Gerald R. Jensen; win32@stripped
Subject: AW: cannot start mysql - error 1067 (also after de- and
-re-installation)


The problem was the Norton Internet Security (Firewall) that hindered me
from connecting with the local server. When I de-activate the Firewall I
can properly work with the MYSQL server.

Now the big question is how can I have the Firewall running using the
MYSQL server?

Daniel

-----Ursprüngliche Nachricht-----
Von: Gerald R. Jensen [mailto:gjensen@stripped]
Gesendet: Donnerstag, 1. Januar 2004 00:44
An: Daniel Leibacher; win32@stripped
Betreff: Re: cannot start mysql - error 1067 (also after de- and
-re-installation)


Did you create a my.ini file and put it in your c:\windows directory?

----- Original Message -----
From: "Daniel Leibacher" <daniel.leibacher@stripped>
To: <win32@stripped>
Sent: Wednesday, December 31, 2003 1:31 PM
Subject: cannot start mysql - error 1067 (also after de-
and -re-installation)


Description:

I cannot start mysqld-nt in any way. I first tried using a service to
start the server but -> error 1067. I also tried to directly start the
server from where it's located. It does not start. I installed MySQL in
the proposed location c:\mysql.

Can you please help. Thank you!! Daniel

How-To-Repeat:
<code/input/activities to reproduce the problem (multiple lines)>

Fix:
<how to correct or work around the problem, if known (multiple lines)>

Synopsis: <synopsis of the problem (one line)>
Submitter-Id: <submitter ID>
Originator: Daniel
Organization:
MySQL support:  none
Severity: serious
Priority: high
Category: mysqld,
Class: [ sw-bug | doc-bug | change-request | support ]
Release: mysql-4.0.17 win

Exectutable:   mysqld-nt
Environment:   PC
System:        WinXP
Compiler:      VC++ 6.0
Architecture:  i



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=1








-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=1