?????? ?42 - MySQL 8 ? caching_sha2_password - a podcast by Пятиминутка PHP

?? ???? ????? ??????????? MySQL 8, ?? ??? ??????????? ?? PHP ??????? ??????. ????????, ????? ?????? ?? ??????????? ?? StackOverflow ? ? ????????? ?????? - ?????? ?????????? ????????? ?????????? ????????? ????????, ??????????? ??????????, ?? ??? ?? ??? ????! ???? ???????????, ??? ?????????? ?????????? ? ??? ????????? ??????????

- https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password/
- https://bugs.php.net/bug.php?id=76651
- http://databaseblog.myname.nl/2018/02/how-cachingsha2password-leaks-passwords.html
- http://mysqlblog.fivefarmers.com/2015/08/31/protecting-mysql-passwords-with-sha256_password-plugin/


?????????? ??????????? ? MySQL 8.0.13 ?? ????????? ?????? PHP ??? ???? ????????? ????????????? (mysql_native_password ? cached_sha2_password) ??? ???????? ?? ????????? default-authentication-plugin=cached_sha2_password
=====================================

PHP 7.2.5:
- user_mysql_native: success
- user_cached_sha2: The server requested authentication method unknown to the client [caching_sha2_password]

PHP 7.2.9:
- user_mysql_native: Unexpected server respose while doing caching_sha2 auth: 109
- user_cached_sha2: success

PHP 7.3.0RC5
- user_mysql_native: success
- user_cached_sha2: The server requested authentication method unknown to the client [caching_sha2_password]


?????????? ??????????? ? MySQL 8.0.13 ?? ????????? ?????? PHP ??? ???? ????????? ????????????? (mysql_native_password ? cached_sha2_password) ??? ???????? default-authentication-plugin=mysql_native_password
===================================================

PHP 7.2.5:
- user_mysql_native: success
- user_cached_sha2: The server requested authentication method unknown to the client [caching_sha2_password]

PHP 7.2.9
- user_mysql_native: success
- user_cached_sha2: success

PHP 7.3.0RC5
- user_mysql_native: success
- user_cached_sha2: The server requested authentication method unknown to the client [caching_sha2_password]


??????????? PHP - ??????? ? ???????? ?? ???? PHP, ?????????? ?????? ? ?????? ? ??????????? ???????? ? ??????????. https://5minphp.ru

Further episodes of ??????????? PHP

Further podcasts by Пятиминутка PHP

Website of Пятиминутка PHP