Score
0
Watch 3.3K Star 7.4K Fork 3.5K

卓源软件 / JeeSite 4.xJavaAGPL-3.0

执行sql一直报错引号不对

Open
华夏九州  Opened this issue

该问题是怎么引起的?

执行该语句grant all privileges on jeesite.* to 'jeesite'@'%' identified by 'jeesite';报错
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'jeesite'' at line 1

重现步骤

navicat for mysql工具中或者直接dos命令执行都可以复现,根据项目文档创建用户授权时候执行此语句即可发现。怎么改都有问题,修改字符集也不起作用。数据库版本采用mysql-8.0.18-winx64

报错信息

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'jeesite'' at line 1

total 2 participants

Comments (1)

snowmangood 2020-02-13 16:19

我也是这样!

Sign in to comment

Assignees
Labels
Not set
Projects
Milestones
Branches
Planed to start
Not set
Planed to end
Not set
Top level
Priority
Java
1
https://gitee.com/thinkgem/jeesite4.git
git@gitee.com:thinkgem/jeesite4.git
thinkgem
jeesite4
JeeSite 4.x

Help Search