MySQL Error

[max0005]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number: 4470
L2JDP Revision Number: 7733

Dear All,

I am having issues starting the login server. I correctly configured all other options, but it is still failing authentication. It is a locahost database (host: localhost) with root account having no password. Settings are the same for phpmyadmin which correctly authenticates, however, the login server, having following set:

Code: Select all

Driver = com.mysql.jdbc.Driver#Driver = org.hsqldb.jdbcDriver#Driver = com.microsoft.sqlserver.jdbc.SQLServerDriverURL = jdbc:mysql:///l2jdb#URL = jdbc:hsqldb:hsql://localhost/l2jdb#URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password = #Database user info (using root user is not recommended)Login = rootPassword =

Returns "access denied".

Help please? Thanks!

[asumos]

 Driver = com.mysql.jdbc.Driver
#Driver = org.hsqldb.jdbcDriver
#Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
  URL = jdbc:mysql:///l2jdb
#URL = jdbc:hsqldb:hsql://localhost/l2jdb
#URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =
#Database user info (using root user is not recommended)
Login = root
Password =

needs to be

URL = jdbc:mysql://localhost/l2jdb

its also not recommended to run mysql with no password

[max0005]

Thanks... Now I get a second error... Any idea?

[asumos]

only thing i can think of is the blank password. you probably need to edit mysql settings to include a password on root then update the conf file with the password

most database accessing programs cant handle a blank password correctly

[max0005]

Still nothing

[max0005]

I'm sorry... I upgraded today to the latest release both of JDK and JRE, what can I do to check they are properly functioning?

[asumos]

best i can think of is java's verify

http://java.com/en/download/installed.jsp

glad you saw my previous post seems to have disappeared

[max0005]

Verified Java Version
Congratulations!
You have the recommended Java installed (1.7.0).