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

The following mainly brings you the methods of installing and configuring mysql-5.7.21. I hope these contents can bring you practical use, which is also the main purpose of this article. All right, don't talk too much nonsense, let's just read the following.

Go to the MySQL website to download the version of MySQL 5.7.21 at https://dev.mysql.com/downloads/mysql/. Download the corresponding 32-bit or 64-bit version according to your own system. Extract the downloaded MySQL package to the installation directory. As shown in the figure:

Since the extracted directory does not contain My.ini (or my-default.ini) files, we need to create a new my.ini file ourselves. Create a new my.ini file in the MySQL installation directory The content settings 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=D:\ DataBase\ mysql# set mysql database data storage directory datadir=D:\ DataBase\ mysql\ data # maximum number of connections max_connections=200 # the character set used by the server defaults to 8 bits Encoded latin1 character set character-set-server=utf8 # default storage engine default-storage-engine=INNODB to use when creating new tables

4. 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.

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

6. Start the mysql service, net start mysql.

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

For the above about the installation and configuration of mysql-5.7.21 methods, we do not find it very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

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.