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