iDkTeam/HelpTicket — Issue #5: "SQLException: Access denied for user 'minecraft'@'localhost' (using password: YES)", but credentials work otherwise
Author: FabianN
Created: 2012-02-05 21:22:13+00:00
State: open

I am trying to install and setup your plugin but it seems like the MySQL password is getting rejected.

```
2012-02-05 13:17:59 [INFO] [HelpTicket] Loading HelpTicket v1.6.
2012-02-05 13:17:59 [INFO] [HelpTicket] Using: Mail
2012-02-05 13:17:59 [INFO] SQLException: Access denied for user 'minecraft'@'localhost' (using password: YES)
2012-02-05 13:17:59 [INFO] SQLState: 28000
2012-02-05 13:17:59 [INFO] VendorError: 1045
2012-02-05 13:17:59 [SEVERE] Error occurred while enabling HelpTicket v1.6 (Is it up to date?): [HelpTicket] Failed to create connection to Mysql database
com.avaje.ebeaninternal.server.lib.sql.DataSourceException: [HelpTicket] Failed to create connection to Mysql database
at com.imdeity.helpticket.db.MySQLConnector.(MySQLConnector.java:34)
at com.imdeity.helpticket.HelpTicket.loadDatabase(HelpTicket.java:87)
at com.imdeity.helpticket.HelpTicket.onEnable(HelpTicket.java:41)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:231)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:1057)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:379)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:191)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:174)
at net.minecraft.server.MinecraftServer.t(MinecraftServer.java:357)
at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:344)
at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:175)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:408)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
```

Thing is, I have confirmed that the login credentials work. The same login info works for other plugins, it works for command-line connection from the local machine, works for remote connection, and works via phpmyadmin. Only for this one plugin does it not work (Oh, and also your mail plugin seems to have the same issue, but that seems to be dependent of the HelpTicket plugin working in the first place).

I even tried giving the plugin the root login credentials to see what would happen, same error.

I have a handful of other plugins already working off of MySQL. I don't understand why this one wouldn't, unless maybe you are not parsing characters correctly. The minecraft MySQL pass has these characters:
Upper-case letters, lower-case letters, numbers, &, %