Jump to content
  • 0

Can't connect to MySQL server on


Geralt

Question


  • Group:  Members
  • Topic Count:  61
  • Topics Per Day:  0.01
  • Content Count:  108
  • Reputation:   0
  • Joined:  12/26/12
  • Last Seen:  

Guys I have this problem in my hosting cloud server centos 7 I can't connect emulator or enter the DB

obs .. will it be necessary to format the machine and install everything again?

Quote

[Warning]: You are running rAthena with root privileges, it is not necessary.
[Info]: Connect Character DB server.... (Character Server)

: Can't connect to MySQL server on 'xxx.xx.xxx.xxx' (111)
[Error]: Couldn't connect with username = 'rathena4444', password = 'egf0dumya6il@', host = 'xxx.xx.xxx.xxx', port = '3306', database = 'rathena4444_rag'
[Debug]: at inter.cpp:942
[Info]: Server uses 'select' as event dispatcher
[Info]: Server supports up to '1024' concurrent connections.
[Info]: Char Server IP Address : 'xxx.xx.xxx.xxx' -> 'xxx.xx.xxx.xxx'.
[Info]: Map Server IP Address : 'xxx.xx.xxx.xxx' -> 'xxx.xx.xxx.xxx'.
[Status]: Using SQL dbs: no
[Info]: Logging item transactions to table 'picklog'.
[Info]: Logging commands to table 'atcommandlog'.
[Info]: Logging 'logmes' messages to table 'npclog'.
[Info]: Logging Cash transactions to table 'cashlog'.
[Info]: Logging Feeding items to table 'feedinglog'.
[Info]: Connecting to the Map DB Server....
[SQL]: Can't connect to MySQL server on 'xxx.xx.xxx.xxx' (111)
[Error]: Couldn't connect with uname='rathena4444',passwd='egf0dumya6il@',host='xxx.xx.xxx.xxx',port='3306',database='rathena4444_rag'
[Debug]: at map.cpp:4287
[Debug]: at map.cpp:4289

 

Edited by Geralt
Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  25
  • Topics Per Day:  0.01
  • Content Count:  924
  • Reputation:   166
  • Joined:  04/05/13
  • Last Seen:  

Did you correctly set id,pw for mysql and setup database for rAthena yet?

Try follow this guide maybe it's help if you miss some step: https://github.com/rathena/rathena/wiki/Install-on-Centos

Edited by Start_
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  61
  • Topics Per Day:  0.01
  • Content Count:  108
  • Reputation:   0
  • Joined:  12/26/12
  • Last Seen:  

something closed door 3306 I used a command to release

 

iptables -I INPUT -p tcp --dport 3306 -j ACCEPT 

 

 

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