3.7K Star 12K Fork 4.6K

卓源软件 / JeeSite 4.2

 / 详情

数据库初始化报错

Backlog
Opened this issue  
2021-05-17 17:33

该问题是怎么引起的?

数据库初始化,创建用户和授权时报错

报错信息

Error Code: 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

set global read_only=0;
set global optimizer_switch='derived_merge=off'; 
create user 'jeesite'@'%' identified by 'jeesite';
create database jeesite DEFAULT CHARSET 'utf8' COLLATE 'utf8_general_ci';   
grant all privileges on jeesite.* to 'jeesite'@'%' identified by 'jeesite';
flush privileges;

Comments (0)

啊宝 created任务
啊宝 set related repository to 卓源软件/JeeSite 4.2
展开全部操作日志

Sign in to comment

状态
Assignees
Milestones
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
Branches
Planed to start   -   Planed to end
-
Top level
Priority
参与者(1)
Java
1
https://gitee.com/thinkgem/jeesite4.git
git@gitee.com:thinkgem/jeesite4.git
thinkgem
jeesite4
JeeSite 4.2

Search