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

This article will give you a detailed explanation on how to install and configure mysql-5.7.21. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

1. Unpack the downloaded mysql package to the installation directory

2. Create a new file my.ini and place it in the mysql installation directory, as follows:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting 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_connections=200# The character set used by the 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 opens the cmd window as an administrator, and change the directory to the bin directory under the mysql installation folder to 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

On "how to install and configure mysql-5.7.21" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.

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.