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.