Summary of installation steps and problems encountered in decompressing the mysql5.7.24 version

1. Download

https://dev.mysql.com/downloads/mysql/

2. Unzip to a fixed location, such as D:\MySQL\mysql-5.7.24

3. Add the my.ini file

Same level as bin...
[mysql]

Set the default character set for the MySQL client

default-character-set=utf8
 [mysqld]

Set port 3306

port = 3306

Set the installation directory of MySQL

basedir=D:\MySQL\mysql-5.7.24

Set the storage directory for mysql database data

datadir=D:\MySQL\mysql-5.7.24\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 new tables

default-storage-engine=INNODB
max_connect_errors=100
 explicit_defaults_for_timestamp=true
 ···

4. Initialization

mysqld --install mysql --defaults-file=D:\MySQL\mysql-5.7.24\my.ini

5. Installation service

mysqld --install mysql

6. Startup

net start mysql

Finish

Problems encountered

1. Start and then stop the MySQL service on the local computer. Some services will automatically stop when they are not in use by other services or programs.

Or the console reports an error

mysql service cannot be started

The service did not report any errors

You can re-initialize and restart. Before initialization, you need to clear the data folder (same level as bin)

You can also delete the service and re-register

mysqld -remove mysql

2. Re-registering may reveal other errors such as: TIMESTAMP with implicit DEFAULT value is deprecated

Solution:

In the my.ini file, add a line under [mysqld] with explicit_defaults_for_timestamp=true. That's it

The meaning of this statement is #enable query cache, which is also one of the web caches. For repeated queries, you only need to read them in the cache, reducing the access to the database.

3. Log in and change the password according to the instructions on the Internet:

mysqladmin -uroot -p password 新密碼

Found that it would also report an error

mysql Access denied for user root@localhost error

Skip password login and change table user

 update user set password=password("new password") where user="root";
 The password column name may also be authentication_string

Then flush privileges;

4. How to skip password login

In the MySQL configuration file my.ini, add skip-grant-tables under [mysqld], shut down the MySQL service and restart it;

Enter the command: mysql -u root -p

After pressing Enter, you will be asked to enter your password. Press Enter to skip this and you will enter MySQL directly.

After this setting, you can directly double-click mysql.exe in D:\MySQL5.7.10\bin to start it without entering commands.

Summarize

The above is the installation steps of the mysql5.7.24 decompression version introduced by the editor and a summary of the problems encountered. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!