Jump to content
  • 0
hervin

please Help Cannot Connect mysql

Question

5 answers to this question

Recommended Posts

  • 0

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.

 

Link to comment
Share on other sites

  • 0

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

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

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.