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

This article shares the installation and configuration method of mysql 8.0 for your reference. The details are as follows.

Use apt install mysql-server installation directly, so congratulations on stepping on it.

Sudo apt install mysql-server will install MySQL 5.7by default, and there will be some inexplicable problems, such as: the installation process does not require a root password, but will require a password when logging in to mysql (this is the problem I encountered, and I worked all afternoon, etc.).

After reading the MySQL installation guide, it is found that the highest version of MySQL5.7 only adapts to Ubuntu17.04, while the highest version of MySQL8.0 adapts to Ubuntu18.04.

So, go to MySQL APT Repository. Download a mysql-apt-config_0.*.****_all.deb and use the

Sudo dpkg-I mysql-apt-config_0.*.****_all.deb

To install and execute, select MySQL8.0,OK.

Then apt update a bit.

Using the sudo apt install mysql-server command, MySQL8.0 is installed

If you press this method, the following interface will appear during the installation process, asking the user to enter the MySQL password

MySQL8.0 uses a new encryption method, it must be noted that it is precisely because of this encryption method that Ubuntu18.04 cannot log in to MySQL with the set root password, because the Ubuntu18.04 terminal may have problems and does not support this new encryption method. Fortunately, there is an interface that allows us to choose to use the old version 5.x encryption, so we decisively choose to use 5.x encryption.

Finally, enter the mysql-u root-p command at the terminal and enter the password to check that the installation is successful and you can see that the MySQL version number is 8.0 seconds!

Wonderful topic sharing: different versions of mysql installation tutorials mysql5.7 various versions of installation tutorials mysql5.6 installation tutorials

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.