Jump to content
  • 0

Can't connect to MySQL Server on 127.0.0.1


zmref

Question


  • Group:  Members
  • Topic Count:  148
  • Topics Per Day:  0.03
  • Content Count:  299
  • Reputation:   6
  • Joined:  06/14/12
  • Last Seen:  

I'm a newbie, and I'm a pro RO player however I'm planning to create my own server.

I got this error when I first time use this rAthena

Please tell me what did I missed?

post-5357-0-02077900-1339642727_thumb.jpg

I haven't use My SQL yet, because it says that it's optional.

Link to comment
Share on other sites

22 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  113
  • Reputation:   5
  • Joined:  06/06/12
  • Last Seen:  

Download and install mysql database.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

Have the same problem :( tried downloading that database and failed.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

Have you port forwarded?

If your Xampp enabled for mysql?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

yeah both ceck :D

check*

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

yeah both ceck :D

check*

Follow this, if you have any questions ask me.

http://www.youtube.com/watch?v=f06EBENhV84

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

i did thats how i maid my server but still get this error.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

i did thats how i maid my server but still get this error.

Okay, so you've imported all your MySQL files?

From what I see here - http://puu.sh/BoZB you didn't set up your servers IP up correctly.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

mine just just like the login server.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

From what I found, your MYSQL isn't up to date, and an upgrade should fix it. Let's hope that's the issue.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

How to upgrade it?

Just download the new version or i can update it with the one i have installed?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

Just download the new one, but if you do that - I think you might have to re-run all the mysql database files.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

its because i had my server running fine but it got a big Errol i couldn't handle or fix so i just tried to make a new one and now i cant make a new user D:

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

Ohh, you made a new one.. Did you update your conf files to the new sql name and password?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

Yeah but i can't make a new user in the administrator mysql so i can drop the privillages

Here's the picture of the problem.

http://i1162.photobu...00/IMAG0119.jpg

post-4165-0-79375400-1339914675_thumb.jpg

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

Why is your char_server port 3306?..

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

char_port: 6121

Sorry i fixed the port problem it was something in inter_athena but it still says to debug and the sql access denied

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

Hi elcontrol00,

It seems to me that your MySQL server isn't running. Are you sure you installed XAMPP?

http://rathena.org/wiki/XAMPP_Installation

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

Yes i did install xampp

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

Is xampp turned on?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

yea it is it's running.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

yea it is it's running.

Hi elcontrol00,

My initial response was for the original poster cause his error was different from yours which is at the end of page 1...

But for your situation; it's clear that you do not have the correct user/pass combo for the MySQL server. I would recommend that you try to reset the credentials, or make sure you've entered them correctly inside '/conf/inter_athena.conf' and then try again.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  9
  • Reputation:   0
  • Joined:  06/20/12
  • Last Seen:  

on windows7? try uninstalling xampp restart you pc and run the server let's see what will happen... :)

Edited by darkPirates
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...