MySQL ERROR - Access denied for user

[OverFive]

Hi I want to installing the jts3 Hosting Edition, but I try to start it and it gives me this error:

Code Select Expand

JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016) Instance Manager started...
Writing InstanceManager log file to: /root/JTS3ServerMod_HostingEdition/JTS3ServerMod_InstanceManager.log
Loading InstanceManager config file from: /root/JTS3ServerMod_HostingEdition/config/JTS3ServerMod_InstanceManager.cfg
Critical: Cannot connect to MySQL server for logging!
MySQL mode enabled!
Error while connecting to database: java.sql.SQLException: Access denied for user 'JTS3'@'localhost' (using password: YES)
Error while loading the JTS3ServerMod InstanceManager config file, read error messages above to know more. Quitting now...

This is the jts3 log:

Code Select Expand

2017-01-22 09:32:29 START_MANAGER JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016) Instance Manager started...
2017-01-22 09:32:29 CONFIG Loading InstanceManager config file from: /root/JTS3ServerMod_HostingEdition/config/JTS3ServerMod_InstanceManager.cfg
2017-01-22 09:32:29 CONFIG Bot chat command !exec is disabled!
2017-01-22 09:32:29 CONFIG Multi IP Mode disabled!
2017-01-22 09:32:30 LOGGER_SQL_ERROR Critical: Cannot connect to MySQL server for logging!
2017-01-22 09:32:30 JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016): EXCEPTION
java.sql.SQLException: Access denied for user 'JTS3'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at de.stefan1200.util.MySQLConnect.connect(Unknown Source)
at de.stefan1200.jts3servermod.u.a(Unknown Source)
at de.stefan1200.jts3servermod.u.<init>(Unknown Source)
at de.stefan1200.jts3servermod.f.c(Unknown Source)
at de.stefan1200.jts3servermod.f.<init>(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.main(Unknown Source)
2017-01-22 09:32:30 CONFIG MySQL mode enabled!
2017-01-22 09:32:30 MYSQL_ERROR Error while connecting to database: java.sql.SQLException: Access denied for user 'JTS3'@'localhost' (using password: YES)
2017-01-22 09:32:30 JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016): EXCEPTION
java.sql.SQLException: Access denied for user 'JTS3'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at de.stefan1200.util.MySQLConnect.connect(Unknown Source)
at de.stefan1200.jts3servermod.f.e(Unknown Source)
at de.stefan1200.jts3servermod.f.c(Unknown Source)
at de.stefan1200.jts3servermod.f.<init>(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.main(Unknown Source)
2017-01-22 09:32:30 QUIT_MANAGER Error while loading the JTS3ServerMod InstanceManager config file, read error messages above to know more. Quitting now...


[Stefan1200]

This is the error message from the MySQL server:
Access denied for user 'JTS3'@'localhost' (using password: YES)

[OverFive]

I know but all information is correct as I can fix?

[OverFive]

can you help me with a team wewer session or another?

[Stefan1200]

I know but all information is correct as I can fix?

Well, if the username and password is correct, it seems that the MySQL user JTS3 is not allowed to connect from locahost. This is not a JTS3ServerMod related error, that is MySQL related.

Moved to the right sub forum.

[OverFive]

but it is quite correct because the webinterface you can connect but the bot no and have the same database and same account

[Stefan1200]

but it is quite correct because the webinterface you can connect but the bot no and have the same database and same account

Maybe you have a space behind the MySQL password in the JTS3ServerMod_InstanceManager.cfg?

[OverFive]

It must be attacked at = or detached?

[Stefan1200]

It must be attacked at = or detached?

As far as I know the space between = and the password will be removed, but if you have a space behind the password, it will be used as password. But just test it and write the password directly behind the = without any spaces.

[OverFive]

It should not be the same settings are these:

Code Select Expand

# Use a MySQL database to save bot instances and configurations. 1 = Enable, 0 = Disable
# There should be a structure sql file in the documents directory.
# Import this into your MySQL database to create the tables (the included web interface do this already for you).
# But you must fill this tables by yourself, the bot just reads the information out there.
mysql_enable = 1
mysql_host = 127.0.0.1
mysql_port = 3306
mysql_user = JTS3
mysql_password =1eZT1crjLCZaxXIV
mysql_database = JTS3


[Stefan1200]

You have a space behind the password, just remove it.

[OverFive]

So?

Code Select Expand

mysql_enable = 1
mysql_host = 127.0.0.1
mysql_port = 3306
mysql_user = JTS3
mysql_password = 1eZT1crjLCZaxXIV
mysql_database = JTS3


[Stefan1200]

You know the word "behind"?

[OverFive]

Behind how? You can post the part of the password I'm not understanding.

[OverFive]

Then? How should I do?