Jump to content
  • 0

please Help Cannot Connect mysql


Question

5 answers to this question

Recommended Posts

  • 0
Posted

What you have to configure is the MySQL user, which is different from the user inside the login table. The userid and passwd fields inside map_athena.conf are for the login table. But all those db_id and db_pw inside the inter_athena.conf are for MySQL users.

A quick fix will be to run these two lines in phpMyAdmin under the SQL option. I based the values on your last screenshot.

CREATE USER 'ragnarok'@'localhost' IDENTIFIED BY 'ragnarok2';
GRANT SELECT,INSERT,UPDATE,DELETE ON ragnarok.* TO 'ragnarok'@'localhost';

And then make sure in inter_athena.conf all the db_id are ragnarok and all the db_pw are ragnarok2. 

Similarly, make sure the userid and passwd fields in the other conf files match what you have in the login table.

 

  • 0
Posted

You cant connect due to some misconfig on your char ip, map ip, login ip on char_athena .conf and map_athena.conf, it should synchronize with inter_athena.conf config

try changing your char ip, map ip and login ip to 127.0.0.1 (localhost) on your char_athena and map_athena

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