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

In this tutorial, use the community green version of MySQL's latest MySQL service 8.0.11 to install the package in zip format. The installation is divided into the following four steps:

Step one:

Download the MySQL Community Green Service Pack

Step 2:

Create and configure the initialization "my.ini" file for MySQL

Step 3:

Use the installation command to install and initialize after the installation is complete

Step 4:

Start the MySQL service

Step 5:

Log in, change your password and then log in

Step one:

Mysql-8.0.11-winx64-bit green version of CSDN download https://download.csdn.net/download/hello_world_qwp/10417433

Officials say MySQL 8 is 2 times faster than MySQL 5.7.It also brings a lot of improvements and faster performance!

For details and new instructions, please refer to the official documentation.

After the download is completed, extract the package. The specific directory structure is as follows:

Configure the environment variable and add the bin directory under the MySQL directory to the system variable Path, as shown below:

Check "File extension" in the "View" of the system window to make sure that the my.ini file extension is correct, as shown in the following figure:

Step 2:

Create and configure the initialization "my.ini" file for MySQL.

Create a new my.ini initialization file and type the following:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=G:\ Install_Applications\ Program Files\ mysql-8.0.11# set mysql data storage directory datadir=G:\ Install_Applications\ Program Files\ mysql-8.0.11\ data# allow maximum number of connections the character set used by the max_connections=200# server defaults to 8 than Specially encoded latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

As shown below:

Note: the data directory does not need to be created. It will be created automatically in the next initialization.

Step 3:

Use the installation command to install and initialize after the installation is complete

During installation, cmd must be run as an administrator, otherwise an error will be reported during installation, which will lead to installation failure, as shown below:

Since we have configured the system environment variable of MySQL earlier, you can directly enter the command "mysqld install" to install it. If you have not configured the environment variable before, you need to enter the command in the bin directory of MySQl before entering the command to be valid. After the MySQL service is successfully installed, as shown below:

After initializing MySQL, enter the command "mysqld-- initialize". After initialization, you can start our MySQL service. Type the command "net start mysql". After starting successfully, it is shown below:

Note 1:

Note 2:

Mysqld-- initialize-insecure (recommended, do not set root password)

Mysqld-- initialize (not recommended, generating a random root password) requires several commands to be logged:

Install the MySQL service: mysqld-- install

Uninstall the MySQL service: sc delete MySQL/mysqld-remove

Start the MySQL service: net start MySQL

Stop the MySQL service: net stop MySQL

Step 5:

Log in, change the password and then log in

No password is required for initialization login. Enter the command "mysql-uroot-p" to log in directly, display the library input command "show databases;", connect to the MySQL library, enter the command "user mysql;", and then change the MySQL password by entering the modification statement "ALTER USER 'root'@'localhost' IDENTIFIED BY' HuaZai12345 password;". The modification is successfully shown in the following figure:

After the MySQL password modification is completed, exit the Super Admin and log in using normal login, as shown below:

Summary

The above is the installation tutorial of the green version of the MySQL8.0.11 community under Windows introduced by the editor. 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.