Skip to content

[Help] My sql error 1045

Featured Replies

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.

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

 

cmon you cant be that blind?

  • Author

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.

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

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

# 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 ?

  • Author

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.

 

 

 

 

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..

 

  • Author

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.
  • Author

You should to install MySql >.>

i reconfigure it thousand times

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.

  • Author

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:

 

2mpju3p.jpg

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

Guest
This topic is now closed to further replies.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.