SoulGateKey
PEX死活连不上mysql pex开启及报错信息：
  1. [PermissionsEx] Enabling PermissionsEx v1.23.3
  2. [18:45:30 INFO]: [PermissionsEx] Initializing sql backend
  3. [18:45:30 ERROR]: [PermissionsEx]
  4. ========== UNABLE TO LOAD PERMISSIONS BACKEND =========
  5. Your configuration must be fixed before PEX will enable
  6. Details: Unable to connect to SQL database
  7. =======================================================
  8. ru.tehkode.permissions.exceptions.PermissionBackendException: Unable to connect to SQL database
  9.         at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:118) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  10.         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_261]
  11.         at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
  12.         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
  13.         at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_261]
  14.         at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:392) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  15.         at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:367) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  16.         at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:624) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  17.         at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:606) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  18.         at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:693) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  19.         at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:67) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  20.         at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:175) [PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  21.         at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  22.         at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:332) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  23.         at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:407) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  24.         at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:359) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  25.         at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:318) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  26.         at org.bukkit.craftbukkit.v1_8_R3.CraftServer.reload(CraftServer.java:769) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  27.         at org.bukkit.Bukkit.reload(Bukkit.java:556) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  28.         at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:25) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  29.         at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:146) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  30.         at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:666) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  31.         at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchServerCommand(CraftServer.java:629) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  32.         at net.minecraft.server.v1_8_R3.DedicatedServer.aO(DedicatedServer.java:416) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  33.         at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:379) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  34.         at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:713) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  35.         at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:616) [PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  36.         at java.lang.Thread.run(Unknown Source) [?:1.8.0_261]
  37. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  38.         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_261]
  39.         at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
  40.         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
  41.         at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_261]
  42.         at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  43.         at com.mysql.jdbc.Util.getInstance(Util.java:382) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  44.         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  45.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  46.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  47.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  48.         at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  49.         at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  50.         at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  51.         at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  52.         at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  53.         at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  54.         at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  55.         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_261]
  56.         at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
  57.         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
  58.         at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_261]
  59.         at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  60.         at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  61.         at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[PaperSpigot-1.8.8.jar:git-PaperSpigot-"4c7641d"]
  62.         at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  63.         at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  64.         at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  65.         at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  66.         at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  67.         at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  68.         at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:245) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  69.         at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:112) ~[PermissionsEx-1.23.3%5B1.8%5D.jar:?]
  70.         ... 27 more
  71. [18:45:30 INFO]: [PermissionsEx] Disabling PermissionsEx v1.23.3
复制代码


DreamVoid
请手动创建名为"pex"的数据库
命令行指令：
  1. create database pex;
复制代码
南柯郡守
数据库版本太低了 升级mysql数据库
SoulGateKey
南柯郡守 发表于 2020-8-23 20:12
数据库版本太低了 升级mysql数据库

MYSQL 和navicat都是使用的最新版本 并且MYSQL也是FULL全装的
SoulGateKey
DreamVoid 发表于 2020-8-23 19:42
请手动创建名为"pex"的数据库
命令行指令：

不能用 无论输入到mysql shell还是cmd里的mysql还是服务端都没用
SoulGateKey
还有打开sql后pex就无法正常装载了
南柯郡守
看这篇文章尝试解决
https://blog.csdn.net/yubin1285570923/article/details/83352491
SoulGateKey
南柯郡守 发表于 2020-8-23 22:07
看这篇文章尝试解决
https://blog.csdn.net/yubin1285570923/article/details/83352491

我navicat连的上数据库 做的更改也可以在mysql workbench看到
The_jimeng
等等...你貌似没有创建名为 pex的数据库==
SoulGateKey
The_jimeng 发表于 2020-8-23 22:33
等等...你貌似没有创建名为 pex的数据库==

创建了也不行 这个截图错了
The_jimeng
zhulongcaohello 发表于 2020-8-23 22:47
创建了也不行 这个截图错了

发一下 您创建的截图 == 如果实在不行可以加我q 1837096479 可远程
南柯郡守
zhulongcaohello 发表于 2020-8-23 22:19
我navicat连的上数据库 做的更改也可以在mysql workbench看到

navicat能连上不一定插件用的方法就能连上
navicat或许有自动修改密码编码的功能
但是插件没有
第一页 上一页 下一页 最后一页