Access Denied

[ultrahazard]

Hello guys, i'm having some trouble with the emulator (I can assure you that the password is correct ): 

[Luciar]

Make sure you have set the SQL server password, not just the server intercommunication password.

 

File: conf/inter_athena.conf

 

 

// Global SQL settings
// overriden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: ragnarok
sql.db_password: ragnarok
sql.db_database: ragnarok
sql.codepage:
 
// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok
 
// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok
 
// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

If this doesn't work, make sure you've configured your MySQL server to accept connections locally Edited June 6, 2013 by luciar

[eJay]

Post ur char and map_athena.conf

Or try to set

Set

Username: ragnarok

Password: ragnarok

Go to mysql

Find ragnarok scheme/login

Change the user and pass at the top as ragnarok

Edited June 6, 2013 by Kim

[ultrahazard]

Char: http://pastebin.com/zujW2YgA

Inter: http://pastebin.com/9YYxcuPK

Map:http://pastebin.com/ZtbXanKt

[Luciar]

Did you make an account on your MySQL server with the username and password both equal to "ragnarok"?

 

If not you need to do that, though I wouldn't use the default info unless this is strictly offline!

[ultrahazard]

Yes, i did, i don't know what the problem is, i'll try do delete it and import again.

 

[EDIT] Same.

Edited June 6, 2013 by ultrahazard

[eJay]

Can we see ur login.sql at ur mysql

[Myth]

i have the same problem

[Winz]

Can we see ur login.sql at ur mysql

Hey Kim, #clarifying:

 

"Can we see ur login table at ur mysql database?"

 

1. Make sure that the first entry inside the login table is:

account_id: 1

name: oly

password: oly

sex: S

(and others set to 0)

 

2. If still not working, then give the permissions to the 'ragnarok' user

3. (Linux) if you're using linux operating systems, remember to do the Linux's post-install MySQL server.

[Asura]

Hi ultrahazard,

 

The issue is with your MySQL server; it can be multiple things...

 

1) Is your MySQL server running properly?

2) Do you have a MySQL user named "ragnarok", and have you put the correct password for the "ragnarok" user in 'inter_athena.conf'?

 

You must make sure you are using the information to log into your MySQL server in 'inter_athena.conf', and not the `login` table information.