Detailed explanation of PHP7.4 and MySQL8 certification issues

The default password encryption method of

##mysql8 is caching_sha2_password, PHP7.4 connects to mysql The encryption method is also caching_sha2_password, you should pay attention to this place.

In order to be compatible with older versions of clients, not only PHP, but also problems during master-slave replication, the authentication method of mysql8 was changed back to

mysql_native_password.

If you use PHP7.4, an authentication error will be reported here, because 7.4 is the

caching_sha2_password encryption method, so I can switch to PHP7.2 here;

Without changing the configuration, you can use the following method to change the encryption method of mysql8 and change the password for the root user:

USE mysql;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;

Newly install php7.2;

apt-get install php7.2-fpm php7.2-mysql and other extensions;

Change the listening port to something else, and nginx reverse proxy this port.

For more php7 related knowledge, please visit the

php7 tutorial column!

The above is the detailed content of Detailed explanation of PHP7.4 and MySQL8 certification issues. For more information, please follow other related articles on the PHP Chinese website!