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?“.
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:
Well, a MySQL console! great!! Let’s check MySQL version with this query:
SHOW VARIABLES LIKE 'version%';
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!.
This Admin software is cooler than the console or command line!!
Let’s try the previous query, and see the result!
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:
Again, let’s try the version query, obtaining the same result.
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!!