Upgrading failure - Error Nr. 2003

#1

Hi all,

Yesterday I tried to make an upgrading from MySQL 5.1.53 to MySQL 5.5.8
On a machine that runs under Windows XP. I did this:

1) I stopped the server with

mysqladmin -u root -p shutdown

2) I ran the MySQL Server Instance Config Wizard and then I chose Remove
Instance.

3) I deleted the directories

C:\Program Files\MySQL

and

C:\Documents and Settings\All users\Application Data\MySQL

4) I uninstalled MySQL using the "Add and remove programs" utility.

5) I deleted from the registry all references to MySQL.

(If this seems a bit radical to you, I must add that this was *not* my
first approach.)

Then, after installing MySQL 5.5.8 and after configuring the server, I
got this message:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
The security settings could not be applied to the database because the
connection has failed with the following error.

Error Nr. 2003
Can't connect to MySQL server on 'localhost' (10061)

If a personal firewall is running on your machine, please make sure you
have opened the TCP port 3306 for connections. Otherwise no client
application can connect to the server. After you have opened the port
please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server
please note that the data directory was not removed automatically.
Therefore the old password from your last installation is still needed
to connect to the server. In this case please select skip now and
re-run the Configuration Wizard from the start menu.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

What is causing this? After several failed attempts, I tried to install
MySQL 5.1.54 and all went well, but I want to be able to upgrade to
MySQL 5.5.

Best regards,

Jose Carlos Santos

#2

On 12/17/2010 4:42 AM, José Carlos Santos wrote:

Quote:

Hi all,

Yesterday I tried to make an upgrading from MySQL 5.1.53 to MySQL 5.5.8
On a machine that runs under Windows XP. I did this:

1) I stopped the server with

mysqladmin -u root -p shutdown

2) I ran the MySQL Server Instance Config Wizard and then I chose Remove
Instance.

3) I deleted the directories

C:\Program Files\MySQL

and

C:\Documents and Settings\All users\Application Data\MySQL

4) I uninstalled MySQL using the "Add and remove programs" utility.

5) I deleted from the registry all references to MySQL.

(If this seems a bit radical to you, I must add that this was *not* my
first approach.)

Then, after installing MySQL 5.5.8 and after configuring the server, I
got this message:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
The security settings could not be applied to the database because the
connection has failed with the following error.

Error Nr. 2003
Can't connect to MySQL server on 'localhost' (10061)

If a personal firewall is running on your machine, please make sure you
have opened the TCP port 3306 for connections. Otherwise no client
application can connect to the server. After you have opened the port
please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server
please note that the data directory was not removed automatically.
Therefore the old password from your last installation is still needed
to connect to the server. In this case please select skip now and
re-run the Configuration Wizard from the start menu.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

What is causing this? After several failed attempts, I tried to install
MySQL 5.1.54 and all went well, but I want to be able to upgrade to
MySQL 5.5.

Best regards,

Jose Carlos Santos

Is the MySQL server running? Is your MySQL configuration correct?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#3

On 17-12-2010 12:35, Jerry Stuckle wrote:

Quote:

Yesterday I tried to make an upgrading from MySQL 5.1.53 to MySQL 5.5.8
On a machine that runs under Windows XP. I did this:

1) I stopped the server with

mysqladmin -u root -p shutdown

2) I ran the MySQL Server Instance Config Wizard and then I chose Remove
Instance.

3) I deleted the directories

C:\Program Files\MySQL

and

C:\Documents and Settings\All users\Application Data\MySQL

4) I uninstalled MySQL using the "Add and remove programs" utility.

5) I deleted from the registry all references to MySQL.

(If this seems a bit radical to you, I must add that this was *not* my
first approach.)

Then, after installing MySQL 5.5.8 and after configuring the server, I
got this message:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
The security settings could not be applied to the database because the
connection has failed with the following error.

Error Nr. 2003
Can't connect to MySQL server on 'localhost' (10061)

If a personal firewall is running on your machine, please make sure you
have opened the TCP port 3306 for connections. Otherwise no client
application can connect to the server. After you have opened the port
please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server
please note that the data directory was not removed automatically.
Therefore the old password from your last installation is still needed
to connect to the server. In this case please select skip now and
re-run the Configuration Wizard from the start menu.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

What is causing this? After several failed attempts, I tried to install
MySQL 5.1.54 and all went well, but I want to be able to upgrade to
MySQL 5.5.

Is the MySQL server running?

Well, I did not check it, but given my first four steps that seems very
much unlikely, to say the least.

Quote:

Is your MySQL configuration correct?

I used the same MySQL configuration that I had used for MySQL 5.1.43.
And when I installed version 5.1.44 I used again the same configuration
and, like I said, all went fine.

Best regards,

Jose Carlos Santos

#4

On 12/17/2010 8:47 AM, José Carlos Santos wrote:

Quote:

On 17-12-2010 12:35, Jerry Stuckle wrote:

Yesterday I tried to make an upgrading from MySQL 5.1.53 to MySQL 5.5.8
On a machine that runs under Windows XP. I did this:

1) I stopped the server with

mysqladmin -u root -p shutdown

2) I ran the MySQL Server Instance Config Wizard and then I chose Remove
Instance.

3) I deleted the directories

C:\Program Files\MySQL

and

C:\Documents and Settings\All users\Application Data\MySQL

4) I uninstalled MySQL using the "Add and remove programs" utility.

5) I deleted from the registry all references to MySQL.

(If this seems a bit radical to you, I must add that this was *not* my
first approach.)

Then, after installing MySQL 5.5.8 and after configuring the server, I
got this message:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
The security settings could not be applied to the database because the
connection has failed with the following error.

Error Nr. 2003
Can't connect to MySQL server on 'localhost' (10061)

If a personal firewall is running on your machine, please make sure you
have opened the TCP port 3306 for connections. Otherwise no client
application can connect to the server. After you have opened the port
please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server
please note that the data directory was not removed automatically.
Therefore the old password from your last installation is still needed
to connect to the server. In this case please select skip now and
re-run the Configuration Wizard from the start menu.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

What is causing this? After several failed attempts, I tried to install
MySQL 5.1.54 and all went well, but I want to be able to upgrade to
MySQL 5.5.

Is the MySQL server running?

Well, I did not check it, but given my first four steps that seems very
much unlikely, to say the least.

Given your message, it seems to be very likely.

Quote:

Is your MySQL configuration correct?

I used the same MySQL configuration that I had used for MySQL 5.1.43.
And when I installed version 5.1.44 I used again the same configuration
and, like I said, all went fine.

Best regards,

Jose Carlos Santos

Did you check the docs for changes in configuration between the releases?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#5

On 17-12-2010 14:14, Jerry Stuckle wrote:

Quote:

Yesterday I tried to make an upgrading from MySQL 5.1.53 to MySQL 5.5.8
On a machine that runs under Windows XP. I did this:

1) I stopped the server with

mysqladmin -u root -p shutdown

2) I ran the MySQL Server Instance Config Wizard and then I chose
Remove
Instance.

3) I deleted the directories

C:\Program Files\MySQL

and

C:\Documents and Settings\All users\Application Data\MySQL

4) I uninstalled MySQL using the "Add and remove programs" utility.

5) I deleted from the registry all references to MySQL.

(If this seems a bit radical to you, I must add that this was *not* my
first approach.)

Then, after installing MySQL 5.5.8 and after configuring the server, I
got this message:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
The security settings could not be applied to the database because the
connection has failed with the following error.

Error Nr. 2003
Can't connect to MySQL server on 'localhost' (10061)

If a personal firewall is running on your machine, please make sure you
have opened the TCP port 3306 for connections. Otherwise no client
application can connect to the server. After you have opened the port
please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server
please note that the data directory was not removed automatically.
Therefore the old password from your last installation is still needed
to connect to the server. In this case please select skip now and
re-run the Configuration Wizard from the start menu.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

What is causing this? After several failed attempts, I tried to install
MySQL 5.1.54 and all went well, but I want to be able to upgrade to
MySQL 5.5.

Is the MySQL server running?

Well, I did not check it, but given my first four steps that seems very
much unlikely, to say the least.

Given your message, it seems to be very likely.

I did everything once again. And this time I ran Task Manager after
step 4). And, no, the MySQL server was not running. And I got the same
error once again while trying to install version 5.5.8. And, again, all
went well when I re-installed version 5.1.54. But I really fail to
understand how could you think that, after steps 1) to 4), MySQL might
still be running.

Quote:

Is your MySQL configuration correct?

I used the same MySQL configuration that I had used for MySQL 5.1.43.
And when I installed version 5.1.44 I used again the same configuration
and, like I said, all went fine.

Did you check the docs for changes in configuration between the releases?

Yes, I did.

Best regards,

Jose Carlos Santos

#6

On 12/17/2010 6:18 PM, José Carlos Santos wrote:

Quote:

On 17-12-2010 14:14, Jerry Stuckle wrote:

Yesterday I tried to make an upgrading from MySQL 5.1.53 to MySQL
5.5.8
On a machine that runs under Windows XP. I did this:

1) I stopped the server with

mysqladmin -u root -p shutdown

2) I ran the MySQL Server Instance Config Wizard and then I chose
Remove
Instance.

3) I deleted the directories

C:\Program Files\MySQL

and

C:\Documents and Settings\All users\Application Data\MySQL

4) I uninstalled MySQL using the "Add and remove programs" utility.

5) I deleted from the registry all references to MySQL.

(If this seems a bit radical to you, I must add that this was *not* my
first approach.)

Then, after installing MySQL 5.5.8 and after configuring the server, I
got this message:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
The security settings could not be applied to the database because the
connection has failed with the following error.

Error Nr. 2003
Can't connect to MySQL server on 'localhost' (10061)

If a personal firewall is running on your machine, please make sure
you
have opened the TCP port 3306 for connections. Otherwise no client
application can connect to the server. After you have opened the port
please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server
please note that the data directory was not removed automatically.
Therefore the old password from your last installation is still needed
to connect to the server. In this case please select skip now and
re-run the Configuration Wizard from the start menu.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

What is causing this? After several failed attempts, I tried to
install
MySQL 5.1.54 and all went well, but I want to be able to upgrade to
MySQL 5.5.

Is the MySQL server running?

Well, I did not check it, but given my first four steps that seems very
much unlikely, to say the least.

Given your message, it seems to be very likely.

I did everything once again. And this time I ran Task Manager after
step 4). And, no, the MySQL server was not running. And I got the same
error once again while trying to install version 5.5.8. And, again, all
went well when I re-installed version 5.1.54. But I really fail to
understand how could you think that, after steps 1) to 4), MySQL might
still be running.

I never said anything about the old version still being running. I said
the new version is not running. And you just confirmed it was not - as
the message indicated.

So you need to find out why the new version isn't running. Did you try
to start it? What's your mysql error log show?

Quote:

Is your MySQL configuration correct?

I used the same MySQL configuration that I had used for MySQL 5.1.43.
And when I installed version 5.1.44 I used again the same configuration
and, like I said, all went fine.

Did you check the docs for changes in configuration between the releases?

Yes, I did.

Best regards,

Jose Carlos Santos

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#7

On 12/17/2010 6:18 PM, José Carlos Santos wrote:

Quote:

On 17-12-2010 14:14, Jerry Stuckle wrote:

Yesterday I tried to make an upgrading from MySQL 5.1.53 to MySQL
5.5.8
On a machine that runs under Windows XP. I did this:

1) I stopped the server with

mysqladmin -u root -p shutdown

2) I ran the MySQL Server Instance Config Wizard and then I chose
Remove
Instance.

3) I deleted the directories

C:\Program Files\MySQL

and

C:\Documents and Settings\All users\Application Data\MySQL

4) I uninstalled MySQL using the "Add and remove programs" utility.

5) I deleted from the registry all references to MySQL.

(If this seems a bit radical to you, I must add that this was *not* my
first approach.)

Then, after installing MySQL 5.5.8 and after configuring the server, I
got this message:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
The security settings could not be applied to the database because the
connection has failed with the following error.

Error Nr. 2003
Can't connect to MySQL server on 'localhost' (10061)

If a personal firewall is running on your machine, please make sure
you
have opened the TCP port 3306 for connections. Otherwise no client
application can connect to the server. After you have opened the port
please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server
please note that the data directory was not removed automatically.
Therefore the old password from your last installation is still needed
to connect to the server. In this case please select skip now and
re-run the Configuration Wizard from the start menu.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

What is causing this? After several failed attempts, I tried to
install
MySQL 5.1.54 and all went well, but I want to be able to upgrade to
MySQL 5.5.

Is the MySQL server running?

Well, I did not check it, but given my first four steps that seems very
much unlikely, to say the least.

Given your message, it seems to be very likely.

I did everything once again. And this time I ran Task Manager after
step 4). And, no, the MySQL server was not running. And I got the same
error once again while trying to install version 5.5.8. And, again, all
went well when I re-installed version 5.1.54. But I really fail to
understand how could you think that, after steps 1) to 4), MySQL might
still be running.

Is your MySQL configuration correct?

I used the same MySQL configuration that I had used for MySQL 5.1.43.
And when I installed version 5.1.44 I used again the same configuration
and, like I said, all went fine.

Did you check the docs for changes in configuration between the releases?

Yes, I did.

Best regards,

Jose Carlos Santos

I just installed MySQL 5.5.8, using the configuration which came with
the version. After modifying it to match my current data directory,
innodb lo file size and so on, it came up and worked just fine.

So you need to check your MySQL log to see what errors you are getting.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#8

On 18-12-2010 0:50, Jerry Stuckle wrote:

Quote:

I did everything once again. And this time I ran Task Manager after
step 4). And, no, the MySQL server was not running. And I got the same
error once again while trying to install version 5.5.8. And, again, all
went well when I re-installed version 5.1.54. But I really fail to
understand how could you think that, after steps 1) to 4), MySQL might
still be running.

I never said anything about the old version still being running. I said
the new version is not running. And you just confirmed it was not - as
the message indicated.

So you need to find out why the new version isn't running. Did you try
to start it? What's your mysql error log show?

Do you mean the file notebook.err?

Best regards,

Jose Carlos Santos

#9

On 18-12-2010 7:52, José Carlos Santos wrote:

Quote:

I did everything once again. And this time I ran Task Manager after
step 4). And, no, the MySQL server was not running. And I got the same
error once again while trying to install version 5.5.8. And, again, all
went well when I re-installed version 5.1.54. But I really fail to
understand how could you think that, after steps 1) to 4), MySQL might
still be running.

I never said anything about the old version still being running. I said
the new version is not running. And you just confirmed it was not - as
the message indicated.

So you need to find out why the new version isn't running. Did you try
to start it? What's your mysql error log show?

Do you mean the file notebook.err?

Forget the question. The answer is "yes", at least for a machine called
"notebook".

Best regards,

Jose Carlos Santos

#10

On 18-12-2010 0:50, Jerry Stuckle wrote:

Quote:

Is the MySQL server running?

Well, I did not check it, but given my first four steps that seems very
much unlikely, to say the least.

Given your message, it seems to be very likely.

I did everything once again. And this time I ran Task Manager after
step 4). And, no, the MySQL server was not running. And I got the same
error once again while trying to install version 5.5.8. And, again, all
went well when I re-installed version 5.1.54. But I really fail to
understand how could you think that, after steps 1) to 4), MySQL might
still be running.

I never said anything about the old version still being running. I said
the new version is not running. And you just confirmed it was not - as
the message indicated.

So you need to find out why the new version isn't running. Did you try
to start it?

It *is* running. I can work with it using the mysql shell. But I am
unable to set a password.

Quote:

What's your mysql error log show?

The .err file contains this:

101218 8:43:56 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
101218 8:43:58 InnoDB: Initializing buffer pool, size = 8.0M
101218 8:43:58 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
101218 8:43:59 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
101218 8:44:00 InnoDB: Log file .\ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
101218 8:44:01 InnoDB: Log file .\ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
101218 8:44:06 InnoDB: 1.1.4 started; log sequence number 0
101218 8:45:01 [Note] Event Scheduler: Loaded 0 events
101218 8:45:01 [Note] C:\Program Files\MySQL\MySQL Server
5.5\bin\mysqld: ready for connections.
Version: '5.5.8' socket: '' port: 3306 MySQL Community Server (GPL)
101218 8:57:04 [Note] C:\Program Files\MySQL\MySQL Server
5.5\bin\mysqld: Normal shutdown

101218 8:57:04 [Note] Event Scheduler: Purging the queue. 0 events
101218 8:57:04 InnoDB: Starting shutdown...
101218 8:57:06 InnoDB: Shutdown completed; log sequence number 3166008
101218 8:57:07 [Note] C:\Program Files\MySQL\MySQL Server
5.5\bin\mysqld: Shutdown complete

101218 8:58:56 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
101218 8:58:56 InnoDB: Initializing buffer pool, size = 8.0M
101218 8:58:56 InnoDB: Completed initialization of buffer pool
101218 8:58:56 InnoDB: highest supported file format is Barracuda.
101218 8:58:57 InnoDB: 1.1.4 started; log sequence number 3166008
101218 8:59:06 [Note] Event Scheduler: Loaded 0 events
101218 8:59:06 [Note] C:\Program Files\MySQL\MySQL Server
5.5\bin\mysqld: ready for connections.
Version: '5.5.8' socket: '' port: 3306 MySQL Community Server (GPL)

Best regards,

Jose Carlos Santos