Jump to content
  • 0

Connection problems


rovinrambo

Question


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  20
  • Reputation:   0
  • Joined:  01/10/14
  • Last Seen:  

Hi guys, I was 100% sure that i made all the userid and passwd the same but i've been getting these errors. I couldn't find where it comes from. Need ya help! 

Thanks!

321.png

Link to comment
Share on other sites

12 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.00
  • Content Count:  171
  • Reputation:   15
  • Joined:  01/26/12
  • Last Seen:  

Check for typo or spaces as well as your ip if you are running a server locally sometimes using 127.0.0.1 may not work and might need to use your actual local ip on the machine.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  1137
  • Reputation:   290
  • Joined:  04/29/13
  • Last Seen:  

Error says cannot connect with server with given id password on port 3306

That means it is unable to Connect mysql server 

1.You either given wrong id password in confi

2. Or the given mysql user do not have privileges to connect the database 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  104
  • Reputation:   15
  • Joined:  01/18/16
  • Last Seen:  

make sure your mysql is active.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.01
  • Content Count:  120
  • Reputation:   53
  • Joined:  02/12/17
  • Last Seen:  

Hello, the username and password you've placed in your MySQL must be the id and password in your inter_athena.conf. Please try again.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  20
  • Reputation:   0
  • Joined:  01/10/14
  • Last Seen:  

7 hours ago, Felten said:

make sure your mysql is active.

Hi how would i know if the mysql is active or nah?

 

7 hours ago, Freya said:

Hello, the username and password you've placed in your MySQL must be the id and password in your inter_athena.conf. Please try again.

I did but still giving me save problems :(

 

That's what i have in my inter_athena.conf right :(

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  104
  • Reputation:   15
  • Joined:  01/18/16
  • Last Seen:  

Just now, rovinrambo said:

Hi how would i know if the mysql is active or nah?

What's your OS? Debian, Centos, Ubuntu...?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  20
  • Reputation:   0
  • Joined:  01/10/14
  • Last Seen:  

I'm running it with centOS

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.01
  • Content Count:  120
  • Reputation:   53
  • Joined:  02/12/17
  • Last Seen:  

Just now, rovinrambo said:

I did but still giving me save problems :(

Hello, okay, now check your userid and your passwd in two of the conf and make sure they are the same with your ragnarok login tables. Also, check if you MySQL username is not ragnarok instead it is root. 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  20
  • Reputation:   0
  • Joined:  01/10/14
  • Last Seen:  

2 minutes ago, Freya said:

Hello, okay, now check your userid and your passwd in two of the conf and make sure they are the same with your ragnarok login tables. Also, check if you MySQL username is not ragnarok instead it is root. 

isn't the userid is the one the i've created on the command line? cause i remembered i've created a username along the mysql installation

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.01
  • Content Count:  120
  • Reputation:   53
  • Joined:  02/12/17
  • Last Seen:  

4 minutes ago, rovinrambo said:

isn't the userid is the one the i've created on the command line? cause i remembered i've created a username along the mysql installation

Hello, okay, here. In your inter_athena that is where your MySQL username and password lies. You place them in there, however in char_athena and map_athena( or login_athena, I forgot) userid and passwd, that is your server's userid and passwd, your MySQL username and password is not the same with the userid and passwd of your server.
Place your MySQL username and password in your inter_athena.conf.
Place your userid and passwd in your ragnarok->login table if you do not remember something like this it should be
account_id = 1
userid = userid of char_athena and login_athena (again, I forgot)
passwd = passwd of char_athena and login_athena

Your username in your MySQL Installation that would be your inter_athena ID.

Edited by Freya
  • Upvote 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  20
  • Reputation:   0
  • Joined:  01/10/14
  • Last Seen:  

7 hours ago, Freya said:

Hello, okay, here. In your login_athena that is where your MySQL username and password lies. You place them in there, however in char_athena and map_athena( or login_athena, I forgot) userid and passwd, that is your server's userid and passwd, your MySQL username and password is not the same with the userid and passwd of your server.
Place your MySQL username and password in your inter_athena.conf.
Place your userid and passwd in your ragnarok->login table if you do not remember something like this it should be
account_id = 1
userid = userid of char_athena and login_athena (again, I forgot)
passwd = passwd of char_athena and login_athena

I did this and it gave me error. The one the i was editing is from conf/import . Should i also change the conf outside of this folder?

 

7 hours ago, rovinrambo said:

I did this and it gave me error. The one the i was editing is from conf/import . Should i also change the conf outside of this folder?

hey bro , nevermind. it is up and running . what u said was right, i just forgot to save my works :) . Thanks!

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  20
  • Reputation:   0
  • Joined:  05/30/17
  • Last Seen:  

Hello i got same problem, how to fix it?

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