Error 2013 when running Configuration Wizard

am 17.07.2007 21:54:44 von Jimmy Wu

------=_Part_79789_9820846.1184702084006
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi

I am having a problem with installing MySQL 5.0 Community Edition on a
Windows XP Professional laptop.
The install program itself works, but the configuration wizard that comes up
afterwards doesn't.

In the wizard, I choose all the default settings, and everything goes fine
until the very last window, when it's time to "execute" the settings. On
the very last step, "Apply Security Settings", the configuration fails, and
a window pops up that tells me Error 2013: Lost connection to the MySQL
server during query. That is followed by a message telling me to open port
3306 for access on my firewall.

I don't think the firewall is the problem. I have granted MySQL unlimited
inbound and outbound access. I have even tried turning the firewall off,
but the configuration won't even work then. BTW, I use Symantec's Client
Firewall and Antivirus.

I have searched the MySQL documentation and their online forums to little
avail. It seems many other people have this same problem, but no one knows
how to fix it. A few have gotten a working system after un-/re-installing,
but I have done that multiple times with both the essential and the complete
packages, and the configuration still won't work.

I really have no idea what to do now, and I would appreciate any help on
this.

Thanks,

Jimmy

------=_Part_79789_9820846.1184702084006--

Error 2013 when running Configuration Wizard

am 17.07.2007 22:23:00 von Jimmy Wu

------=_Part_80033_8213437.1184703780401
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi

I am having a problem with installing MySQL 5.0 Community Edition on a
Windows XP Professional laptop.
The install program itself works, but the configuration wizard that comes up
afterwards doesn't.

In the wizard, I choose all the default settings, and everything goes fine
until the very last window, when it's time to "execute" the settings. On
the very last step, "Apply Security Settings", the configuration fails, and
a window pops up that tells me Error 2013: Lost connection to the MySQL
server during query. That is followed by a message telling me to open port
3306 for access on my firewall.

I don't think the firewall is the problem. I have granted MySQL unlimited
inbound and outbound access. I have even tried turning the firewall off,
but the configuration won't even work then. BTW, I use Symantec's Client
Firewall and Antivirus.

I have searched the MySQL documentation and their online forums to little
avail. It seems many other people have this same problem, but no one knows
how to fix it. A few have gotten a working system after un-/re-installing,
but I have done that multiple times with both the essential and the complete
packages, and the configuration still won't work.

I really have no idea what to do now, and I would appreciate any help on
this.

Thanks,

Jimmy

------=_Part_80033_8213437.1184703780401--

Re: Error 2013 when running Configuration Wizard

am 18.07.2007 03:06:49 von Jimmy Wu

------=_Part_82653_7635969.1184720809799
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 7/17/07, Lucretia wrote:
>
> Jimmy,
>
> This is a seriously over-requested question. I'm not buying your
> comment about not finding anyone else with your problem.

What I said was that everyone seems to be complaining about this problem,
and no one know how to fix it. I can't tell you how many unfinished threads
I've found where people would post this problem, but no one would answer.

RTFM on how to 'manually' setup mysql. It's really not that hard.
>
> Cheers,
>
> L.

I've followed the manual setup instructions, and have mysql installed in
C:\mysql
running mysqld --console gives me what seems to be normal output similar to
that in the manual, but the program freezes on me - it stops responding and
the only thing I can do is force quit the command prompt.

On Tue, 2007-07-17 at 15:54 -0400, Jimmy Wu wrote:
> > Hi
> >
> > I am having a problem with installing MySQL 5.0 Community Edition on a
> > Windows XP Professional laptop.
> > The install program itself works, but the configuration wizard that
> comes up
> > afterwards doesn't.
> >
> > In the wizard, I choose all the default settings, and everything goes
> fine
> > until the very last window, when it's time to "execute" the
> settings. On
> > the very last step, "Apply Security Settings", the configuration fails,
> and
> > a window pops up that tells me Error 2013: Lost connection to the MySQL
> > server during query. That is followed by a message telling me to open
> port
> > 3306 for access on my firewall.
> >
> > I don't think the firewall is the problem. I have granted MySQL
> unlimited
> > inbound and outbound access. I have even tried turning the firewall
> off,
> > but the configuration won't even work then. BTW, I use Symantec's
> Client
> > Firewall and Antivirus.
> >
> > I have searched the MySQL documentation and their online forums to
> little
> > avail. It seems many other people have this same problem, but no one
> knows
> > how to fix it. A few have gotten a working system after
> un-/re-installing,
> > but I have done that multiple times with both the essential and the
> complete
> > packages, and the configuration still won't work.
> >
> > I really have no idea what to do now, and I would appreciate any help on
> > this.
> >
> > Thanks,
> >
> > Jimmy
>
>

------=_Part_82653_7635969.1184720809799--

Fwd: Error 2013 when running Configuration Wizard

am 18.07.2007 03:13:13 von Jimmy Wu

------=_Part_82745_1869193.1184721193279
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

---------- Forwarded message ----------
From: Jimmy Wu
Date: Jul 17, 2007 9:06 PM
Subject: Re: Error 2013 when running Configuration Wizard
To: Lucretia , mysql bugs list ,
mysql win32 list

On 7/17/07, Lucretia wrote:
>
> Jimmy,
>
> This is a seriously over-requested question. I'm not buying your
> comment about not finding anyone else with your problem.

What I said was that everyone seems to be complaining about this problem,
and no one know how to fix it. I can't tell you how many unfinished threads
I've found where people would post this problem, but no one would answer.

RTFM on how to 'manually' setup mysql. It's really not that hard.
>
> Cheers,
>
> L.

I've followed the manual setup instructions, and have mysql installed in
C:\mysql
running mysqld --console gives me what seems to be normal output similar to
that in the manual, but the program freezes on me - it stops responding and
the only thing I can do is force quit the command prompt.

On Tue, 2007-07-17 at 15:54 -0400, Jimmy Wu wrote:
> > Hi
> >
> > I am having a problem with installing MySQL 5.0 Community Edition on a
> > Windows XP Professional laptop.
> > The install program itself works, but the configuration wizard that
> comes up
> > afterwards doesn't.
> >
> > In the wizard, I choose all the default settings, and everything goes
> fine
> > until the very last window, when it's time to "execute" the
> settings. On
> > the very last step, "Apply Security Settings", the configuration fails,
> and
> > a window pops up that tells me Error 2013: Lost connection to the MySQL
> > server during query. That is followed by a message telling me to open
> port
> > 3306 for access on my firewall.
> >
> > I don't think the firewall is the problem. I have granted MySQL
> unlimited
> > inbound and outbound access. I have even tried turning the firewall
> off,
> > but the configuration won't even work then. BTW, I use Symantec's
> Client
> > Firewall and Antivirus.
> >
> > I have searched the MySQL documentation and their online forums to
> little
> > avail. It seems many other people have this same problem, but no one
> knows
> > how to fix it. A few have gotten a working system after
> un-/re-installing,
> > but I have done that multiple times with both the essential and the
> complete
> > packages, and the configuration still won't work.
> >
> > I really have no idea what to do now, and I would appreciate any help on
> > this.
> >
> > Thanks,
> >
> > Jimmy
>
>

------=_Part_82745_1869193.1184721193279--

Re: Fwd: Error 2013 when running Configuration Wizard

am 18.07.2007 05:42:56 von Shawn Green

Hi Jimmy,

Jimmy Wu wrote:
>
> I've followed the manual setup instructions, and have mysql installed in
> C:\mysql
> running mysqld --console gives me what seems to be normal output
> similar to
> that in the manual, but the program freezes on me - it stops
> responding and
> the only thing I can do is force quit the command prompt.
>
>
What is happening is not a freeze.

If the server has nothing to log, you will see nothing appear in the
screen. The reason you do not get a prompt back after issuing a mysqld
--console command is precisely because the server *is still running*.
The prompt won't reappear until after you stop the server.

Start a second command prompt and issue the following command to start
an interactive mysql session using the Command Line Interface (the MySQL
CLI)

shell>mysql -u root

To end your session, type

mysql> exit

and you will be back at the command line prompt. To get your server to
stop (and restore interactive access to your first screen) you should
issue the following command:

shell> mysqladmin -u root shutdown

To learn more about the utilities "mysql" and "mysqladmin" please read
the following sections in the manual
http://dev.mysql.com/doc/refman/5.0/en/mysql.html
http://dev.mysql.com/doc/refman/5.0/en/mysqladmin.html

and for a walkthough tutorial, please refer to chapter 3
http://dev.mysql.com/doc/refman/5.0/en/connecting-disconnect ing.html

Kindly yours,

--
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /
/ /|_/ / // /\ \/ /_/ / /__
/_/ /_/\_, /___/\___\_\___/
<___/
Join the Quality Contribution Program Today!
http://dev.mysql.com/qualitycontribution.html

--
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: Fwd: Error 2013 when running Configuration Wizard

am 18.07.2007 15:16:23 von Jimmy Wu

------=_Part_89492_22612274.1184764583363
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Thanks for the help.
There's still a problem though:
I started another command prompt, typed mysql -u root, and it gave me
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial
communication packet', system error: 2
If I turn my firewall off, it works though.
The thing is, I don't want to have to turn off my firewall to use mysql. I
have Symantec, and MySQL is in the list of programs to allow. I didn't find
an option to open specific ports.
If anyone has experience with Symantec and knows what to do, that would be
great.

Thanks

Jimmy

On 7/17/07, Shawn Green wrote:
>
> Hi Jimmy,
>
> Jimmy Wu wrote:
> >
> > I've followed the manual setup instructions, and have mysql installed in
> > C:\mysql
> > running mysqld --console gives me what seems to be normal output
> > similar to
> > that in the manual, but the program freezes on me - it stops
> > responding and
> > the only thing I can do is force quit the command prompt.
> >
> >
> What is happening is not a freeze.
>
> If the server has nothing to log, you will see nothing appear in the
> screen. The reason you do not get a prompt back after issuing a mysqld
> --console command is precisely because the server *is still running*.
> The prompt won't reappear until after you stop the server.
>
> Start a second command prompt and issue the following command to start
> an interactive mysql session using the Command Line Interface (the MySQL
> CLI)
>
> shell>mysql -u root
>
> To end your session, type
>
> mysql> exit
>
> and you will be back at the command line prompt. To get your server to
> stop (and restore interactive access to your first screen) you should
> issue the following command:
>
> shell> mysqladmin -u root shutdown
>
> To learn more about the utilities "mysql" and "mysqladmin" please read
> the following sections in the manual
> http://dev.mysql.com/doc/refman/5.0/en/mysql.html
> http://dev.mysql.com/doc/refman/5.0/en/mysqladmin.html
>
> and for a walkthough tutorial, please refer to chapter 3
> http://dev.mysql.com/doc/refman/5.0/en/connecting-disconnect ing.html
>
> Kindly yours,
>
> --
> Shawn Green, Support Engineer
> MySQL Inc., USA, www.mysql.com
> Office: Blountville, TN
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ /
> / /|_/ / // /\ \/ /_/ / /__
> /_/ /_/\_, /___/\___\_\___/
> <___/
> Join the Quality Contribution Program Today!
> http://dev.mysql.com/qualitycontribution.html
>
>

------=_Part_89492_22612274.1184764583363--

Re: Fwd: Error 2013 when running Configuration Wizard

am 18.07.2007 15:16:23 von Jimmy Wu