search

louislivi / SMProxy

Swoole MySQL Proxy 一个基于 MySQL 协议，Swoole 开发的MySQL数据库连接池。 A MySQL database connection pool based on MySQL protocol and Swoole.
https://smproxy.louislivi.com
MIT License
1.78k stars 258 forks source link

报NO_AUTO_CREATE_USER错误 #89

Open wuxuejian opened 3 years ago

wuxuejian commented 3 years ago

Describe Your Environment (描述你的环境)

How to Reproduce the Problem? (如何重现问题)

Laravel 8 数据库连接参数改成smproxy后报 Syntax error or access violation: 1231 42000Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

image

bobojx commented 3 years ago

这个问题百度一下就能解决，MySQL配置中的sql-mode选项的值增加一个NO_AUTO_CREATE_USER就行了，先百度找答案再提问！！！！！