mac php 连接mysql,Mac PHP连接MySQL8报错

Mac 安装mysql

brew install mysql

安装完8.0使用navicate无法连接则

mysql -u root -p 登录mysql

执行1:ALTER USER 'root'@'localhost' IDENTIFIED BY '你的mysql密码' PASSWORD EXPIRE NEVER;

执行2:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的mysql密码';

执行3: FLUSH PRIVILEGES;

PHP连接MySql错误信息：

PDOException in Connection.php line 295

The server requested authentication method unknown to the client

解决方案：

确保php.ini文件中mysql扩展打开状态

找到my.cnf文件在末尾追加

innodb_buffer_pool_size = 16M

innodb_additional_mem_pool_size = 2M

innodb_log_file_size = 5M

innodb_log_buffer_size = 8M