Updating MySQL Server with MySQL Windows Installer

Posted by in MySQL

I laready wrote how to update MySQL version (here you have a compilation list of entrances related to MySQL of this blog). Today’s entrance would like to show you how to update from MySQL 5.6.15 to version 5.6.21 (november 2014).

Version inicial de MySQL

Initial MySQL version

The aspect of MySQL Windows Installer has changed, with this presentation:

MySQL Windows Installer

MySQL Windows Installer

Clic on Next, and check all products you want to update!

MySQL Windows Installer

MySQL Windows Installer

The next step is a compilation of actions that it will take place when installing:

MySQL Windows Installer

MySQL Windows Installer

Clic on Execute to proceed (the interrogants are due becuase I don’t have an Internet connection when writting this tutorial).

MySQL Windows Installer

MySQL Windows Installer

One finished, let’s configure the MySQL server (what you are interested in!):

MySQL Windows Installer

MySQL Windows Installer

First, you need to write the root password, not a new one but the one that is already in the server:

 

MySQL Windows Installer

MySQL Windows Installer

Once a connection is succesful, everything is ready to update:

MySQL Windows Installer

MySQL Windows Installer

and … Execute:

 

MySQL Windows Installer

MySQL Windows Installer

And … that’s all. In my case, I don’t have Desktop link, and that’s the reason for a fail in this item.

Let’s verify the new MySQL version after the update, executing the initial SQL query:

MySQL 5.6.21

MySQL 5.6.21

Yes, the server is updated!. In my opinion, this process is very transparent to users, and very easy, as you can see!.

At the ned, you can verify all inside MySQL Installer:

MySQL Installer

MySQL Installer

From here, you can manage to add, update, delete, … new products. All from a single place!

Install MySQL for Excel

And the second part of this entrance is for installing MySQL for Excel, that you can download here (I did it previously): http://www.mysql.com/why-mysql/windows/excel/.

MySQL for Excel

MySQL for Excel

After the welcome window, you will be ask for the path where MySQL for Excel will be installed (if you already have MySQL for Excel installed, it’s compulsory for you to unistall it first, or the installation will give you an error!):

MySQL for Excel

MySQL for Excel

And .. ready to go:

MySQL for Excel

MySQL for Excel

Clic on Install, and … done!

MySQL for Excel

MySQL for Excel

In the next entrance I write about using MySQL for Excel.

Have a nice day, waiting that today’s entrance can be helpful for you!