Detailed introduction to installing MySQL5.6.35 under Windows 10 64-bit (pictures and text)-Mysql Tutorial-php.cn

Detailed introduction to installing MySQL5.6.35 under Windows 10 64-bit (pictures and text)

黄舟

Release： 2017-03-24 14:09:52

Original

1930 people have browsed it

This article mainly introduces the graphic tutorial for installing MySQL5.6.35 on Windows 10 64-bit. It is very good and has reference value. Friends in need can refer to it

1. Download MySQL Community Server 5.6.35

Detailed introduction to installing MySQL5.6.35 under Windows 10 64-bit (pictures and text)

##2. Unzip the MySQL compressed package

Extract the downloaded MySQL compressed package to a custom directory. I put it in D:\Program Files\MySQL\

Detailed introduction to installing MySQL5.6.35 under Windows 10 64-bit (pictures and text)

Add environment

Variables(Personally, I think it only needs to be added to user variables, System variables Try not to modify)

Variable name: MYSQL_HOME

Variable value: D:\Program Files\MySQL

is Custom decompression directory for mysql.

Detailed introduction to installing MySQL5.6.35 under Windows 10 64-bit (pictures and text)

Add %MYSQL_HOME%\bin in Path

Detailed introduction to installing MySQL5.6.35 under Windows 10 64-bit (pictures and text)

The operation is as follows:

1) Right-click the mouse to start the menu and select "Command Prompt (Administrator)"

Detailed introduction to installing MySQL5.6.35 under Windows 10 64-bit (pictures and text)

2) Enter the service installation command:

Detailed introduction to installing MySQL5.6.35 under Windows 10 64-bit (pictures and text)

mysqld install MySQL –defaults-file=”D:\Program Files\mysql-5.6.11-winx64\my-default.ini”

Copy after login

After the installation is successful, it will prompt that the service installation is successful.

If D:\Program Files\MySQL\bin>mysqld install MySQL –defaults-file="D:\Program Files\MySQL\my-default.ini"

The service already exists!

The current server installed: “D:\Program Files\MySQL\bin\mysqld” –defaults-file="D:\Program Files\MySQL\my-default.ini” MySQL

Indicates that the service has been registered and can be removed.

The removal service command is: mysqld remove

##5. Start the MySQL service

Method one:

The command to start the service is: net start mysql

Method two:

Open the management tool service and find the MySQL service.

Start the service by right-clicking and selecting Start or directly clicking Start on the left.

6. Modify the password of the root account

The default password of the root account is blank when the installation is just completed. At this time, the password can be changed to the specified password. Such as: 123456

Method one:

c:>mysql –uroot 
mysql>show databases; 
mysql>use mysql; 
mysql>UPDATE user SETpassword=PASSWORD(“123456”) WHERE user=&#39;root&#39;; 
mysql>FLUSH PRIVILEGES; 
mysql>QUIT

Copy after login

Method two:
Use third-party management tools to change passwords. Such as Navicatfor MySQL
The above is the detailed content of Detailed introduction to installing MySQL5.6.35 under Windows 10 64-bit (pictures and text). For more information, please follow other related articles on the PHP Chinese website!