Shulou(Shulou.com)05/31 Report--

This article mainly introduces the installation of MySql8.0.19 will encounter what problems, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

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. Modify the root password

ALTER user 'root'@'localhost' IDENTIFIED BY' New password

Related readings:

Win10 installation zip version of MySQL8.0.19 tutorial details

Detailed explanation of the tutorials for installing Mysql8.0.19 in CentOS7.5

MySQL8.0.19 installation tutorial

Expand knowledge:

Install MySQL on Linux/UNIX

It is recommended to use the RPM package for installation on the Linux platform. Mysql,MySQL AB provides the download address for the following RPM packages:

MySQL-MySQL server. You need this option unless you only want to connect to the MySQL server running on another machine.

MySQL-client-MySQL client program that connects to and operates the Mysql server.

MySQL-devel-Library and include files, which you need to install if you want to compile other MySQL clients, such as Perl modules.

MySQL-shared-this package contains shared libraries (libmysqlclient.so*) that some languages and applications need to load dynamically, using MySQL.

MySQL-bench-A benchmark and performance testing tool for the MySQL database server.

Before installation, we can check whether the system comes with the installation MySQL:

Rpm-qa | grep mysql

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

Rpm-e mysql / / normal delete mode rpm-e-- nodeps mysql / / strong delete mode. If you use the above command to delete other dependent files, you can use this command to delete other files. Thank you for reading this article carefully. I hope the article "what problems will be encountered in installing MySql8.0.19" shared by the editor will be helpful to you? At the same time, I also hope that you will support and pay attention to the industry information channel, and more related knowledge is waiting for you to learn!

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.