MySQL issues: Access denied for user (using password: YES)

Discussion in 'Plugin Development' started by SoThatsIt, Nov 15, 2013.

Thread Status:
Not open for further replies.
  1. Offline

    SoThatsIt

    hey, im getting this error when i try to use mysql, how would i fix it:

    Code:
    java.sql.SQLException: Access denied for user 'REMOVED IP :P' (using password: YES)
    11:31:48 [SEVERE]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    11:31:48 [SEVERE]    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    11:31:48 [SEVERE]    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    11:31:48 [SEVERE]    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
    11:31:48 [SEVERE]    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
    11:31:48 [SEVERE]    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
    11:31:48 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    11:31:48 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    11:31:48 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    11:31:48 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    11:31:48 [SEVERE]    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    11:31:48 [SEVERE]    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    11:31:48 [SEVERE]    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    11:31:48 [SEVERE]    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    11:31:48 [SEVERE]    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    11:31:48 [SEVERE]    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    11:31:48 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    11:31:48 [SEVERE]    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    11:31:48 [SEVERE]    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    11:31:48 [SEVERE]    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    11:31:48 [SEVERE]    at me.sothatsit.revolutionarystats.MySQL.open(MySQL.java:34)
    11:31:48 [SEVERE]    at me.sothatsit.revolutionarystats.MySQLHandler.createStatement(MySQLHandler.java:26)
    11:31:48 [SEVERE]    at me.sothatsit.revolutionarystats.MySQLHandler.update(MySQLHandler.java:32)
    11:31:48 [SEVERE]    at me.sothatsit.revolutionarystats.RSListener.updateDatabase(RSListener.java:23)
    11:31:48 [SEVERE]    at me.sothatsit.revolutionarystats.RSListener$1.run(RSListener.java:16)
    11:31:48 [SEVERE]    at org.bukkit.craftbukkit.v1_6_R3.scheduler.CraftTask.run(CraftTask.java:53)
    11:31:48 [SEVERE]    at org.bukkit.craftbukkit.v1_6_R3.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:345)
    11:31:48 [SEVERE]    at net.minecraft.server.v1_6_R3.MinecraftServer.t(MinecraftServer.java:524)
    11:31:48 [SEVERE]    at net.minecraft.server.v1_6_R3.DedicatedServer.t(DedicatedServer.java:227)
    11:31:48 [SEVERE]    at net.minecraft.server.v1_6_R3.MinecraftServer.s(MinecraftServer.java:488)
    11:31:48 [SEVERE]    at net.minecraft.server.v1_6_R3.MinecraftServer.run(MinecraftServer.java:421)
    11:31:48 [SEVERE]    at net.minecraft.server.v1_6_R3.ThreadServerApplication.run(SourceFile:583)
     
  2. Offline

    tenowg

    make sure the user you are trying to access the database with has access - in this case he does not (or you are using the wrong password)
     
  3. Offline

    1Rogue


    And that they're allowed to connect from the network you are connecting from.
     
  4. Offline

    SoThatsIt

    thanks, we found this was the problem and we need to contact the owner of the place where the mysql is stored and ask them to allow access for us.
     
  5. Offline

    1Rogue

    Just ask for all networks on a single-database accessed account. 'user'@'%' or something.
     
Thread Status:
Not open for further replies.

Share This Page