MySQL 4.1.14 crashes Windows XP

------=_Part_2862_24024470.1128804757008
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,
I installed MySQL 4.1.14 using the Windows Installer and the installation
wizard. Everything seemed to go ok. I had started to follow some exercises
in a MySQL book of mine to get a sample database up and running. I then
tried to log in as root, my firewall popped up to say that mysql wanted to
connect to the internet, I confirmed this and "Boom!" grey screen of death!
My machine basically just switched off!
I rebooted, checked everything is running (msql service) and tried once
more with the same result.
I realise that I could use the named pipes server which won't want to
access port 3306 but I'd like to figure out what the problem is first. It
could be ZoneAlarm crashing I suppose, not MySQL or something else entirely=
..
Any help would be most appreciated.
Regards,
Jim Herd

------=_Part_2862_24024470.1128804757008--

Re: MySQL 4.1.14 crashes Windows XP

On 10/8/2005 1:52 PM James Herd intelligently wrote:
> Hi,
> I installed MySQL 4.1.14 using the Windows Installer and the installation
> wizard. Everything seemed to go ok. I had started to follow some exercises
> in a MySQL book of mine to get a sample database up and running. I then
> tried to log in as root, my firewall popped up to say that mysql wanted to
> connect to the internet, I confirmed this and "Boom!" grey screen of death!
> My machine basically just switched off!
> I rebooted, checked everything is running (msql service) and tried once
> more with the same result.
> I realise that I could use the named pipes server which won't want to
> access port 3306 but I'd like to figure out what the problem is first. It
> could be ZoneAlarm crashing I suppose, not MySQL or something else entirely.
> Any help would be most appreciated.
> Regards,
> Jim Herd
>

I have both 4.1.14 & 4.0.26 running on Win XP with no problems at all.
I'd check ZoneAlarm...I don't use that, I'm running the Windows
firewall...behind a router firewall. Noone can connect to these
instances of MySQL from the internet (router/firewall) but all intranet
traffic gets in (Windows Firewall).

HTH

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: MySQL 4.1.14 crashes Windows XP

Your best bet would be the firewall causing problems, check it, maybe
allow MySQL manually at the configuration, I don't use those (behind a
router firewall) so can't help you there, check the help for your
firewall software.

On 10/8/05, James Herd wrote:
> Hi,
> I installed MySQL 4.1.14 using the Windows Installer and the installatio=
n
> wizard. Everything seemed to go ok. I had started to follow some exercise=
s
> in a MySQL book of mine to get a sample database up and running. I then
> tried to log in as root, my firewall popped up to say that mysql wanted t=
o
> connect to the internet, I confirmed this and "Boom!" grey screen of deat=
h!
> My machine basically just switched off!
> I rebooted, checked everything is running (msql service) and tried once
> more with the same result.
> I realise that I could use the named pipes server which won't want to
> access port 3306 but I'd like to figure out what the problem is first. It
> could be ZoneAlarm crashing I suppose, not MySQL or something else entire=
ly.
> Any help would be most appreciated.
> Regards,
> Jim Herd
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: MySQL 4.1.14 crashes Windows XP

On 10/8/05, James Herd wrote:
> Hi Daniel,
>
> Thanks for that. I'll have to do something about the firewall perhaps bu=
t I
> think there might be an issue with the windows installer too. It seems t=
o
> fail to retry the connection for some reason. Otherwise, I'd be able to
> enable MySQL, do the retry and continue.

Well, it must be a misunderstanding between the MSI and the firewall
(shouldn't they speak the same language?). The fact is that putting
MySQL to work is a 5 step procedure (IMHO):

1) Get the files and place them somewhere safe on your file system.
2) Configure it using the config file and options.
3) Install it as a service or add it to another startup manager.
4) Start it.
5) Use it.

All five steps are clearly disussed in the Manual, and the fifth can
be anchieved by so many ways that even the foruns and mailing lists
are getting new posts every day. The MSI wizard "skips" (or at least
try) this steps, thus being more trouble than solution (again, MHO).

OK, its been a while since I used the installer, so, can't help you
there... If you think your firewall issues are solved, then you should
try using the command line to remove, reinstall and start the MySQL
service. Use the "cmd" app to do this (I assume your MySQL is
installed at C:\MySQL, change it as necessary):

net stop MySQL
(just in case)
C:\mysql\bin\mysqld --remove
C:\mysql\bin\mysqld --install
net start MySQL

More information can be found at
http://dev.mysql.com/doc/mysql/en/windows-start-service.html I
sincerely advice you to not use the installer, instead download the
Manual and the zipped version and install it "by hand", this way
you'll know exactly what's going on and so you'll be able to fix any
issues quickly.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org