Page 1 of 1

MySQL Error

Posted: Sun Sep 25, 2011 5:09 pm
by 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!

Re: MySQL Error

Posted: Sun Sep 25, 2011 5:17 pm
by 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

Re: MySQL Error

Posted: Sun Sep 25, 2011 5:23 pm
by max0005
Thanks... Now I get a second error... Any idea? :(

Re: MySQL Error

Posted: Sun Sep 25, 2011 5:28 pm
by 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

Re: MySQL Error

Posted: Sun Sep 25, 2011 5:31 pm
by max0005
Still nothing :?

Re: MySQL Error

Posted: Sun Sep 25, 2011 5:38 pm
by 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?

Re: MySQL Error

Posted: Sun Sep 25, 2011 5:41 pm
by 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

Re: MySQL Error

Posted: Sun Sep 25, 2011 5:47 pm
by max0005
Verified Java Version
Congratulations!
You have the recommended Java installed (1.7.0).
:shock: