SQL connection impossible

[Captain09]

Hey guys,

For a few days I'm trying to setup a simple rathena server on my local computer.

I spent plenty of hours attempting to solve my sql connection issue but I have still no idea what's the matter.

I made sure that the usernames, passwords and databases are filled in correctly, what makes me crazy.

My server applications always look like that:

http://puu.sh/jJQpu/5cc9d2fb3c.png

As the whole relevant environment of my problem is really laborious to describe, I think it would be the best if someone could face the problem with me via a TeamViewer session. However you don't know my computer I can tell you where which application is installed, in doubts you may reinstall every necessary program.

 

I followed these guides:

https://rathena.org/wiki/Installation_on_Windows

https://rathena.org/wiki/SQL_Installation

 

It's only about setting up a simple rAthena SQl server.

If you could help me with that I would be very glad

 

Thanks a lot in advance

 

greets

Captain09

Edited August 21, 2015 by Captain09

[Sryx]

Check your ports. 

 

MySQL default port is 3600.

[Captain09]

Im really confused.

I tried your port and many other ports displayed in my MySQL Workbench but still the issue stays.

I'm clueless now

 

EDIT:

I tried it with a wampserver and am able to get to this:

http://puu.sh/jKcla/881076e16a.png

but after a short time all applications lose the connection:

http://puu.sh/jKcpE/198eb502f0.png

Edited August 22, 2015 by Captain09

[Emistry]

perhap you assigned a wrong  user to allow connection to your database ??

[Gocanaroj]

According to a google search, the default port for MySQL is 3306. Can you see what your config settings are for your sql server to see what port you have it set to?

[Captain09]

http://puu.sh/jMgGv/0a813ca37c.png

on the left of this picture you can see that the port 3306 is configured

 

 

http://puu.sh/jMgPZ/24d4ece357.png

this is how my inter_athena.conf looks

 

 

http://puu.sh/jMgSt/7f9233cd33.png

and here is how the errors of my servers in this configuration look like

[Gocanaroj]

Alright, stupid question incoming   .

 

I don't know exactly how MySQL Workbench works cuz I used AMPPS during my setup, but in your first image it shows only 1 connection on the left, with a user of "root". Again, I'm not sure how it works, so I don't know if this is just any active MySQL servers you are running, or a list of users.

 

My question is, did you already create a user named "ragnarok" with a password of "ragnarok" and give it all permissions for the database you want to access?

[Captain09]

Yes, I followed the guide 'install SQL' which instructed me to create a user.

I created a user "ragnarok" with the password "ragnarok" and gave it all permissions.

Edited August 27, 2015 by Captain09

[benching]

I'm not sure if you're aware of what you are doing or not.

1.please make sure you have MySQL server installed in your local computer.

2.Make sure you have the schema/database in your MySQL Server.

3.Ensure that the database name, host and credentials are correctly set.

 

port for mysql is 3306, no need to change this.