MySQL Bugs: #114852: 8.4 Cannot connect to 8.3 server to perform upgrade

Bug #114852	8.4 Cannot connect to 8.3 server to perform upgrade
Submitted:	2 May 2024 11:02	Modified:	28 Mar 19:39
Reporter:	Anthony Marston	Email Updates:
Status:	Analyzing	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	8.4	OS:	Windows (10)
Assigned to:		CPU Architecture:	Any

Description:
After installing server version 8.4 I cannot upgrade my existing 8.3 instance as I cannot get past the first screen which tells me that my root password is not correct.

How to repeat:
Have a running instance of 8.3 using PCP/IP on port 3306.
Install server version 8.4.
Run 8.4 configurator.
On the first screen enter the password for user 'root' and press 'connect'.
This will show the details of the 8.3 instance which will be replaced, but with a red 'X', and the 'Next' button will not be available.

Suggested fix:
Find out why it cannot connect to the existing instance. The password is correct as I use the same one with my client program HeidiSQL.

Hello Anthony Marston,

Thank you for the bug report.
I tried to reproduce your issue on windows 11 with MySQL Configurator 8.4 with running MySQL Server 8.3 but I am not seeing any issues at my end. Please see the screenshot attached.

Regards,
Ashwini Patil

8.4 test results

Attachment: 114852_test_results.png (image/png, text), 265.63 KiB.

The difference is that all your directories are the default ones on the C: drive whereas my directories are on different drives, specifically:

Install directory: E:\Program Files\MySQL\MySQL Server 8.3 
Data directory: F:\MySQL\MySQL Server 8.3

Can your software work with those different directories?

Thank you Anthony, setting bug status to analyzing.

Hello Anthony,
May I know if you are using any kind of special characters or spaces in your password? No need to disclose your password of course. I believe it can also be related to the password not being set correctly internally.

Will also look into using custom directories. As far as I can see you have your data directory in a different drive correct?

Regards.

Yes, I have the data directory on a different drive.

No, I do not have any special characters in the password. It is plain ASCII.