Shulou(Shulou.com)06/01 Report--

1. Preface

There are two ways to install mysql under windows, one is msi, and the other is using the zip package. Usually use the msi way, after all, do not need to type the command, only the graphical interface can be completed. The installation of the zip package is also simple and can be done with two commands.

Software version

Windows 2008R2-64bit

Mysql 8.0.12

2. Download

Download the installation package and extract it, as shown below:

3. Installation

Unlike version 5.6, there is no my.ini in the directory after being unzipped in version 8.0.

In fact, at the time of installation, even without this file, it is possible to install successfully.

Of course, if you want to make other configurations, you can create a new one and specify some parameters.

The most commonly used ones are the following

Port: port

Installation directory: dirbase

Database directory: database

If there is no my.ini file, the data directory will be generated in the installation directory.

These options

Install services for windows

Use the command mysqld-- install mysql8888

This mysql8888 is a random name, anything, as long as there is no conflict.

You will be prompted that the installation was successful.

View the services of windows. You can see the added windows service.

Initialize and start mysql

Use the command: mysqld-- initialize-- console

Initialize the database and generate a random password, which is checked in the red box. Keep this in mind. You'll need it when you log in to mysql later.

Then use the command net start mysql8888 to start the database.

This mysql8888 is also based on the name given when the service was previously installed.

problem

The following problems were encountered during initialization.

After initialization, no random password is displayed. I don't know if it is because there is no my.ini file, but the data directory has been generated.

If this problem occurs, you can delete the data directory and re-execute the command.

Change password

After logging in to the database, when using the command, if you do not change your password, you will have the following prompt:

Prompt you to use the alter user command to change your password

The following is my command to change the password. Set password can't change the password.

Only alter user root@localhost IDENTIFIED BY '123456' can be used.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.