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

This article mainly introduces the example analysis of mysql5.7.21 winx64 installation and configuration, which is very detailed and has certain reference value. Friends who are interested must finish it!

This article mainly introduces in detail the mysql 5.7.21 winx64 installation and configuration method graphics and text tutorial, has a certain reference value, interested friends can refer to, hope to help you.

1. Unpack the downloaded mysql package to the installation directory

2. Create a new file

My.ini, placed in the mysql installation directory, the contents are as follows:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=F:\ work office\ mysql-5.7.21\ mysql-5.7.21-winx64 # set mysql database data storage directory datadir=F:\ work office\ mysql-5.7.21\ mysql-5.7.21-winx64\ data # maximum number of connections allowed max_ The character set used by the connections=200 # server defaults to the 8-bit encoded latin1 character set character-set-server=utf8 # the default storage engine default-storage-engine=INNODB that will be used when creating new tables

3. Install the mysql service

Open the cmd window as an administrator and change the directory to the bin directory under the mysql installation folder

Execute mysqld install

4. Initialize the mysql database and enter "mysqld-initialize-user=root-console". The red text below is the initialized root password

5. Start the mysql service

6. Log in to mysql with the generated password and change the password through "set password=password ('123456')". Set the root password to 123456 here

The above is all the contents of the article "sample Analysis of mysql5.7.21 winx64 installation configuration". Thank you for reading! Hope to share the content to help you, more related knowledge, 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.