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

Recorded the installation of the mysql-8.0.12-winx64 unzipped version and shared it with you.

1. Download from the official website: download address

2. Extract to an appropriate directory

3. Configure environment variables

Path: directory of bin (must be configured)

MYSQL_HOME:mysql unzipped directory (function: in DOC, you can run commands on any drive letter, if not configured, you need to go to the specified directory)

4. Create a new my.ini if there is no my.ini database without initialization parameters

[mysql]; set mysql client default character set default-character-set=utf8 [mysqld]; set port 3306 port = 3306; set mysql installation directory basedir=D:\ MYSQL\ mysql-8.0.12-winx64; set mysql database data storage directory datadir=D:\ MYSQL\ mysql-8.0.12-winx64\ mydatabase; maximum number of connections the character set used by the max_connections=200; server defaults to the 8-bit coded latin1 character set character-set-server=utf8 Default storage engine default-storage-engine=INNODB that will be used when creating new tables

5. Use cmd to open the command window (to get the initial password, choose one of the two options)

Select 1: enter the mysqld-initialize command to initialize the data data directory of mysql. Remember that after initialization, a data folder will be generated under the unzipped directory, under which there will be a file ending with .err, and a randomly generated password will be generated when opened.

Option 2: use the mysqld-- initialize-- console command to generate a random password

6. Start the service using net start mysql

7. Log in and change the password mysql-u root-p

8. Change the login password 'newpassword' can be replaced with the new password you need.

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

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.