Jump to content
  • 0

please Help Cannot Connect mysql


hervin

Question


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   0
  • Joined:  11/07/16
  • Last Seen:  

somebody please help me

whats wrong whit me?

do not connect to phpmyadmin mysql

Untitled3.png

Untitled.png

Untitled4.png

Untitled5.png

Untitled6.png

Untitled7.png

Untitled2.png

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.00
  • Content Count:  520
  • Reputation:   64
  • Joined:  11/19/11
  • Last Seen:  

Grant privileges to user ragnarok on database ragnarok.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  68
  • Topics Per Day:  0.02
  • Content Count:  212
  • Reputation:   5
  • Joined:  01/24/12
  • Last Seen:  

do not use s1& s2 same : ragnarok change it then restart your server

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   0
  • Joined:  11/07/16
  • Last Seen:  

same T_T

Untitled8.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  5
  • Reputation:   2
  • Joined:  06/20/14
  • Last Seen:  

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

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  281
  • Reputation:   14
  • Joined:  10/14/13
  • Last Seen:  

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