MySQL 5.7.23 installation and configuration graphic tutorial

MySQL 5.7.23 installation and configuration graphic tutorial

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

1. Download address

2 After downloading, you can put the unzipped contents into any directory. My directory is as follows (if you put it in the C drive, there may be permission issues when modifying the ini file, so I changed it to the E drive): E:\mysql

As shown below: At this time, there is no data directory and ini file in the compressed file

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

[mysqld]
#Set port 3306 to 3306
# Set the installation directory of mysql to basedir=E:\mysql
# Set the storage directory of mysql database data datadir=E:\mysql\data
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8

4. Configure the environment variables below:

Computer Properties -》Advanced System Settings -》

Click on Environment Variables

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

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

5.MySQL installation process:

Run cmd as administrator

Enter the following directory: E:mysql\bin

1. Run mysqld --install to install the service. The console will prompt: Services successfully installed. If you run mysqld --install to install the service, it will show that it already exists.

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

2. Run the command: mysqld --initialize (the data directory will be generated at this time)

3. Start the service net start mysql

4. Change password

Step 1: net stop mysql (stop the service)

Step 2: Execute mysqld --skip-grant-tables to start the password-less MySQL Server.

Step 3: Open a new terminal and enter mysql -u root -p to enter mysql

Step 4 : Then update the root account password to 'root'

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

Step 5: Execute the flush privileges command to refresh permissions.

Step 6: quit;

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

Step 8 : Change 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

Mission accomplished! 5.7.23 Database installation successful!

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.6 installation tutorials for various versions

MySQL 5.7 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:
  • Tutorial on installing mysql5.7.23 on Ubuntu 18.04
  • Ubuntu 18.04 installs mysql 5.7.23
  • The latest MySQL 5.7.23 installation and configuration graphic tutorial
  • MySQL 5.7.23 version installation tutorial and configuration method
  • MySQL 5.7.23 decompression version installation tutorial with pictures and text
  • Pitfalls and solutions for upgrading MySQL 5.7.23 in CentOS 7
  • MySQL 5.7.23 winx64 installation and configuration method graphic tutorial under win10
  • mysql 5.7.23 winx64 decompression version installation tutorial
  • MySQL 5.7.23 installation and configuration method graphic tutorial
  • Binary installation of mysql 5.7.23 under CentOS7

<<:  How to configure CDN scheduling using Nginx_geo module

>>:  How to redirect URL using nginx rewrite

Recommend

Summary of problems that may occur when using JDBC to connect to Mysql database

First, clarify a few concepts: JDBC: Java databas...

Detailed explanation of common usage of MySQL query conditions

This article uses examples to illustrate the comm...

Nofollow makes the links in comments and messages really work

Comments and messages were originally a great way...

Practical experience of implementing nginx to forward requests based on URL

Preface Because this is a distributed file system...

Detailed tutorial on installing mysql 8.0.13 (rpm) on Centos7

yum or rpm? The yum installation method is very c...

How to use Node.js to determine whether a png image has transparent pixels

background PNG images take up more storage space ...

Detailed explanation of nginx anti-hotlink and anti-crawler configuration

Create a new configuration file (for example, go ...

A brief discussion on several advantages of Vue3

Table of contents 1. Source code 1.1 Monorepo 1.2...

MySQL chooses the appropriate data type for id

Table of contents Summary of Distributed ID Solut...

Vue+ssh framework to realize online chat

This article shares the specific code of Vue+ssh ...

How to display small icons in the browser title bar of HTML webpage

Just like this effect, the method is also very si...

Detailed explanation of the configuration method of Vue request interceptor

Follow the steps below 1. request.js content: htt...

Five practical tips for web form design

1. Mobile selection of form text input: In the te...