MySQL 8.0.13 free installation version configuration tutorial under Windows environment

Table of contents

Download the compressed file

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

Unzip the zip file and create the my.ini file

Directory after decompression:

basedir=D:\mysql-8.0.13-winx64

Data Directory:

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

Create a my.ini file with the following contents:

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[mysqld]
# Set port 3306 port=3306
# Set the installation directory of mysql to basedir=D:\mysql-8.0.13-winx64
# Set the storage directory of mysql database data datadir=D:\mysql-8.0.13-winx64\data
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

Configuring environment variables

Add in path

Run the command prompt with administrator privileges

Enter the decompressed directory and execute the following commands in sequence:

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

bin\mysqld --install

Enter the bin directory and execute the command

net start mysql

Set password

Enter the bin directory and execute the command

You will be prompted to enter a password. Press Enter directly without entering any password.

mysql -u root -p

Update password ('password' can be set according to 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'; 

Setting up remote access permissions

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

Restart the service and test

Execute the command in the bin directory

net stop mysql
net start mysql

Summarize

The above is the configuration tutorial of MySQL 8.0.13 free installation version under Windows environment introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!