MySQL Database Course – Part I – (Video)

Part I: Installing MySql Server and MySql Workbench

With this post we start a course on relational databases using MySql as our database. It is Open Source, so everyone can download it and work with it, whatever the operating system. Besides, it is a very powerful and very robust database that has nothing to envy from paid databases like Oracle or SQL Server in certain respects, although that last point is very "debatable".

In this first part of the course (AS EXPLAINED IN THE VIDEO) we will show which tools you need to work with the MySql database: the "MySql Server" and the "MySql WorkBench". Once these tools are installed, we will set a password for the "super-user" (the "root") so that you can connect to the database and work with it.

Below are the links and commands you need to follow the video:

Link to the MySql website: Developer Zone (MySQL)

Link to download MySql Server: Download MySQL Community Server (MySQL)

Link to download MySql WorkBench: http://dev.mysql.com/downloads/workbench/5.2.html

Command to access MySql from the terminal for the first time:

/usr/local/mysql/bin/mysql -u root

Command to access MySql once the password has been set:

/usr/local/mysql/bin/mysql -u root -p

Query to see the existing hosts and users in MySql:

SELECT host,user FROM mysql.user ORDER BY user DESC;

Query to set the password for the "root" user on the "localhost" host:

SET Password FOR 'root'@'localhost'=Password('1234');

In this case the password is 1234, but you can use whatever password you want.

VIDEO TUTORIAL PART I