Jump to content
  • 0

Access denied for user 'ragnarok'@'localhost'


Narasya

Question


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  4
  • Reputation:   0
  • Joined:  08/18/14
  • Last Seen:  

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:

 

1.png

 

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:

2.png

 

the login name and password is ragnarok

3.png

4.png

5.png

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 by Narasya
Link to comment
Share on other sites

4 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  4
  • Reputation:   0
  • Joined:  08/18/14
  • Last Seen:  

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! :)

Link to comment
Share on other sites


  • Group:  Content Moderator
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  639
  • Reputation:   596
  • Joined:  11/25/11
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  4
  • Reputation:   0
  • Joined:  08/18/14
  • Last Seen:  

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'

Link to comment
Share on other sites


  • Group:  Content Moderator
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  639
  • Reputation:   596
  • Joined:  11/25/11
  • Last Seen:  

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...