Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

is not allowed to connect to this MySQL server #99

Open
xiaoxiaodemeng opened this issue Jul 24, 2019 · 14 comments
Open

is not allowed to connect to this MySQL server #99

xiaoxiaodemeng opened this issue Jul 24, 2019 · 14 comments

Comments

@xiaoxiaodemeng
Copy link

@xiaoxiaodemeng xiaoxiaodemeng commented Jul 24, 2019

环境信息

  • 系统:
  • JDK:
  • 数据库:
  • APIJSON:

问题描述

错误信息

@TommyLemon
Copy link
Member

@TommyLemon TommyLemon commented Jul 24, 2019

检查下 APIJSON 项目 的 数据库配置 DemoSQLConfig 里的
database, dbVersion, dbUrl, dbAccount, dbPassword, schema
是否正确

@TommyLemon
Copy link
Member

@TommyLemon TommyLemon commented Jul 24, 2019

如果确定正确但还是有这个问题,麻烦把 报错日志、数据库的信息、以及你改过的 DemoSQLConfig 代码贴出来

@xiaoxiaodemeng
Copy link
Author

@xiaoxiaodemeng xiaoxiaodemeng commented Jul 24, 2019

那个问题没了,
image

@xiaoxiaodemeng
Copy link
Author

@xiaoxiaodemeng xiaoxiaodemeng commented Jul 24, 2019

有报错

@TommyLemon
Copy link
Member

@TommyLemon TommyLemon commented Jul 24, 2019

MySQL/sys.sql 是所有表 sql 打包后的集合,要用 Import from Self-Contained File 的方式。
不过还是建议 Import from Dump Project Folder,选 MySQL/single,把里面的单个表 sql 文件导入。

@xiaoxiaodemeng
Copy link
Author

@xiaoxiaodemeng xiaoxiaodemeng commented Jul 24, 2019

image

@xiaoxiaodemeng
Copy link
Author

@xiaoxiaodemeng xiaoxiaodemeng commented Jul 24, 2019

image

@TommyLemon
Copy link
Member

@TommyLemon TommyLemon commented Jul 24, 2019

应该是你的 URL 写错了,可以在浏览器输入框用
http://localhost:8080/get/%7B%7D
验证。

建议使用 APIAuto 自动化接口管理工具 来测试接口
http://apijson.org/auto/

@xiaoxiaodemeng
Copy link
Author

@xiaoxiaodemeng xiaoxiaodemeng commented Jul 24, 2019

改动一:改了端口:所以用localhost:8888

改动二:改了数据库地址:localhost:3306 / 用户名 root / 密码 xxxxxxx / 增加了数据库名【源码里没了数据库名这段代码getSchema()】
image
image

@TommyLemon
Copy link
Member

@TommyLemon TommyLemon commented Jul 24, 2019

除了服务器版本不一样,其它没啥问题。
按照上面的方式,现在接口能正常访问吗?

如果调用了接口,权限校验(Access 表配置)通过的话,控制台应该会有 SQL 语句输出的。

@xiaoxiaodemeng
Copy link
Author

@xiaoxiaodemeng xiaoxiaodemeng commented Jul 24, 2019

不能访问自己的

@TommyLemon
Copy link
Member

@TommyLemon TommyLemon commented Jul 24, 2019

APIJSON 自动生成的 SQL 语句发下,可以复制粘贴到 Navicat 里执行看看。

@yangkebiao
Copy link

@yangkebiao yangkebiao commented May 11, 2020

apijson-boot 4.0.0, 在启动DemoApplication的时候报错了。DemoSQLConfig调整未生效。调试发现类对象变了,getDBVersion返回的是5.x.x,而非我配置的8.x.x
image
image

错误

APIJSONFunctionParser.ERROR:
远程函数文档测试未通过!
请新增 demo 里的函数,或修改 Function 表里的 demo 为已有的函数示例!
保证前端看到的远程函数文档是正确的!!!

原因:
!!!! 查询远程函数异常 !!!
Access denied for user 'root'@'localhost' (using password: YES)

@TommyLemon
Copy link
Member

@TommyLemon TommyLemon commented May 16, 2020

!!!! 查询远程函数异常 !!!

可能除了 maven 依赖 apijson-framework 还多依赖了 apijson-orm.jar,把 apijson-orm.jar 依赖去掉

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants
You can’t perform that action at this time.