Jump to content
  • 0

Cant connect to MySQL server using Asura


Question

10 answers to this question

Recommended Posts

Posted (edited)

map_athena.conf

 

userid: (my username in the database)

passwd: (my password in the database)
 
char_ip: (IP of my VPS)
 
map_ip: (IP of my VPS)
 
 
char_athena.conf
 

userid: (my username in the database)

passwd: (my password in the database)
 
char_ip: (IP of my VPS)
login_ip: (IP of my VPS)
 
 

inter_athena

 

sql.db_host name: 127.0.0.1 ( I've tried to put my host IP here but didnt work and is not stated in the tutorial i watched,

sql.db.port: 3306

sql.db_username: root

sql.db_password: (my root password)

sql.db_database: (database name)

 

same goes with my char_server_ip, map_server_ip, and log_db_ip

Edited by Z e r o
Posted

Does the databse exist?

Does the account "root" exist?

Did you configure the privileges for account "root"?

Did you change the the server communication account (s1/p1) and forgot an occurrence?

Does the server communication account (s1/p1) exist in your "login" table?

Is the database located on the same machine as the RO server? (Otherwise 127.0.0.1 wont work.)

 

What does the error message tell?

Posted

Yes the database exist.

 

account root?

 

I havent configure the privileges ( I dont know how to do that ) XD

 

Yes i changed the s1/p1

 

I don't know where the database is located right know all i know is i can only access it using phpmyadmin in the ip given by the host ( i tried to change the 127.0.0.1 to my host address but it dont accept the ip )

Posted

127.0.0.1 and localhost are the same thing, both are pointing to the local computer, so you answer is completely pointless. Maybe you should think about your hosting service if you don't know the basics of computer systems. (I know, I sound harsh but it's the truth.)

 

 

 

 


account root?

 

After setting up your MySQL server you have to create a user which is used by the RO server to communicate with the MySQL server.

 


I havent configure the privileges ( I dont know how to do that ) XD

 

The account you created must have the proper privileges for your RO database to be able to select, edit and delete data. Most common way for newbie is to use the option "create database with same name and grant all privileges" (or something similar) when creating the user for the MySQL server. If you do so, you wont have to set up the privileges on your own.

 

 


Yes i changed the s1/p1

 

make sure you changes it in the config files and also in the "login" table of your database.

 


I don't know where the database is located right know all i know is i can only access it using phpmyadmin in the ip given by the host ( i tried to change the 127.0.0.1 to my host address but it dont accept the ip )

account root?

 

If your phpMyAdmin is accessable through 127.0.0.1 it's on the local computer.
Posted

127.0.0.1 and localhost are the same thing, both are pointing to the local computer, so you answer is completely pointless. Maybe you should think about your hosting service if you don't know the basics of computer systems. (I know, I sound harsh but it's the truth.)

 

 

 

 

 

account root?

 

After setting up your MySQL server you have to create a user which is used by the RO server to communicate with the MySQL server.

 

>>>>>>>>>>> 

I havent configure the privileges ( I dont know how to do that ) XD

 

The account you created must have the proper privileges for your RO database to be able to select, edit and delete data. Most common way for newbie is to use the option "create database with same name and grant all privileges" (or something similar) when creating the user for the MySQL server. If you do so, you wont have to set up the privileges on your own.

 

 

Yes i changed the s1/p1

 

make sure you changes it in the config files and also in the "login" table of your database.

 

I don't know where the database is located right know all i know is i can only access it using phpmyadmin in the ip given by the host ( i tried to change the 127.0.0.1 to my host address but it dont accept the ip )

account root?

 

If your phpMyAdmin is accessable through 127.0.0.1 it's on the local computer.

 

Hi Kenpachi,

 

Really? I believe I know what I am talking about. Please Z e r o, confirm my answer has worked for you; because it's been known to resolve issues in regards to this in the past.

 

Your hostile attitude is irritable to people whom are here to help others, I would prefer you retract that statement. There is a difference the way 127.0.0.1 and localhost is handled, because of how it involves the IPv4 and IPv6 addresses. Also... I think for someone with an issue whom is hosted with AsuraHosting, the guys at AsuraHosting would be the best people to ask for resolution to the issue...

Posted (edited)

Hi Z e r o,

 

It's simple; just edit your '/conf/inter_athena.conf' and change the "127.0.0.1" values to "localhost". Save and run; it should work just fine. ;)

 

Thanks Asura it worked, finally!  :)

127.0.0.1 and localhost are the same thing, both are pointing to the local computer, so you answer is completely pointless. Maybe you should think about your hosting service if you don't know the basics of computer systems. (I know, I sound harsh but it's the truth.)

 

 

 

 

 

account root?

 

After setting up your MySQL server you have to create a user which is used by the RO server to communicate with the MySQL server.

 

I havent configure the privileges ( I dont know how to do that ) XD

 

The account you created must have the proper privileges for your RO database to be able to select, edit and delete data. Most common way for newbie is to use the option "create database with same name and grant all privileges" (or something similar) when creating the user for the MySQL server. If you do so, you wont have to set up the privileges on your own.

 

 

Yes i changed the s1/p1

 

make sure you changes it in the config files and also in the "login" table of your database.

 

I don't know where the database is located right know all i know is i can only access it using phpmyadmin in the ip given by the host ( i tried to change the 127.0.0.1 to my host address but it dont accept the ip )

account root?

 

If your phpMyAdmin is accessable through 127.0.0.1 it's on the local computer.

 

 

127.0.0.1 and localhost are the same thing, both are pointing to the local computer, so you answer is completely pointless. Maybe you should think about your hosting service if you don't know the basics of computer systems. (I know, I sound harsh but it's the truth.)

 

 

 

 

 

account root?

 

After setting up your MySQL server you have to create a user which is used by the RO server to communicate with the MySQL server.

 

I havent configure the privileges ( I dont know how to do that ) XD

 

The account you created must have the proper privileges for your RO database to be able to select, edit and delete data. Most common way for newbie is to use the option "create database with same name and grant all privileges" (or something similar) when creating the user for the MySQL server. If you do so, you wont have to set up the privileges on your own.

 

 

Yes i changed the s1/p1

 

make sure you changes it in the config files and also in the "login" table of your database.

 

I don't know where the database is located right know all i know is i can only access it using phpmyadmin in the ip given by the host ( i tried to change the 127.0.0.1 to my host address but it dont accept the ip )

account root?

 

If your phpMyAdmin is accessable through 127.0.0.1 it's on the local computer.

 

 

Thanks for the help kenpachi! :) 

Edited by Z e r o
Posted

 

Hi Z e r o,

 

It's simple; just edit your '/conf/inter_athena.conf' and change the "127.0.0.1" values to "localhost". Save and run; it should work just fine. ;)

 

Thanks Asura it worked, finally!  :)

 

Hi Z e r o,

 

Yeah, not a problem. 

 

@Kenpachi - "you answer is completely pointless. Maybe you should think about your hosting service if you don't know the basics of computer systems. (I know, I sound harsh but it's the truth.)" Completely pointless? Doubt it. Truth about what again? LOL.  /hmm

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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...