close[x]


MySQL

MySQL-Home MySQL-Environment setup MySQL- Workbench MySQL-Basic syntax MySQL-Operator MySQL-Data type MySQL-Comments MySQL-Create DB MySQL-Drop DB MySQL-Select DB MySQL-Create Table MySQL-Drop table MySQL-Truncate MySQL-Primary Key MySQL-Foreign Key MySQL-Null MySQL-Increment MySQL-Having MySQL-Top MySQL-Insert Statement MySQL-Select Statement MySQL-Alter Statement MySQL-Where MySQL-And & Or MySQL-Default values MySQL-Exists MySQL-Order by MySQL-View MySQL-Update Statement MySQL-Delete Statement MySQL-Like MySQL-Sort MySQL-Limit MySQL-Min MySQL-Max MySQL-Group MySQL-In MySQL-Between MySQL-Union MySQL-Count MySQL-Average MySQL-Sum MySQL-Date & Time MySQL-Import MySQL-Export MySQL-Index MySQL-Temporary MySQL-Join MySQL-Full Join MySQL-Inner Join MySQL-Left Join MySQL-Right Join MySQL-Store Procedure MySQL-Injection MySQL-PHP connection



learncodehere.com




MySQL - Environment Setup

MySQL works on different platforms like Windows, Mac, Linux etc

In this tutorial, you will learn step by step how to install MySQL on the Windows platform using the MySQL Installer.


Download MySQL Installer

MySQL installer provides you with an easy-to-use wizard that helps you to install MySQL with the following components:

  • MySQL Server
  • All Available Connectors
  • MySQL Workbench with Sample Data Models
  • Tools for Excel and Microsoft Visual Studio
  • MySQL Sample Databases
  • MySQL Documentation
  • To download MySQL installer, go to the following link http://dev.mysql.com/downloads/installer/. There are two installer files:

  • If you are connecting to the internet while installing MySQL, you can choose the online installation
  • In case you want to install MySQL offline, you can download the offline installer

  • Install MySQL via MySQL Installer

    To install MySQL using the MySQL installer, double-click on the MySQL installer file and follow the steps

    Install MySQL Step 1 - Windows configures MySQL Installer

    Install MySQL Step 2 - Choose the first option: Install MySQL Products

    mysql installation

    Install MySQL Step 3 – MySQL installer checks and downloads the latest MySQL products including MySQL server, MySQL Workbench, etc.

    mysql installation

    Install MySQL Step 5 – Choosing a Setup Type: there are several setup types available. Choose the Full option to install all MySQL products and features.

    mysql installation


    Install MySQL Step 5 – Checking Requirements

    mysql installation

    Install MySQL Step 6 – Installation Progress: MySQL Installer downloads all selected products. It will take a while, depending on which products you selected and the speed of your internet connection

    Install MySQL Step 6 – Installation Progress: downloading Products in progress

    Install MySQL Step 6 – Installation Progress: Complete Downloading. Click the Next button to continue

    mysql installation

    Install MySQL Step 7 – Configuration Overview. Click the Next button to configure MySQL Database Serve

    mysql installation


    Install MySQL Step 7.1 – MySQL Server Configuration: choose Config Type and MySQL port (3006 by default) and click Next button to continue

    mysql installation

    Install MySQL Step 7.2 – MySQL Server Configuration: choose a password for the root account. Please note the password download and keep it securely if you are installing MySQL database server on a production server. If you want to add a more MySQL user, you can do it in this step.

    mysql installation

    Install MySQL Step 7.3 – MySQL Server Configuration: choose Windows service details including Windows Service Name and account type, then click Next button to continue.

    mysql installation

    Install MySQL Step 8 – Configuration Overview: MySQL Installer installs sample databases and sample models.

    mysql installation

    Install MySQL Step 9 – Installation Completes: the installation completes. Click the Finish button to close the installation wizard and launch the MySQL Workbench.