MySQL Wildcards

MySQL Wildcards

MySQL Aliases

MySQL Aliases

MySQL Data Types

MySQL Data Types

MySQL Interview Questions

MySQL Interview Questions and Answers


Installing the MySQL Database on Window

Download MySQL

First you need to Download MySQL Server from MySQL Community Server and follow the below steps to install MySQL on Window plateform.

MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.

Installing MySQL on Windows

Step 1:

Go to MySQL official website https://dev.mysql.com/downloads/mysql/

Step 2:

Select the right version for MySQL community server which you want.

Step 3:

Download Zip Archive from list.

Step 4:

Click on downloaded EXE file to begin MySQL installation.

Step 5:

Select MySQL Server from available products and click on Next button.

Step 6:

Configure the path where you want to install MySQL Server. The default path will be under Program Files.

Step 7:

Now click on Execute button to start installation.

Step 8:

Now set default password for MySQL Server and click on Next botton.

Step 9:

Now click on Finish botton.

Congratulation, you have installed MySQL Server on your Windows environment successfully. The default installer setup.exe will walk you through the trivial process and by default will install everything under C:\mysql.

Verify MySQL installation

Step 10:

Now verify MySQL installation. Go to start button on window and find MySQL command line client and click.

Step 11:

Once you open MySQL Command Line Client, it will appeared with a mysql> prompt. If you have set any password, type your password and press enter here. Now, you are connected to the MySQL server and you can execute all the SQL command at mysql> prompt as follows:

Step 12:

New check existing databases with show databases command: