Server rejects connection after installing version 4.1.5

------=_NextPart_000_0007_01C4EC30.302A9960
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I've had version 4.0.18 running for about six months on an XP-pro =
machine, using the apache server. No problems at all.

Today I removed all traces of 4.0.18, downloaded =
mysql-4.1.8-essential-win.msi, and ran it. It appeared to install with =
no problem, and the process was running. But I could not connect. When I =
opened phpMyAdmin, I got a message that the server had rejected the =
connection, and that I should check the user and password, and that =
MySQL had said "1251 client does not support authentication protocol =
requested by server." I checked the ini file and everything else I could =
think of, reran the installation a couple of times, but nothing overcame =
this problem.

So I reinstalled 4.0.18, and things are back to what passes for normal.

Does anybody have any suggestions about what I could have done to get =
4.1.8 up and running?

Thanks.
------=_NextPart_000_0007_01C4EC30.302A9960--

Re: Server rejects connection after installing version 4.1.5

Check the past messages about password issues in version 4.1, we have
many people with that problem, its the only thing that could possibly
mess up your connection (I think). Ah, you should check your service
config as well, and try runnign MySQL Administrator to check if the
service is really running, but I still bet in the password problem.

Version 4.1 and above use a different format for passwords, with a
different type of field in the database, there is a script to convert
your old passwords to the new format at the /scripts folder, if that
doesn't work, well, I guess you'll have to talk to us again with error
logs or so, with more info for us to work. Try running the slow-log
server to see more info at the logs...

Best regards,

On Mon, 27 Dec 2004 16:21:58 -0800, Allan Abrahamse wrote:
> I've had version 4.0.18 running for about six months on an XP-pro machine, using the apache server. No problems at all.
>
> Today I removed all traces of 4.0.18, downloaded mysql-4.1.8-essential-win.msi, and ran it. It appeared to install with no problem, and the process was running. But I could not connect. When I opened phpMyAdmin, I got a message that the server had rejected the connection, and that I should check the user and password, and that MySQL had said "1251 client does not support authentication protocol requested by server." I checked the ini file and everything else I could think of, reran the installation a couple of times, but nothing overcame this problem.
>
> So I reinstalled 4.0.18, and things are back to what passes for normal.
>
> Does anybody have any suggestions about what I could have done to get 4.1.8 up and running?
>
> Thanks.
>

--
Daniel da Veiga
Computer Operator - RS - Brazil

--
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: Server rejects connection after installing version 4.1.5

Download mysql administrator.....load 4.1.8 and log in using the
administrator. Go to startup variables and then security tab. Place a
check to use Old style passwords. Stop and restart server, you should be
ok. I had the same issue when I installed.
Hope that helps.

Sam

-----Original Message-----
From: Allan Abrahamse [mailto:allan@abrahamse.org]
Sent: Monday, December 27, 2004 7:22 PM
To: win32@lists.mysql.com
Subject: Server rejects connection after installing version 4.1.5

I've had version 4.0.18 running for about six months on an XP-pro machine,
using the apache server. No problems at all.

Today I removed all traces of 4.0.18, downloaded
mysql-4.1.8-essential-win.msi, and ran it. It appeared to install with no
problem, and the process was running. But I could not connect. When I opened
phpMyAdmin, I got a message that the server had rejected the connection, and
that I should check the user and password, and that MySQL had said "1251
client does not support authentication protocol requested by server." I
checked the ini file and everything else I could think of, reran the
installation a couple of times, but nothing overcame this problem.

So I reinstalled 4.0.18, and things are back to what passes for normal.

Does anybody have any suggestions about what I could have done to get 4.1.8
up and running?

Thanks.


--
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: Server rejects connection after installing version 4.1.5

Ok, that is a good solution if you have urgency on running a new
version or have just a few predefined users that will always be the
same.

If you use any kind of web based administrator or script to create
users for the database, or if there is an app designed for that, it
creates a lot of trouble, you'll have to use the OLD PASSWORD syntax
on every creation. Its far more simple to convert the entire "users"
table to the new password format as I told in my previous message.

If you are used to server side scripting you know its best to leave
all the work for the server, meaning less runtime conversions...

Best regards,

On Tue, 28 Dec 2004 08:46:28 -0500, Sam DeForest
wrote:
> Download mysql administrator.....load 4.1.8 and log in using the
> administrator. Go to startup variables and then security tab. Place a
> check to use Old style passwords. Stop and restart server, you should be
> ok. I had the same issue when I installed.
> Hope that helps.
>
> Sam
>
> -----Original Message-----
> From: Allan Abrahamse [mailto:allan@abrahamse.org]
> Sent: Monday, December 27, 2004 7:22 PM
> To: win32@lists.mysql.com
> Subject: Server rejects connection after installing version 4.1.5
>
> I've had version 4.0.18 running for about six months on an XP-pro machine,
> using the apache server. No problems at all.
>
> Today I removed all traces of 4.0.18, downloaded
> mysql-4.1.8-essential-win.msi, and ran it. It appeared to install with no
> problem, and the process was running. But I could not connect. When I opened
> phpMyAdmin, I got a message that the server had rejected the connection, and
> that I should check the user and password, and that MySQL had said "1251
> client does not support authentication protocol requested by server." I
> checked the ini file and everything else I could think of, reran the
> installation a couple of times, but nothing overcame this problem.
>
> So I reinstalled 4.0.18, and things are back to what passes for normal.
>
> Does anybody have any suggestions about what I could have done to get 4.1.8
> up and running?
>
> Thanks.
>

--
Daniel da Veiga
Computer Operator - RS - Brazil

--
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