MySQL 8.0.15 installation and configuration graphic tutorial and password change under Linux

I wrote this blog to remember that I just installed MySQL8.0.15 successfully. I searched many blogs on the Internet before but failed. Then I searched a few on Google and finally installed it. Before installing the database, I reinstalled the server system, so the installation environment is very clean. I hope this blog can help you, and I don’t have to look for it everywhere when I install it myself in the future.

The first step is to download the installation package wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm , and other versions can be downloaded from the official website

First create a folder and create a mysql folder in the /usr/local/directory

Execute wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

Get the result

The second step is to directly execute yum -y localinstall mysql80-community-release-el7-1.noarch.rpm

Execution result: There is a lot of content here, so I won’t take screenshots of all of it. I only took screenshots of the beginning and the end.

Please wait a few minutes to download.

beginning

Conclusion

The installation is completed successfully

Start the service

After executing these two commands, nothing will be printed, which is normal.

Then log in to MySQL

First, get the default password. Execute grep "A temporary password is generated for root@localhost" /var/log/mysqld.log

My password here is S9vMy4eoPc.p

Login and change password

Command to change the password: ALTER USER 'root'@'localhost' IDENTIFIED BY '[email protected]';

Change [email protected] to the new password you want to set

After 8.0, passwords must contain uppercase and lowercase letters, special symbols, and numbers. The above error is caused by the new password not meeting the password specification.

Setup successful.

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various 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.