[Help] My sql error 1045

[Freyr]

1045 access denied for user 'root'@'localhost' using password no

 

I searched on google for that problem but i cannot understand their answers (phpmyadmin bla bla bla)...

 

I need your help, to explain me why this error appears.

[eKo]

i think that error says everything!!!!!.....

 

cmon you cant be that blind?

[Freyr]

i think that error says everything!!!!!.....

 

cmon you cant be that blind?

It is the first time for me to see an error like this.

 

Please next time give me an answer, not an innuendo.

[mogo]

The error says that access to database is denied for user root, which is connecting from localhost (same computer) because you didn't supply any password. Edit your configs... If you know nothing about the password, try 'root' or 'mysql' - those are the usual default passwords for user root

[eKo]

It is the first time for me to see an error like this.

 

Please next time give me an answer, not an innuendo.

 

you can always reconfig your mysql settings in mysql floder/bin and config exe.

 

allso open config floder in l2 server and open server/loginserver setting files in both config floders gameserver config and login config floder

 

and find those lines :

 

# Database info

Driver=com.mysql.jdbc.Driver

#Driver=org.hsqldb.jdbcDriver

#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

URL=jdbc:mysql://localhost/l2jdb

#URL=jdbc:hsqldb:hsql://localhost/l2jdb

#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=

Login= <--- mysql DB username usually root

Password= <--- mysql DB Password

MaximumDbConnections=10

[EvE]

# Database info

Driver=com.mysql.jdbc.Driver

#Driver=org.hsqldb.jdbcDriver

#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

URL=jdbc:mysql://localhost/l2jdb

#URL=jdbc:hsqldb:hsql://localhost/l2jdb

#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=

Login= <--- mysql DB username usually root

Password= <--- mysql DB Password

MaximumDbConnections=10

still blind ? after he explained u all about this mysql error ?

[xAddytzu]

the error has nothing to do with the server >.>

[Freyr]

the error has nothing to do with the server >.>

Thank you all people for your try, but the problem still remain. I've done the steps you told me about database info but nothing.

 

 

 

 

[FighterBoss]

Thank you all people for your try, but the problem still remain. I've done the steps you told me about database info but nothing.

 

 

 

 

When you create the connection what you put?

user

pass

port etc..

 

[Freyr]

When you create the connection what you put?

user

pass

port etc..

 

i don't create any connection. I only create the database. But in connection user is root, without password and the port is 3306.

[xAddytzu]

You should to install MySql >.>

[Freyr]

You should to install MySql >.>

i reconfigure it thousand times

[FighterBoss]

i don't create any connection. I only create the database. But in connection user is root, without password and the port is 3306.

put at password,the password from MySql(maybe root,as many other this pass have) and tell me results.

[Freyr]

put at password,the password from MySql(maybe root,as many other this pass have) and tell me results.

nothing. Here is the database error:

 

[eKo]

the error has nothing to do with the server >.>

 

you can always reconfig your mysql settings in mysql floder/bin and config exe.

 

i guess you didnt read my full post xD i just showed him how to config it right. and + l2server configs

[Freyr]

you can always reconfig your mysql settings in mysql floder/bin and config exe.

 

i guess you didnt read my full post xD i just showed him how to config it right. and + l2server configs

i did it, but nothing.