Introduction to MySQL

Decided to learn a bit more about MySQL as my team at work will soon be taking on some MySQL instances.

Installation: http://dev.mysql.com/downloads/ (MySQL 5.5)

How to Install: http://www.wikihow.com/Install-the-MySQL-Database-Server-on-Your-Windows-PC

The installation on windows is fairly painless. took around 5-10 minutes to install with simple click through windows.

Administration via a GUI?: I started using the MySQL Workbench (5.2 CE) which ships with the installation. Other tools are available including probably the most widely known which is the MAAT Kit (http://www.maatkit.org/)

Workbench home screen:

image

Workbench simple Query Editor:

image

Admin Page:

image

Command Line: the command line interface initially didn’t work for me. To resolve this i had to add the MySQL bin directory (C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin) into the environment variables on my Machine.

To do this on vista Right click my Computer | Properties | Advanced System Settings [Left pane] | Environment Variables…

Connecting via CMD

mysql -u root -p -h localhost

Some other Simple commands:

show databases;

use database;

show tables;

Reference Manual: http://dev.mysql.com/doc/refman/5.5/en/index.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: