Symfony 3 ???????? MySQL ??????? ????? ???. ??? Symfony ?? ???? MySQL ???? ????? ?? ?? ??? ?????. PDO::__construct(): 服務器發(fā)送了客戶端未知的字符集 (255)。請向開發(fā)者報告
PHP? MySQL? ?? Docker ?????? ?????.
MySQL ??: 8.0.1
PHP ??: 7.1.3
????:pdo_mysql
??? ??:UTF8
dsn: "mysql:host=mysql;dbname=database;charset=UTF8;"
?? ????? ????
MySQL 8.0.11? ?????? ? PHP? mysqli_connect()
函數(shù)時遇到了與OP相同的問題。在我的 MySQL 目錄(在我的例子中,usr/local/mysql
)中,我創(chuàng)建了 my.cnf
??? ???? ??? ??? ??? ???? MySQL ??? ?? ??????. ??? ?? ?? ??? ??? ??????.
mysqli_connect():服務器請求客戶端未知的身份驗證方法 [caching_sha2_password]
??? ????? default_authentication_plugin = mysql_native_password
,所以 my.cnf
?? ??? ????:
?? ?? ???!
? ?? ????: https://github.com/laradock/laradock/issues/1392
ARA1307? ??? ?????:
"? ???? ???? "IDENTIFIED WITH mysql_native_password"? ????? ???? ?? ???? ???? ???. ?: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
"
MySQL 8? ?? ?? ??? utf8mb4? ?????. ??? ?? ??? ? ?? ??? ????. ??? ? ??? ??? ?? ?? ??? ?????? ???? ?????? ??? ??? ??? ?? ?????.
?? https://bugs.mysql.com/bug.php?id= 71606
? ??? MySQL Connector/C++?? ????? PHP?? ??? ??? ????.
??? ???? ?????? ??????? ????. ??? ??? ??????? ?? ?????? ????? ??? ?? ??? utf8? ???? ???? ????. /etc/my.cnf? ???? mysqld? ?? ??????:
???2010? ???? ?? ??? ?????. my.cnf? MySQL ?? ?? ??? UTF-8? ?????????