Jump to content
  • 0

Access Denied for user


NexusXVI

Question


  • Group:  Members
  • Topic Count:  61
  • Topics Per Day:  0.01
  • Content Count:  227
  • Reputation:   6
  • Joined:  01/18/12
  • Last Seen:  

Hi!, it's been a while and I just wanted to make a test server again for exploration of 3rd jobs.

Did download the latest pull on git, setup everything properly (schema on utf8)

Correct configuration on the conf files

1.PNG.1f9cac05fdef771073a9749d2bb6e859.PNG

3.PNG.7a2c03a5bd608dc964e4819df0c1901c.PNG

with the correct setup on workbench :


2.PNG.80dd5e8797865c20d1da6b252acaafae.PNG

 

Still havin an issue on the servers, did cleanly compile it as well.

4.PNG.5ec909cd37dc424156e0a12c32e338d8.PNG

 

Did try it on both the root and created a new user both having the same issue :

5.PNG.c6353431608c3dcd6023427dbb7c7592.PNG

 

So I am just wondering what went wrong regarding the error..

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  4
  • Reputation:   1
  • Joined:  04/30/22
  • Last Seen:  

Hello !

 

_id with your config should be ragnarok

_pw should be the password for ragnarok mysql user

 

rag1 and rag2 (if I'm right) are login and password to make connection between login, char and map, nothing to do with mysql ^^.

 

 

Have a good day :).

 

 

Tchaly

Edited by Tchaly
No double post
  • MVP 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  218
  • Reputation:   152
  • Joined:  11/28/11
  • Last Seen:  

add user and privileges:
user : rag1
pass : rag2

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  59
  • Topics Per Day:  0.01
  • Content Count:  396
  • Reputation:   53
  • Joined:  07/24/12
  • Last Seen:  

Since you remove // on 127.0.0.1 localhost,, you need to add your sqlport 3306 on your firewall,, or just remain // in your login_ip: char_ip: map_ip: etc..

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  49
  • Topics Per Day:  0.01
  • Content Count:  1533
  • Reputation:   235
  • Joined:  08/03/12
  • Last Seen:  

12 hours ago, NexusXVI said:

Hi!, it's been a while and I just wanted to make a test server again for exploration of 3rd jobs.

Did download the latest pull on git, setup everything properly (schema on utf8)

Correct configuration on the conf files

1.PNG.1f9cac05fdef771073a9749d2bb6e859.PNG

3.PNG.7a2c03a5bd608dc964e4819df0c1901c.PNG

with the correct setup on workbench :


2.PNG.80dd5e8797865c20d1da6b252acaafae.PNG

 

Still havin an issue on the servers, did cleanly compile it as well.

4.PNG.5ec909cd37dc424156e0a12c32e338d8.PNG

 

Did try it on both the root and created a new user both having the same issue :

5.PNG.c6353431608c3dcd6023427dbb7c7592.PNG

 

So I am just wondering what went wrong regarding the error..

your conf error is from database 'log'. but your screenshot doesnt have that.

check that log part.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  61
  • Topics Per Day:  0.01
  • Content Count:  227
  • Reputation:   6
  • Joined:  01/18/12
  • Last Seen:  

Tbh that debug part is just a return text on the cpp files, which tells the bat file what to show during such error.


6.PNG.4e92775c36482dc969b3ddc9b50278fe.PNG

9.PNG.b03a2ae460708a0ec9c9a5e79b9e8bb2.PNG

This is both true on the mapserv and charserv

7.PNG.3894022123bbc1e61d88679a7ad498cd.PNG


8.PNG.0e28adc1c4950b60b222d9d718d462cf.PNG

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  61
  • Topics Per Day:  0.01
  • Content Count:  227
  • Reputation:   6
  • Joined:  01/18/12
  • Last Seen:  

18 hours ago, Tchaly said:

Hello !

 

_id with your config should be ragnarok

_pw should be the password for ragnarok mysql user

 

rag1 and rag2 (if I'm right) are login and password to make connection between login, char and map, nothing to do with mysql ^^.

 

 

Have a good day :).

 

 

Tchaly

Kudos to you man, did not know I could miss that so easily..

anything that is inside inter_athena.conf should be the connection for communication on MYSQL and for char and map is for their own.
I'll attach the screenies here for other people to see.


sol1.PNG.1f63f552c7524e37e1bf6d8ff2e22cfd.PNG

 

sol2.PNG.6ad5507d595bc6ee1bc22b7658fd5f0d.PNG

 

Thanks everything is green and no errors now.. Considered this closed.

  • Love 1
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...