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

This article will explain in detail how to install and configure mysql 5.7.23. 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.

This article records the detailed process of mysql5.7.23 installation and shares it with you.

1. download

2 after downloading, you can put the unzipped content in any directory. Mine is the following directory (if you put it on disk C, it may involve permission issues when modifying the ini file, and then I will change to disk E): e:\ mysql

As shown below: there are no data directories and ini files in the compressed files at this time.

3. Create a new my.ini file in the E:\ mysql directory and copy the following

[mysqld] # set 3306 side port = 330 setting mysql installation directory basedir=E:\ mysql# set mysql database data storage directory datadir=E:\ mysql\ data# allow the maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit encoded latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODBsql_mode=NO_ENGINE_SUBSTITUTION to use when creating new tables STRICT_TRANS_ tables [MySQL] # set the mysql client default character set default-character-set=utf8

4. Configure the environment variables as follows:

Computer Properties-"Advanced system Settings -"

Click the environment variable

In the system variables section, create a new variable name: MYSQL_HOME, variable value: e:\ mysql

Set path and add a new bin directory in path (note the semicolon;)

5.MySQL installation process:

Run cmd as an administrator

Enter the following directory: E:mysql\ bin

1. Run mysqld-- install installation service console will prompt: Services successfully installed if running mysqld-- install installation service shows that it already exists

Type mysqld-- remove to remove the previously installed mysql and run mysqld-- install again

two。 Run the command: mysqld-- initialize (the data directory will be generated)

3. Start the service net start mysql

4. Modify the password

Step 1: net stop mysql (stop service)

Step 2: execute mysqld-- skip-grant-tables to open MySQL Server without password.

Step 3: open a new terminal, enter mysql-u root-p to enter mysql

Step 4: then update the password of the root account to 'root'

Command: update mysql.user set authentication_string=password ("root") where user= "root"

Step 5: perform flush privileges refresh permissions.

Step 6: quit

Step 7: enter mysql-u root-p into mysql and enter the password root

Step 8: change the password again:

Step 1: SET PASSWORD = PASSWORD ('your new password')

Step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER

Step 3: flush privileges

Step 9: open cmd again and log in again

The great task has been completed! 5.7.23 Database installed successfully!

This is the end of this article on "how to install and configure mysql 5.7.23". 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 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.