Updating MySQL Server with MySQL Windows Installer

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

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

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

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

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

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

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

 

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

and … Execute:

 

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:

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:

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

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!):

And .. ready to go:

Clic on Install, and … done!

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!