How to install MySQL for beginners (proven effective)

How to install MySQL for beginners (proven effective)

1. Software Download

MySQL download and installation:
Official website download address: https://www.mysql.com/

Or download locally

2. Installation Instructions

If you have uninstalled the software and are reinstalling it, please read this tutorial to ensure that you uninstall it cleanly.
How to uninstall MySQL cleanly? (Professional test and effective)

Check whether your computer name is in Chinese. If so, it is best to change it to English first to avoid unnecessary trouble.

After confirming that there are no problems with the above two steps, you can install the software.

3. Software Installation

1. After downloading, find the file location and double-click to run:

insert image description here

2. The following interface appears, enter the installation process, select Agree, and then click Next:

insert image description here

3. Check the last item, Customize, Next:
insert image description here

4. Click this box and select 64-bit or 32-bit MySQL. Most computers now have 64-bit. Click the arrow in the middle:

insert image description here

5. The default installation path is now the C drive. If it is the default, just click Next.

insert image description here

6. If you want to change the path, click on the icon

insert image description here

insert image description here

7. After selection, next step:

insert image description here

8. Start downloading:

insert image description here

9. Wait for downloading:

insert image description here

10. Then go all the way to next

insert image description here

insert image description here

insert image description here

11. If your computer name is in English, just click Next.

insert image description here

12. If your computer name is in Chinese, check the icon.

insert image description here

13. Enter the password here. I set a globally unified 123456, which is easier to remember:

insert image description here

14. Then it's all the way to next:

insert image description here

insert image description here

insert image description here

15. Click Finish:

insert image description here 16.

Click Next:

insert image description here

17. Click Finish:

insert image description here

The software is installed!

Additional notes:

insert image description here

If you encounter this situation at this step, you can solve it through the following two steps:

How to uninstall MySQL cleanly? (Tested and effective) How to solve the problem of MySQL getting stuck at starting server during installation? (Professional test and effective)

4. Verify that MySQL is installed successfully

1. Configure the environment variables:
Right click [My Computer] -> [Properties] -> [Advanced System Settings] -> [Environment Variables]:.
(Some systems have different ways to open environment variables. If they are different, you can search Baidu by yourself.)

insert image description here

2. Find the bin path of the previously installed software and copy it.
I changed the path to the E drive, and by default it searches on the C drive.

insert image description here

3. Find the path and configure the bin directory of MySQL:
Copy and paste the bin path in the order shown in the figure.

insert image description here

4. Then press win+r and enter cmd to open the command prompt;

If the software is installed to the C drive by default, directly enter mysql -u root -p, press Enter and enter the password 123456.

If you change the path, you need to switch the drive letter and then perform the above operations.
To switch drive letters, press “drive letter” + “:” and press Enter. As shown in the figure "E:".

insert image description here

If the code information shown in the figure appears, the configuration is successful.

This is the end of this article on how beginners can install MySQL (proven effective). For more information on installing MySQL, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • MySQL installation diagram MySQL graphic installation tutorial (detailed instructions)
  • Installation and configuration of MySQL 5.6 under Windows with screenshots and detailed instructions
  • MySQL 5.5 installation and configuration method graphic tutorial
  • CentOS 6.4 installation and configuration of LAMP server (Apache+PHP5+MySQL)
  • Graphic tutorial for installing mysql-5.6.4 under Linux
  • Graphical method for installing Apache+MySQL+PHP operating environment under Windows
  • Installation and simple use of MySQL version 5.7 (graphic tutorial)
  • Explain MySQL installation and login method under Linux
  • MySQL 5.6.17 Green Edition (Free Installation) Installation and Configuration Tutorial
  • MySQL Installation Detailed Graphic Version (V5.5 For Windows)

<<:  IDEA configuration process of Docker

>>:  JavaScript to achieve progress bar effect

Recommend

Detailed explanation of MySQL precompilation function

This article shares the MySQL precompilation func...

How to understand semantic HTML structure

I believe everyone knows HTML and CSS, knows the ...

Detailed tutorial on installing mysql under Linux

1. Shut down the mysql service # service mysqld s...

How to use lazy loading in react to reduce the first screen loading time

Table of contents use Install How to use it in ro...

How to write memory-efficient applications with Node.js

Table of contents Preface Problem: Large file cop...

Videojs+swiper realizes Taobao product details carousel

This article shares the specific code of videojs+...

mysql creates root users and ordinary users and modify and delete functions

Method 1: Use the SET PASSWORD command mysql -u r...

Some points on using standard HTML codes in web page creation

<br />The most common mistake made by many w...

How to create components in React

Table of contents Preface Component Introduction ...

Linux Disk Quota Management Graphical Example

Disk quota is the storage limit of a specified di...

Detailed explanation of JS array methods

Table of contents 1. The original array will be m...

Summary of Operator Operations That Are Very Error-Prone in JavaScript

Table of contents Arithmetic operators Abnormal s...

Detailed explanation of basic concepts of HTML

What is HTML? HTML is a language used to describe...