Share MySql8.0.19 installation pit record

The previous article introduced the installation process of MySql8.0.19. Friends who need it can click to view it. https://www.jb51.net/article/178988.htm

1. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

The solution is as follows:

mysql> ALTER USER USER() IDENTIFIED BY 'Xiaoming250';

2. Change the root password

ALTER user 'root'@'localhost' IDENTIFIED BY 'new password';

Related reading:

Detailed tutorial on installing MySQL 8.0.19 in zip version on win10

CentOS7.5 installation of MySQL8.0.19 tutorial detailed instructions

MySQL 8.0.19 Installation Tutorial

Further knowledge:

Installing MySQL on Linux/UNIX

It is recommended to use the RPM package to install MySQL on the Linux platform. MySQL AB provides the following RPM package download address:

MySQL - The MySQL server. You need this option unless you only want to connect to a MySQL server running on another machine.
MySQL-client - MySQL client program, used to connect to and operate the Mysql server.
MySQL-devel - Libraries and include files. If you want to compile other MySQL clients, such as Perl modules, you need to install this RPM package.
MySQL-shared - This package contains the dynamically loaded shared libraries (libmysqlclient.so*) that some languages ​​and applications need to use MySQL.
MySQL-bench - Benchmark and performance testing tool for the MySQL database server.
Before installation, we can check whether the system comes with MySQL installed:

rpm -qa | grep mysql

If your system has it installed, you can choose to uninstall it:

rpm -e mysql // Normal deletion mode rpm -e --nodeps mysql // Powerful deletion mode. If you are prompted to delete other dependent files when using the above command, you can use this command to forcefully delete them.

Summarize

The above is the editor's sharing of MySql8.0.19 installation pit record. I hope it will be helpful to everyone. Thank you very much for your support of the 123WORDPRESS.COM website!