本帖最后由 专业团队 于 2020-5-5 19:53 编辑

用惯了phpstudy,买了腾讯云MySQL过后完全不懂.有大佬给教授一下经验吗？
我的库

在插件配置文件中
找到关于mysql的选项
启用mysql，然后输入ip，密码一类就可以了

大部分插件都支持mysql

这个谁都知道啊...我连接了没反应

发一下服务端日志

你的VPS和你的MySQL买在同一个地区吗？
不是同一个地区是用不了的

有外网端口

先试一下用Navicat之类的软件在你服务器的vps上连一下看看能不能连上去

能连上去的话使用方式应该和你开在本地的数据库没什么关系

phpMyAdmin可以正常连接

发一下服务端日志

2 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:49:52 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[19:49:52 WARN]:        at com.mysql.jdbc.Util.getInstance(Util.java:408)
[19:49:52 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
[19:49:52 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
[19:49:52 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
[19:49:52 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2094)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2019)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
[19:49:52 WARN]:        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:49:52 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
[19:49:52 WARN]:        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
[19:49:52 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
[19:49:52 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
[19:49:52 WARN]:        at com.Zrips.CMI.Modules.DataBase.DBConnectionPool.getConnection(DBConnectionPool.java:34)
[19:49:52 WARN]:        at com.Zrips.CMI.Modules.DataBase.DBDAO.<init>(DBDAO.java:489)
[19:49:52 WARN]:        at com.Zrips.CMI.Modules.DataBase.DBMySQL.<init>(DBMySQL.java:18)
[19:49:52 WARN]:        at com.Zrips.CMI.Modules.DataBase.DBManager.startMysql(DBManager.java:171)
[19:49:52 WARN]:        at com.Zrips.CMI.Modules.DataBase.DBManager.load(DBManager.java:126)
[19:49:52 WARN]:        at com.Zrips.CMI.Config.load(Config.java:707)
[19:49:52 WARN]:        at com.Zrips.CMI.Config.load(Config.java:689)
[19:49:52 WARN]:        at com.Zrips.CMI.CMI.onEnable(CMI.java:1440)
[19:49:52 WARN]:        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)
[19:49:52 WARN]:        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
[19:49:52 WARN]:        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:403)
[19:49:52 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:381)
[19:49:52 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:330)
[19:49:52 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.t(MinecraftServer.java:422)
[19:49:52 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.l(MinecraftServer.java:383)
[19:49:52 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.a(MinecraftServer.java:338)
[19:49:52 WARN]:        at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:272)
[19:49:52 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:545)
[19:49:52 WARN]:        at java.lang.Thread.run(Unknown Source)
[19:49:52 WARN]: 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.
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:49:52 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[19:49:52 WARN]:        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
[19:49:52 WARN]:        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2186)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2035)
[19:49:52 WARN]:        ... 31 more
[19:49:52 WARN]: Caused by: java.net.ConnectException: Connection timed out: connect
[19:49:52 WARN]:        at java.net.DualStackPlainSocketImpl.connect0(Native Method)
[19:49:52 WARN]:        at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
[19:49:52 WARN]:        at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
[19:49:52 WARN]:        at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
[19:49:52 WARN]:        at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
[19:49:52 WARN]:        at java.net.PlainSocketImpl.connect(Unknown Source)
[19:49:52 WARN]:        at java.net.SocksSocketImpl.connect(Unknown Source)
[19:49:52 WARN]:        at java.net.Socket.connect(Unknown Source)
[19:49:52 WARN]:        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
[19:49:52 WARN]:        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
[19:49:52 WARN]:        ... 33 more

他的提示.说的是连接没有反馈

2 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:49:52 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[19:49:52 WARN]:        at com.mysql.jdbc.Util.getInstance(Util.java:408)
[19:49:52 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
[19:49:52 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
[19:49:52 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
[19:49:52 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2094)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2019)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
[19:49:52 WARN]:        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:49:52 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
[19:49:52 WARN]:        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
[19:49:52 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
[19:49:52 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
[19:49:52 WARN]:        at com.Zrips.CMI.Modules.DataBase.DBConnectionPool.getConnection(DBConnectionPool.java:34)
[19:49:52 WARN]:        at com.Zrips.CMI.Modules.DataBase.DBDAO.<init>(DBDAO.java:489)
[19:49:52 WARN]:        at com.Zrips.CMI.Modules.DataBase.DBMySQL.<init>(DBMySQL.java:18)
[19:49:52 WARN]:        at com.Zrips.CMI.Modules.DataBase.DBManager.startMysql(DBManager.java:171)
[19:49:52 WARN]:        at com.Zrips.CMI.Modules.DataBase.DBManager.load(DBManager.java:126)
[19:49:52 WARN]:        at com.Zrips.CMI.Config.load(Config.java:707)
[19:49:52 WARN]:        at com.Zrips.CMI.Config.load(Config.java:689)
[19:49:52 WARN]:        at com.Zrips.CMI.CMI.onEnable(CMI.java:1440)
[19:49:52 WARN]:        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)
[19:49:52 WARN]:        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
[19:49:52 WARN]:        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:403)
[19:49:52 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:381)
[19:49:52 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:330)
[19:49:52 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.t(MinecraftServer.java:422)
[19:49:52 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.l(MinecraftServer.java:383)
[19:49:52 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.a(MinecraftServer.java:338)
[19:49:52 WARN]:        at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:272)
[19:49:52 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:545)
[19:49:52 WARN]:        at java.lang.Thread.run(Unknown Source)
[19:49:52 WARN]: 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.
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:49:52 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:49:52 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:49:52 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[19:49:52 WARN]:        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
[19:49:52 WARN]:        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2186)
[19:49:52 WARN]:        at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2035)
[19:49:52 WARN]:        ... 31 more
[19:49:52 WARN]: Caused by: java.net.ConnectException: Connection timed out: connect
[19:49:52 WARN]:        at java.net.DualStackPlainSocketImpl.connect0(Native Method)
[19:49:52 WARN]:        at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
[19:49:52 WARN]:        at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
[19:49:52 WARN]:        at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
[19:49:52 WARN]:        at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
[19:49:52 WARN]:        at java.net.PlainSocketImpl.connect(Unknown Source)
[19:49:52 WARN]:        at java.net.SocksSocketImpl.connect(Unknown Source)
[19:49:52 WARN]:        at java.net.Socket.connect(Unknown Source)
[19:49:52 WARN]:        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
[19:49:52 WARN]:        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
[19:49:52 WARN]:        ... 33 more

检查用户名和密码
如果配置文件内有说mysql版本号，就改为mysql数据库的版本

服务器开多久了？云数据库是不是新租的？
你转移MYSQL数据库的时候是直接复制粘贴的？

没有用户名密码都没问题

本帖最后由 EmptyLava 于 2020-5-5 19:59 编辑

参照这个
https://www.cnblogs.com/fzu-zzr/p/11216657.htmlhttps://www.wandouip.com/t5i213972/