Shulou(Shulou.com)05/31 Report--

This article shows you how to install mysql 8.0.12 in the winx64 system, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Download mysql 8.0.12

After downloading, extract the installation package to any folder, and I will extract it to E disk here.

Installation

1. After decompression, there is E:\ mysql\ mysql-8.0.12-winx64, which creates an empty folder data. If you already have this folder, you do not need to do this step.

two。 Create a my.ini file, open it in notepad, and copy the following code into it

[mysqld] # set port 3306 port=3306# set the installation directory of mysql:\\ mysql\\ mysql-8.0.12-winx64# set the directory where the data of the mysql database is stored datadir=E:\\ mysql\\ mysql-8.0.12-winx64\\ Data # Note: double\ # maximum number of connections max_connections=200# allows the number of connections to fail. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. By default, the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=utf8# will use when creating a new table uses the "mysql_native_password" plug-in authentication default_authentication_plugin=mysql_native_ password [MySQL] # to set the mysql client default character set default-character-set=utf8 [client] # setting. Set the port port=3306default-character-set=utf8 used by default when the mysql client connects to the server

Configure environment variables

Right-click computer-> Properties-> Advanced system Settings-> Advanced-> Environment variables

Add a variable called MYSQL_HOME to the system variable.

Modify the Path variable to add% MYSQL_HOME%\ bin at the end

Run the cmd command as an administrator and change the path to the bin directory of mysql

To initialize the database, run the command: mysqld-initialize-console

Note that in the result, the part after the colon in the following sentence is the default password, write it down

A temporary password is generated for root@localhost: rI5rvf5x5G,E

Installation service

Run the command: mysqld-install, and mysql is installed

# Test whether the installation is successful

Run the mysql command: net start mysql

Stop the mysql command: net stop mysql

Change password

Suppose you want to change the password to 123456, run cmd, and run the command in the bin directory: mysql-u root-p

Enter the original password

Input statement: ALTER USER 'root'@'localhost' IDENTIFIED BY' 123456'

The above is how to install mysql 8.0.12 in winx64 system. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.