MySQL Installation
This page contains the steps for downloading and installing MySQL.
If you already have MySQL installed you can skip this page. But if you need to install MySQL, this page will help you.
Download MySQL
First step is to download MySQL from the MySQL website.
This link takes you to the MySQL Community Server. This edition is a freely downloadable version MySQL. There are also commercial versions available, however, this tutorial uses the free version.
To check that your platform can run MySQL, see Supported Platforms.
Install MySQL
Once you've downloaded MySQL, the next step is to install it.
The following steps were taken while I installed MySQL 5.6 on my Macbook Pro (MySQL 5.6.24 to be precise). The exact steps taken may differ slightly — this will depend on the MySQL version that you're installing and the operating system that you're installing on to. If you get stuck, see the installation section from the MySQL reference manual.
-
Extract the Installer Package
-
Launch the Installer
-
Introduction
-
Accept Licence
-
Confirm Licence
-
Installation Type
-
Enter Password
-
Installing...
-
Installation Successful
Start MySQL Server
Now that you've installed MySQL, you should start it. On the Mac, you can do this via the System Preferences.
-
Open MySQL System Preferences
-
MySQL System Preferences
-
Start MySQL
Linux/Unix/Mac
Linux/Unix systems can use the mysqld_safe command to start MySQL. You can also use this method on the Mac, using Terminal.
To do this:
- Open Terminal, and type
cd /usr/local/mysql
(or where ever MySQL is installed on the machine). - Then type
sudo ./bin/mysqld_safe
and enter a password if prompted.
Windows
Windows users can go to the command prompt and type the following:
Or where ever MySQL is installed on the machine. Also change the version number to the version you're using.
Windows users can stop MySQL with the following command:
Next we'll take a look at MySQL Workbench. MySQL Workbench is a graphical tool that allows you to perform all sorts of tasks with MySQL.