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

This article mainly introduces "how to install the latest version of mysql8.0". In daily operation, I believe many people have doubts about how to install the latest version of mysql8.0. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the questions of "how to install the latest version of mysql8.0". Next, please follow the editor to study!

download

Mysql-8.0

Https://www.mysql.com/

Mirror image

There is no mirror image.

Plus mirroring

List of common images

Http://blog.csdn.net/enweitech/article/details/52353114

Download address: http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-8.0.12-winx64.zip

Installation

Open dos as an administrator

Extract "mysql-8.0.12-winx64.zip" anywhere, such as under c:\ java

Start a dos as an administrator (command prompt)

Enter the unzipped directory of mysql.

Cd c:\ java\ mysql

Installation command

Add mysql's services to windows's list of services

Bin\ mysqld install

Unstall (uninstall), remove (delete)

After execution, the effect is:

Initialization

Bin\ mysqld-- initialize

Effect picture:

An extra data directory has been added

Connection test

Start the mysql server side

Bin\ mysql-u root-p

Mysql: is a built-in client,-u:root (username),-p (password); the password must be copied

-P is the port number

Port number

Range of port number: 0Mui 65535; (2 bytes)

Mysql: the port number is: 3306; you want to use the port number (defined by yourself): do not use below 10000

In the hostname .err file under the password data directory, each computer has a different installation password.

The following interface indicates that the connection is successful and the mysql database is installed successfully

Reset password

The password must be reset first.

-- change the password

Alter user 'root'@'localhost' identified by' 123456'

-- exit the client

Exit

Change the password of Mysql8.0

-- password expiration policy:

ALTER USER 'root'@'localhost' IDENTIFIED BY' 123456 'PASSWORD EXPIRE NEVER

-- there are three ways to encrypt mysql8.0: local (native) and cache2 (by default, navicate programs cannot be connected)

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' 123456'

Log in again and use the new password OK

Exit: exit the client

Reinstall

Delete the data directory in the mysql directory and follow the installation command again.

common problem

Win7: the running environment of C++ 2013 needs to be installed before entering the mysql command. If there is an error, install it.

Installation

Win10: install this software:

At this point, the study on "how to install the latest version of mysql8.0" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.