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

This article mainly explains how to download and install mysql8.0.20, the content is clear, interested friends can learn, I believe it will be helpful after reading.

1. Browser search for mysql download and installation

2. Log in or not log in to download

3. Download a compressed package, which can be extracted directly without installation.

4. Create a new my.ini file with the following contents

With regard to sql_mode, an error like the following is because the group by field must be fully displayed in the query column, so if you remove this pattern, you will not report an error.

Caused by: java.sql.SQLSyntaxErrorException: Expression # 13 of SELECT list is not in GROUP BY clause and contains nonaggregated column .which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

5, then install, configure the mysql directory into the system environment variable path, but do not configure, but the configuration can be directly in the dos interface to tap mysql.

6. The computer uses the administrator command mode to enter the mysql/bin directory and initialize the installation of mysql

After entering, if you need to change the drive letter, you can switch it directly, then cd mysql directory / bin, and enter the bin directory.

Then enter:

1), mysqld-- initialize-- console, which initializes the my.ini file, builds the data directory, and other settings. Select the password below with the mouse and press ctrl+c to copy.

Note here that if the subsequent my.ini file is modified and does not take effect after restarting mysql, you need to delete the data directory, delete the mysql service, command the sc delete service name, and then re-execute the command

2), input: mysqld-- install

3), enter: net start mysql if mysql has been installed locally, the service name here can be modified, such as mysql8, but when I test here, if mysql5.5 already exists locally, install mysql8, and the password read is still the login password of mysql5.5, then delete mysql5.5 and install mysql8 normally.

6. Log in and change your password

Win+R, enter the command line mode, enter: mysql-u root-p. If you have not joined path before, you need to enter the mysql bin directory here.

Enter the password copied in step 5 and enter mysql

Execute: successfully change the password to root after the alter user root@localhost identified by 'root'; enter key. Do not lose the semicolon after the sql statement.

After reading the above content, do you have a further understanding of how to download and install mysql8.0.20? if you want to learn more, you are welcome to follow the industry information channel.

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.