本帖最后由 Allen-zhang 于 2017-4-8 14:39 编辑

本人刚学会MySQL的基本架设和连接,但是因为服务器某个**管理想弄支持php的就乱弄,导致本来好好的MySQL出现无法连接的情况,PermissionEX只是其中的一个,全体MySQL集体崩盘,不知道为何。本人仔细检查了数据库的各项,结果还是暴毙,网上的各个方法都不适用于我 = =
后台报告->
[PermissionsEx]
========== UNABLE TO LOAD PERMISSIONS BACKEND =========
Your configuration must be fixed before PEX will enable
Details: Unable to connect to SQL database
=======================================================
ru.tehkode.permissions.exceptions.PermissionBackendException: Unable to connect to SQL database
        at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:118) ~[PermissionsEx.jar:?]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
        at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_121]
        at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:392) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:367) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:624) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:606) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:693) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:67) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:175) [PermissionsEx.jar:?]
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at java.lang.Thread.run(Unknown Source) [?:1.8.0_121]
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
        at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_121]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:687) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1090) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
        at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_121]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:245) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:112) ~[PermissionsEx.jar:?]
        ... 22 more
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:611) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1090) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
        at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_121]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
        at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:245) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:112) ~[PermissionsEx.jar:?]
        ... 22 more
[14:34:08] [Server thread/INFO]: [PermissionsEx] Disabling PermissionsEx v1.23.4Pex Config->
multiserver:
  use-netevents: true
permissions:
  debug: false
  allowOps: true
  user-add-groups-last: false
  log-players: false
  createUserRecords: false
  backend: sql
  informplayers:
    changes: false
  basedir: plugins/PermissionsEx
  backends:
    sql:
      uri: mysql://localhost/permissions
      user: root
      password: MYSQL
      type: sql
    file:
      type: file
      file: permissions.yml
updater: true
alwaysUpdate: false

2021.12 数据，可能有更多内容

本人刚学会MySQL的基本架设和连接,但是因为服务器某个**管理想弄支持php的就乱弄,导致本来好好的MySQL出现无法连接的情况,PermissionEX只是其中的一个,全体MySQL集体崩盘,不知道为何。本人仔细检查了数据库的各项,结果还是暴毙,网上的各个方法都不适用于我 = =
后台报告-&gt;
[PermissionsEx]
========== UNABLE TO LOAD PERMISSIONS BACKEND =========
Your configuration must be fixed before PEX will enable
Details: Unable to connect to SQL database
=======================================================
ru.tehkode.permissions.exceptions.PermissionBackendException: Unable to connect to SQL database
  at ru.tehkode.permissions.backends.sql.SQLBackend.&lt;init&gt;(SQLBackend.java:118) ~[PermissionsEx.jar:?]
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
  at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_121]
  at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:392) ~[PermissionsEx.jar:?]
  at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:367) ~[PermissionsEx.jar:?]
  at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:624) ~[PermissionsEx.jar:?]
  at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:606) ~[PermissionsEx.jar:?]
  at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:693) ~[PermissionsEx.jar:?]
  at ru.tehkode.permissions.PermissionManager.&lt;init&gt;(PermissionManager.java:67) ~[PermissionsEx.jar:?]
  at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:175) [PermissionsEx.jar:?]
  at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at java.lang.Thread.run(Unknown Source) [?:1.8.0_121]
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
  at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_121]
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:687) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1090) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.ConnectionImpl.&lt;init&gt;(ConnectionImpl.java:794) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.JDBC4Connection.&lt;init&gt;(JDBC4Connection.java:47) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
  at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_121]
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx.jar:?]
  at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx.jar:?]
  at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx.jar:?]
  at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx.jar:?]
  at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx.jar:?]
  at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx.jar:?]
  at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:245) ~[PermissionsEx.jar:?]
  at ru.tehkode.permissions.backends.sql.SQLBackend.&lt;init&gt;(SQLBackend.java:112) ~[PermissionsEx.jar:?]
  ... 22 more
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
  at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:611) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1090) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.ConnectionImpl.&lt;init&gt;(ConnectionImpl.java:794) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.JDBC4Connection.&lt;init&gt;(JDBC4Connection.java:47) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_121]
  at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_121]
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
  at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx.jar:?]
  at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx.jar:?]
  at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx.jar:?]
  at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx.jar:?]
  at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx.jar:?]
  at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx.jar:?]
  at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:245) ~[PermissionsEx.jar:?]
  at ru.tehkode.permissions.backends.sql.SQLBackend.&lt;init&gt;(SQLBackend.java:112) ~[PermissionsEx.jar:?]
  ... 22 more
[14:34:08] [Server thread/INFO]: [PermissionsEx] Disabling PermissionsEx v1.23.4Pex Config-&gt;
multiserver:
use-netevents: true
permissions:
debug: false
allowOps: true
user-add-groups-last: false
log-players: false
createUserRecords: false
backend: sql
informplayers:
    changes: false
basedir: plugins/PermissionsEx
backends:
    sql:
   uri: mysql://localhost/permissions
   user: root
   password: MYSQL
   type: sql
    file:
   type: file
   file: permissions.yml
updater: true
alwaysUpdate: false

MYSQL有正常運作嗎?
使用者那些都 在嘛
數據庫有在嘛
如果都正常 那就全部的數據庫備份後 刪除重創

我无法确定你的错误在哪,但我感觉是配置出错了
不仅仅指配置文件需要两个之间互相连接,PHP等这种东西也需要设置环境变量

我并没有弄PHP，是一个管理在yy然后自己瞎弄，最后成了这样，一开始都是可以正常连接的，他yy完了就无法连接了，数据库一切正常！

我认为，你在Pex的config.yml配置错误，您方便把config.yml内容发一下吗？

好的OKKKKKKKKKKKKKKKKKKKKK

multiserver:
  use-netevents: true
permissions:
  debug: false
  allowOps: true
  user-add-groups-last: false
  log-players: false
  createUserRecords: false
  backend: basedir
  informplayers:
    changes: false
  basedir: plugins/PermissionsEx
  backends:
    sql:
      uri: mysql://localhost/permissions
      user: root
      password: MySqlPassWord
      type: sql
    basedir:
      type: basedir
      file: permissions.yml
updater: false
alwaysUpdate: false

2333333333333333333333

    sql:
      uri: mysql://localhost/permissions
      user: root
      password: MySqlPassWord
      type: sql

这个MysqlPassWord看起来像一个默认的密码，你确定一下
backend: basedir
这个 改成
backend: sql

不是,这是我为了方便在上面改的,我后台里面写的是MySql的密码,经核对并无错误

backend: basedir
这个 改成
backend: sql

已修改，还是不行