Access denied for user 'ragnarok'@'localhost'

[Narasya]

Hello!

I hope I'm in the right section!

 

I'm feeling so desperate right now... I recently changed my computer and had to install MySQL workbench again and change a few things on my server (for example the IP). The server had no problems and I could play it without an error. But today, when I tried to start it again, this error occurred:

 

 

I already searched online for the error and I checked the user and password - they match. I'm feeling really dumb for not finding the problem.

 

This is my database:

 

the login name and password is ragnarok

And this is my inter_athena.conf:

 

// MySQL Login server

login_server_ip: 127.0.0.1

login_server_port: 3306

login_server_id: ragnarok

login_server_pw: ragnarok

login_server_db: ragnarok

login_codepage:

login_case_sensitive: no

ipban_db_ip: 127.0.0.1

ipban_db_port: 3306

ipban_db_id: ragnarok

ipban_db_pw: ragnarok

ipban_db_db: ragnarok

ipban_codepage:

// MySQL Character 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 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 Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: log

log_codepage:

log_login_db: loginlog

 

Can anyone help me with this problem?

Edited October 16, 2015 by Narasya

[Narasya]

Ah, I'm such an idiot ;x; I found the solution.. There was an anon user in the MySQL database that blocked everything it seems. I don't know how it appeared there, but after I deleted it, it connected again.

Thank you for your help!

[Haziel]

The error image is missing, but, let me check, you created a MySQL user with login: ragnarok and password: ragnarok too?

[Narasya]

Are all images missing? I could re-upload them on another server

And yes, I made an user with the name 'ragnarok' and with the password 'ragnarok'

[Haziel]

Well, what you can verify is if the port 3306 is open, or if MySQL is configured to use this port.
I never used SQL Workbench, only WAMP, but, maybe, that's the problem.