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

Catalogue

Download the compressed package

Address https://dev.mysql.com/downloads/mysql/

Extract the zip file and create the my.ini file

Decompressed directory:

Basedir=D:\ mysql-8.0.13-winx64

Data catalog:

Datadir=D:\ mysql-8.0.13-winx64\ data

Create a my.ini file with the following contents

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port=3306# set mysql installation directory basedir=D:\ mysql-8.0.13-winx64# set mysql database data storage directory datadir=D:\ mysql-8.0.13-winx64\ data# allow maximum number of connections character set used by max_connections=200# server defaults to 8-bit coded latin1 character set The default storage engine default-storage-engine=INNODB that character-set-server=utf8# will use when creating new tables

Configure environment variables

Add in path

Run the command prompt with administrator privileges

Enter the decompression directory and execute the following command in turn

Bin\ mysqld-defaults-file=my.ini-initialize-insecure

Bin\ mysqld-- install

Go to the bin directory and execute the command

Net start mysql

Set password

Go to the bin directory and execute the command

Here will prompt for the password, enter directly, do not enter

Mysql-u root-p

Update password ('password' can be set by personal habits, such as' 123456', etc.)

Use mysql;select host,user,authentication_string,plugin from user;alter user 'root'@'localhost' identified with mysql_native_password by' password'

Set remote access permissions

Update user set host='%' where user='root';flush privileges;exit

Restart the service, testing

Execute commands in the bin directory

Net stop mysqlnet start mysql

Summary

The above is the MySQL 8.0.13 installation-free configuration tutorial introduced by the editor to you in the windows environment. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

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.