Upgrading the MySQL Community Server 


MySQL.png apg

In this part of this tutorial we will teach you how to upgrade MySQL Community Server on port 3306.

Before starting this operation, it is necessary to close all open terminals, especially the MySQL Community Server on port 3306.


 H:/ 


Remember that

H:/Apache64

Folder for the Apache Server running on port 80
and

H:/MySQL8

Folder for the MySQL Community Server
and

H:/php7-64

Folder for the PHP Hypertext Processor version 7.4.XX
and

H:/WEB

Folder for the localhost



 H:/ 

Open the folder:

H:/MySQL8

my31.png apb

H:/MySQL8

Rename the folders:

H:/MySQL8/mysql

to

H:/MySQL8/mysqlold

and make a copy of

H:/MySQL8/mydata

to

H:/MySQL8/mydata - Copy


 H:/MySQL8 

The configuration of the folder after these interventions should be:

my32.png apb

Such interventions are necessary to revert any possible error in the update, allowing, therefore, to return to the previous installation.


 H:/WEB/temp/mysql-8.0.XX-winx64.zip 

Unzip:

H:/WEB/temp/mysql-8.0.XX-winx64.zip

to

H:/MySQL8

my33.png apb


This folder contains 9 items.


 H:/MySQL8 

After the unzip:

my34.png apb


 H:/MySQL8/mysql-8.0.XX-win64 

Rename the highlighted folder to:

H:/MySQL8/mysql

my35.png apb

This folder now contains 10 items.


 H:/MySQL8 

Copy the highlighted file:
( CTRL+C )

my.ini

into

H:/MySQL8/mysqlold

my36.png apb

This folder contains 8 items.


 H:/MySQL8 

Open the folder:

H:/MySQL8/mysql

my37.png apb

This folder contains 7 items.


 H:/MySQL8 

Paste the file:
( CTRL+V )

my.ini

to

H:/MySQL8/mysql

my38.png apb

This folder now contains 8 items.

Here we finish the MySQL update, so let's test it to see if it is correct.


All folders, then opened, can be closed.


 Desktop -> mysqld.exe - Shortcut 

Double-click the
mysqld.exe - Shortcut
to open the terminal of
MySQL Community Server:

my39.png apb


 MySQL Community Server 

When running the MySQL Community Server for the first time, right after an update, if everything goes according to plan, a message about the update in progress is issued on the terminal.

Observe therefore.

Please be patient until the update is complete.

my40.png apb


 MySQL Community Server 

In the other times when the MySQL Community Server terminal everything will be shown as default.

Observe therefore.

my41.png apb


 Running the MySQL Community Server 


The MySQL Community Server on port 3306 is ready to run.

Installing the PHP 8.0.XX