нужна помощь Конект к БД

[Banas1k 0]

Проблема с конектом к бд, базу создал/залили, но гейм и логин не конектится к БД. Запускаю на win

Лог

04 (16:18:26)#Welcome to pwLogin.
04 (16:18:26)#Configs: loaded.
04 (16:18:26)#Black IPs: 0 loaded.
04 (16:18:26)#White IPs: loaded.
04 (16:18:27)#DATABASE: [ERROR] Failed initializing.
04 (16:18:27)#Reason: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost/l2, username = root             . Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
java.sql.SQLException: Unknown system variable 'language'
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432)
        at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3870)
        at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3284)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2293)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:363)
        at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416)
        at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)
        at net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:68)
        at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:123)
        at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:168)
        at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:64)
------


Server terminated abnormaly


server terminated

Для продолжения нажмите любую клавишу . . .

[zGosu 396]

Я уже много раз писал решения по этой проблеме. Вбейте в поиск: Unknown system variable 'language'

[Banas1k 0]

Не нашел, установил mysql 5.5 - проблема решилась.

 

/close