Ubuntu 18.04 MySQL 8.0 installation and configuration method graphic tutorial

This article shares the installation and configuration method of MySQL 8.0 for your reference. The specific content is as follows

Use apt install mysql-server to install directly, then congratulations on your mistake.

sudo apt install mysql-server will install MySQL 5.7 by default, which may cause some strange problems, such as: the installation process does not require the root password, but the password is required when logging in to mysql (I encountered this problem and spent an afternoon on it, etc...

After reading the MySQL installation guide, I found that MySQL 5.7 is only compatible with Ubuntu 17.04 at most, while MySQL 8.0 is compatible with Ubuntu 18.04 at most.

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

sudo dpkg -i mysql-apt-config_0.*.****_all.deb

Install and execute, select MySQL 8.0, OK.

Then apt update

Use the sudo apt install mysql-serve r command to install MySQL 8.0

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

MySQL 8.0 uses a new encryption method. Please note that it is because of this encryption method that Ubuntu 18.04 cannot log in to MySQL with the set root password, because the Ubuntu 18.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 encryption method of the old version 5.x, so we decisively chose to use the encryption method of 5.x.

Finally, enter the mysql -u root -p command in 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! !

Wonderful topic sharing: Installation tutorials for different versions of MySQL Installation tutorials for MySQL 5.7 versions Installation tutorials for MySQL 5.6 versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.