MySQL8.0 installation process under Centos7 in VMware workstation16 and Navicat remote connection

1. MySQL yum source installation

2. After installation, log in to MySQL for the first time and configure the password
3. Remote login problem (taking Navicat15 as an example)

1. CentOS7+MySQL8.0, yum source installation

1. Before installing MySQL, you should uninstall the original MySQL. If not, please ignore it.
1.1 Find the original MySQL installation directory and enter the command rpm -qa | grep mysql The following lines will appear

1.2 Use the following commands to delete the above files one by one

1.3 Delete the mysl configuration file

2. Install mysql8.0 from yum source
2.1 Download the repo source. You can get the repo source from the MySQL official website by clicking the following link (download as needed. I downloaded the Linux 7 version marked with a red line in the figure below) https://dev.mysql.com/downloads/repo/yum/

After clicking Download, click directly on the red circle in the picture below

2.2 After downloading is complete, transfer the file to the virtual machine master folder /usr/local/module/ via Xftp (the folder can be customized)

2.3yum install repo

yum install mysql80-community-release-el7-3.noarch.rpm

After the installation is complete, enter cd/etc/yum.repos.d and you can see the newly added repo

After completion, update the yum cache with the following command

2.4yum install mysql

2.4.1 Modify the installed version (default highest version)
Because the latest repo source on the official website includes many versions of MySQL, you can use cat /etc/yum.repos.d/mysql-community.repo to modify the enabled value of each version to determine which version to install.

cat /etc/yum.repos.d/mysql-community.repo

As can be seen in the figure above, for versions 5.5, 5.6, and 5.7, the enabled value is 0, which means it is not installed.

8.0 and other tools, the enabled value is 1, which means installation. The highest version is installed by default and can be left unchanged

2.4.2 Execute the installation command

yum install mysql-community-server

Possible problems:

Due to network problems, there may be problems with missing dependencies

Delta RPMs disabled because /usr/bin/applydeltarpm not installed

At this time, you only need to install the corresponding missing dependencies

yum -y install deltarpm

In addition, due to poor network environment, slow network speed, slow connection to the official MySQL source, etc., there may be interruptions during the installation process. Execute yum install multiple times until the installation is complete.

2. Log in to MySQL and change the password

1. Start the mysql service
1.1 Start MySQL service
systemctl start mysqld
1.2 Set the MySQL service to start automatically at boot
systemctl enable mysqld
systemctl daemon-reload
1.3 Check the MySQL service status
systemctl status mysqld

Active (running) appears, indicating that MySQL is running and the service is started successfully.

2. View the initial login password of MySQL
When mysql8.0 is installed, a default initial password has been assigned, which needs to be checked manually

grep 'temporary password' /var/log/mysqld.log

root@localhost: followed by the initial password, copy it

3. Change the MySQL login password. Note: The MySQL installed in the official source has the password security check plug-in (validate_password) installed by default. The default password check policy requires that the password must contain: uppercase and lowercase letters, numbers and special symbols, and the length must not be less than 8 characters. Otherwise, the error message ERROR 1819 (HY000): Your password does not satisfy the current policy requirements will be displayed. This article does not recommend modifying the default password security policy.

3.1 Enter the database and modify the root user password

mysql -uroot -p

Enter password: Enter the password after that. The password is the initial password for viewing (that is, what was copied in the previous step will not be displayed after pasting, just press the enter key)

Then use mysql

After executing use mysql, enter

ALTER user 'root'@'localhost' IDENTIFIED BY 'XXXXXXXXXX';

The content in single quotes is the password

Note that after entering the password, an error message will appear: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

The error is caused by password policy issues. The password cannot be too simple.

Then you can check the password policy and change your password before that, otherwise you will be prompted to change your password no matter what you do.

Enter again

ALTER user 'root'@'localhost' IDENTIFIED BY '12Loang';

If there is no error, jump directly to 3.11

If the same error is still reported, jump directly to 3.12

3.11 Enter the following command to view the corresponding parameters

SHOW VARIABLES LIKE 'validate_password%';

3.12 Then modify the parameters and enter the following command

set global validate_password.policy=0;

set global validate_password.length=1;

Then change the password you want to configure (I configured it to 123456, you can use it as you like, it is recommended to use a more complex password)

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

4. Log in to mysql
Now you can use mysql -uroot -p

Enter the password to log in to mysql

3. Remote Login

1. Modify the host of the root user
First log in to the MySQL database and switch to the MySQL database

mysql -uroot -p123456 # -p can be used to enter the root password

use mysql
Then check the host properties of the root user

select host,user from user;

The default host of the root user is localhost, which needs to be changed to % (the above picture is modified) to allow remote login to the database. Enter the following command

update user set host='%' where user='root';

After the modification is completed, use the following command to refresh to make the modification effective

flush privileges;
2. Log in using Navicat15 When using Navicat for Mysql to connect to MySQL 8.0, the following error will be reported:

Authentication plugin 'caching_sha2_password' cannot be loaded:

This is because the navicat password encryption method is mysql_native_password, while the mysql default encryption format is caching_sha2_password

Just change the root user password encryption method to the same as navicat

Execute Command

update user set plugin='caching_sha2_password' where user='root';
flush privileges;

Open Navicat Preminum, click Connect, then click MySQL to display the following interface

The connection name is arbitrary

For the host, fill in the IP address of the virtual host where you installed MySQL.

The port is usually 3306 and will not change.

Fill in the root user as the username

The password is the password you use to log in as root

Click Test Connection, and you are done.

This is the end of this article about the MySQL 8.0 installation process under Centos7 in VMware workstation16 + Navicat remote connection. For more relevant VMware workstation Navicat remote connection content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!