How to install MySQL on Windows
In this tutorial, we are going to see how to install MySQL on Windows step by step, using the MySQL installer. After this tutorial, you will have MySQL server and its tools operational on your system to learn and practice.
Note: if you use other operating system platforms such as Linux, use the following tutorial:
- Install MySQL 8 on CentOS 7
- Installing MySQL 8 on Ubuntu
Download MySQL installer
To download MySQL installer, go to this link. There are two installation files:
- If you connect to the Internet while installing MySQL, you can choose the online installation version mysql-installer-web-community-<version>.exe.
- If you want to install MySQL offline, you can download the file mysql-installer-community-<version>.exe.
Note that the download links do not lead directly to the files. Instead, they lead to a next page where you are prompted to log in or create an account. If you don’t want to create an account, you can locate the text “No thanks, just start my download.”
Install MySQL via the installer
To install MySQL using the installer, double click on the MySQL installer file and follow the steps below:
The first screen asks you to accept the terms and conditions. Specifically, it is the GNU Public License, one of the major open-source licenses. select “I accept the terms”, then select “Next”.
Then you have the choice between several types of installation. Choose “Custom”.
On the screen “Select Products and Features”, you need to move the items from left to right. First, open “MySQL Servers”. Then navigate to the server you need (MySQL Server 8.0.17 – X64) and select the arrow pointing to the right. It is now selected for installation.
Select Applications, then select everything except MySQL for Excel and MySQL for Visual Studio. Again, select the right arrow for installation, then select “Next”.
Click “Execute” to begin the installation.
Now the installer will start downloading MySQL automatically.
Once installed, select “Next”. The wizard will then guide you through the configuration.
Configure the MySQL server as follows, select “Standalone MySQL Server / Classic MySQL Replication”:
Type and networking: select the default option “Development Computer”, which will allow you to work locally.
Select “Use Strong Password Encryption for Authentication”.
Enter a password for your MySQL root (admin) user. Normally you can set up at least one regular user with a name and password as well, but since you are just testing, the root account is sufficient.
Here you can keep the default values.
Select “Execute” to apply your configurations.
Finally, click on “Finish”.
- MYSQL MCQ and Answers – Part 1
- MYSQL MCQ and Answers – Part 2
- MySQL VERSION()
- MySQL GROUP_CONCAT()
- MySQL ISNULL() Function
- MySQL CONVERT()
- MySQL CAST()
- MySQL MD5()
- How To Get Year From Date In MySQL
- MySQL TIMESTAMP()
- MySQL TIMEDIFF()
- MySQL: How to Convert Seconds To HH:MM:SS Format
- How To Get Month From Date In MySQL
- MySQL NOW()
- MySQL – Get Day of Week Name Using DAYOFWEEK()
- MySQL – Get Difference Between Two Dates in Days
- MySQL DATE_FORMAT()
- MySQL ROUND()
- MySQL RAND()
- MySQL INSTR()
- MySQL LOCATE()
- MySQL LCASE()
- MySQL UCASE()
- MySQL String To Lowercase
- MySQL Uppercase in Where Clause
- MySQL Select Uppercase
- MySQL LPAD() With Leading Zeros
- MySQL RTRIM()
- MySQL LTRIM()
- MySQL Trim Whitespace Using TRIM() Function
- How to Reverse a String in MySQL
- MySQL RIGHT() Function
- MySQL LEFT() Function
- MySQL SUBSTRING() with Examples
- MySQL SOUNDEX() with Examples
- MySQL String Length
- MySQL Concatenate Multiple Columns
- MySQL Select SUM() with Example
- MySQL Select MAX()
- MySQL Select MIN()
- MySQL COUNT()
- MySQL Average AVG()
- How To Comment In MySQL
- How to Comment Multiple Lines in MySQL
- MySQL OPTIMIZE
- MySQL EXPLAIN
- MySQL CREATE INDEX with Example
- MySQL ANY with Example
- MySQL ALL with Example
- MySQL EXISTS
- MySQL NATURAL JOIN
- MySQL SELF JOIN
- MySQL FULL JOIN
- MySQL RIGHT JOIN
- MySQL LEFT JOIN
- MySQL CROSS JOIN
- MySQL AUTO_INCREMENT
- SQL UNION ALL
- SQL GROUP BY WITH ROLLUP
- SQL Wildcards in Statement
- SQL IN Operator
- SQL AND and OR Operators
- How to use SQL_NO_CACHE?
- MySQL SELECT INTO
- MySQL ON DELETE CASCADE
- MySQL DELETE
- MySQL WHERE
- AND Operator in MySQL
- OR Operator in MySQL
- MySQL IS NULL
- MySQL REPLACE
- MySQL INSERT INTO SELECT
- MySQL INSERT IGNORE
- MySQL INSERT ON DUPLICATE KEY UPDATE
- Derived table (subquery) with MySQL
- How to Insert Multiple Rows in MySQL at a Time
- MySQL UNION
- MySQL LIMIT
- Replace All NULL Values with 0 in MySQL
- MySQL UPDATE
- MySQL INSERT INTO
- CASE WHEN in MySQL with Multiple Conditions
- MINUS in MySQL
- INTERSECT in MySQL
- How to check if a record exists in another table in MySQL
- MySQL HAVING
- MySQL GROUP BY
- MySQL BETWEEN
- MySQL LIKE
- How to Check if Value Exists in a MySQL Database
- MySQL ORDER BY
- MySQL CONCAT()
- MySQL CREATE TABLE
- MySQL SELECT DISTINCT
- How to Use Column Alias in Select Clause – MySQL
- MySQL SELECT
- MYSQL MCQ and Answers – Part 3
- MYSQL MCQ and Answers – Part 4
- MYSQL MCQ and Answers – Part 5
- MYSQL MCQ and Answers – Part 6
- MYSQL MCQ and Answers – Query optimization
- MySQL Practice Exercises with Solutions – Part 1
- MySQL Practice Exercises with Solutions – Part 2
- MySQL Practice Exercises with Solutions – Part 3
- MySQL Practice Exercises with Solutions – Part 4
- MySQL Practice Exercises with Solutions – Part 5
- MySQL Practice Exercises with Solutions – Part 6
- MySQL Practice Exercises with Solutions – Part 7
- MySQL Practice Exercises with Solutions – Country Database – Part 8
- MySQL Practice Exercises with Solutions – Ordering System Database – Part 9
- How to Use a CASE-WHEN Statement in a MySQL Stored Procedure
- IF-THEN Condition in MySQL Stored Procedure
- How to Declare and Assign a Value to a Variable in MySQL Stored Procedure
- How to Create a Stored Procedure with Parameters in MySQL
- How to Drop a Stored Procedure in MySQL
- How to show all stored procedures/functions in MySQL
- How to Create a Stored Procedure in MySQL
- How to create composite primary key in MySQL PHPMyAdmin
- How to Create a Primary Key in MySQL
- How to Set up Multiple Fields as Primary Key in MySQL
- How to Set Primary Key and Auto_increment in PHPMyAdmin
- How to Export a MySQL Database using Command Line
- How to Import a MySQL Database using Command Line
- How to Export Database in phpMyAdmin
- How to Import Database in phpMyAdmin
- How to Create a Form in PHP MySQL
- PHP – Password Hash & Password Verify with Example
- How to Check if Username Already Exists in Database using PHP MySQL
- How to Check if Email Already Exists in Database using PHP
- How to Display Blob Image in PHP from Database
- How to call stored procedure in PHP with MySQLi
- PHP MySQL Transactions with Examples
- How to delete a row in MySQL using PHP
- How to copy data from one table to another in MySQL using PHP
- How to update data in MySQL database using PHP PDO
- How to insert multiple rows in MySQL using PHP
- How to insert data in MySQL using PHP PDO
- How to Fetch Data from Database in PHP and Display in HTML Table using PDO
- How to Connect to MySQL Database in PHP using PDO
- How to Create a MySQL Table with PDO in PHP
- MySQL INNER JOIN with Examples
- How to Delete a View in MySQL
- How to Update a View in MySQL
- How to Create a View in MySQL
- How to Remove Default Value from Column in MySQL
- MySQL Add Column With Default Value
- How to Drop NOT NULL Constraint in MySQL
- How to Add NOT NULL Constraint in MySQL using ALTER Command
- How to Change Auto Increment Value in MySQL
- MySQL Sequence
- How to Remove a Primary Key in MySQL
- How to create index for existing table in MySQL
- How to Drop Index From Table in MySQL
- How to delete all rows from a table in MySQL
- How to Delete Table in MySQL
- How to Delete a Column in a Table in MySQL
- How to Rename a Table in MySQL
- How to Change Column Name in MySQL
- How to Change the Data Type for a Column in MySQL
- How to Add a Column in a Table in MySQL
- How to drop a temporary table in MySQL
- How to Create a Temporary Table in MySQL
- Primary Key and Foreign Key Examples
- How to Create Table in MySQL Command Line
- How to Delete Database in MySQL
- How to check the version of MySQL in Windows
- How to Create Database in MySQL
- How to install MySQL Workbench on Ubuntu using Terminal
- How to install MySQL on CentOS 7
- How to install MySQL on Ubuntu
- How to install MySQL on Windows
- List of MySQL Commands with Examples
