mysql8.0.20 download and installation and problems encountered (illustration and text)

1. Search mysql in the browser to download and install

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

2. Download with or without logging in

3. The downloaded file is a compressed package, which can be decompressed directly without installation.

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

Regarding sql_mode, the error below is because the group by field must be completely displayed in the query column, so if you remove this mode, there will be no 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 and configure the mysql directory into the system environment variable path. It is optional, but if it is configured, you can directly type mysql in the dos interface.

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

After entering, if you need to switch drive letters, just d: to switch, then cd mysql directory/bin to enter the bin directory

Then enter:

1) mysqld --initialize --console, this command will initialize the my.ini file, build the data directory and other settings. Select the password below with the mouse and press ctrl+c to copy it.

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

2) Enter: mysqld --install

3) Input: net start mysql If mysql has been installed locally, you can modify the service name here, such as mysql8. However, in my test, when mysql5.5 already exists locally, I installed mysql8 and the password read was still the login password of mysql5.5. Then I deleted mysql5.5 and installed mysql8 normally.

6. Login and change password

Win+R, enter the command line mode, enter: mysql -u root -p , if the path is not added before, you need to enter the mysql bin directory here

Enter the password copied in step 5 and enter mysql

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

Summarize

This is the end of this article about mysql8.0.20 download and installation and the problems encountered. For more relevant mysql8.0.20 download and installation content, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!