Moving from MySQL 5.5 to 5.6. Step 4: Starting with MySQL 5.6.10

Posted by in MySQL

On previous post, I already wrote about how to create a database backup, how to unistall a MySQL version, ad how to install a new MySQL version, in this case, MySQL 5.6.10.

If you are new to MySQL, you can think … “Well,  I have installed MySQL server, now .. what can I do?“.

Starting MySQL

Alghouth you won’t belive me, that’s the question I made myself the first time I installed MySQL server. Next is valid for all MySQL versions.

If you go to Start / Programs / MySQL / MySQL 5.6 Server / MySQL 5.6 Command Line, you’ll see:

Probando MySQL 5.6

Starting MySQL 5.6

Probando MySQL 5.6

Starting MySQL 5.6

Well, a MySQL console! great!! Let’s check MySQL version with this query:

SHOW VARIABLES LIKE 'version%';

Probando MySQL 5.6

Starting MySQL 5.6

We’ll check the MySQL server works!! Inexpert users may think that the command line or a console is not very intuitive, and they are right! Maybe you’ll be descourage to keep on, and … but there is MySQL GUI tools, more beautiful for novices!

One of my favorite MySQL tools is heidiSQL, now version 8.3 (I promise to write about this MySQL admin software!), updated regularly, almost every day. Let’s introduce our connection data, and go connect!.

Probando MySQL desde heidiSQL

Trying MySQL using heidiSQL

This Admin software is cooler than the console or command line!!

Probando MySQL desde heidiSQL

Starting MySQL using heidiSQL

Let’s try the previous query, and see the result!

Probando MySQL desde heidiSQL

Starting MySQL using heidiSQL

There are more tools. Let’s try MySQL WorkBench, the graphical tool provided by ORACLE to work with MySQL. Under the SQL Development zone, let’s create a new connection to our local server:

Probando MySQL desde WorkBench

Starting MySQL using WorkBench

Again, let’s try the version query, obtaining the same result.

Probando MySQL desde WorkBench

Probando MySQL desde WorkBench

To end with, you have seen how our MySQL 5.6.10 server is up and running, starting you to work. I have showed you 3 different ways to work, and of course, every one has pros and cons! But that’s topic for a future entrance!

I hope this entrance encourage you to work with MySQL server! And have a nice day!!