MySQL Bugs: #92113: Downloaded Installer for Windows Does Not Install Version 8 Community

Bug #92113	Downloaded Installer for Windows Does Not Install Version 8 Community
Submitted:	21 Aug 2018 21:33	Modified:	22 Aug 2018 0:52
Reporter:	Larry Reagor	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Windows	Severity:	S2 (Serious)
Version:	8	OS:	Windows
Assigned to:		CPU Architecture:	x86

Description:
I downloaded the msi installer for Windows version 8.X for the community edition. I have 5.7x. When I ran the installer, it updated all the connectors & workbench, etc. to version 8.x. But the server itself only updated to a newer 5.7. I ran the tool to determine if it would upgrade and received only one non-critical warning. Why does it not upgrade my installation to version 8.x?

How to repeat:
Keep running msi installer.

Thank you for the bug report. This is expected and documented behavior, please read:

https://dev.mysql.com/doc/refman/8.0/en/windows-upgrading.html

Upgrading MySQL with MySQL Installer

--------

"series. MySQL Installer does not support upgrades between release series, such as from 5.7 to 8.0, and it does not provide an upgrade indicator to prompt you to upgrade. For instruction on upgrading between release series, see Upgrading MySQL Using the Windows ZIP Distribution. "

I already tried the zip method. Downloaded it, extracted it. Now what? What do I run? Documentation does not step me through this.

Same page I pointed you, see:

Upgrading MySQL Using the Windows ZIP Distribution

......

Ok, first step: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin" -u root shutdown

Got this response:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

My server is using 3308.

Your first step:

Ok, first step: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin" -u root shutdown

is wrong it's assuming the default port 3306 but yourself pointed is running port 3308, then:

first step: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin" -u root --port=3308 shutdown

also you could open a administrator command prompt and issue:

NET STOP the_service_name

I recommend you to make a backup of the data directory.

So data directory would be all the contents of C:\ProgramData\MySQL\MySQL Server 5.7\Data ? Anything else?

Also, did what you said and got: mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Sorry you need to use root password using -p:

"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin" -u root --port=3308 -p shutdown

and yes that folder you pointed is the data.