Jump to content
  • 0

"Access denied for user 'metin2'@'localhost' " 34k untouched


Invictus

Question

Hey, just implementing the 34k untouched files but for some reason i'm getting the below error and not entirely sure what to do about it.

PUBLIC_IP: 188.165.186.201 interface em0
mysql_real_connect: Access denied for user 'metin2'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: metin2 db: common
cannot start server while no common sql connected
HOSTNAME: Game99
Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0

Check the config files in the cores' folders. There are written the id and pw for the mysql user which is used by your metin2 server. If every detail is correct, you won't get this error.

Link to comment
Share on other sites

  • 0

https://metin2.download/picture/MGesv5GviD0xBszQ28Dfup66jtxEGO96/.png - Game99 Config

https://metin2.download/picture/OPkB80G91ypLiZ01UWyaP8e709kBcsck/.png - Channel 1 config

https://metin2.download/picture/HC5ezAxBz8FHND3ce4WckSEx5altMw4b/.png - DB Config
https://metin2.download/picture/2cAuKgT8iEJ22iT0YxXiIiy5F42POKF3/.png - Auth Config

 

They're all the same, other than Auth config pw i cross checked with my working server and that worked fine. I'm doing this on a VPS if that makes any difference? also the user i made called "metin2" as instructed by the 34k clean instructions to all of the passwords seen in the config, none worked all caused the same error

 

Edited by Metin2 Dev
Core X - External 2 Internal
  • Metin2 Dev 2
  • Love 2
  • Good 1
Link to comment
Share on other sites

  • 0

still getting the same error even after updating the password etc :/

You have no changed CONFIG files, first edit Mysql user & pass then add MAP_ALLOW: all game core.. Don't add to AUTH.

And

 

Here example : 

CHANNEL: 1
HOSTNAME: first
PORT: 3110
P2P_PORT: 14000
DB_ADDR: 127.0.0.1
DB_PORT: 15000
MAP_ALLOW: 1 3 4 5
PLAYER_SQL: 127.0.0.1 mt2 YoUrPassWorD player
COMMON_SQL: 127.0.0.1 mt2 YoUrPassWorD common
LOG_SQL: 127.0.0.1 mt2 YoUrPassWorD  log
TABLE_POSTFIX: 
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
VIEW_RANGE: 8000
CHECK_MULTIHACK: 0
ADMINPAGE_PASSWORD: NeeDHArDpAsSwOrDLiTTlEaNDbiqqErOrNuMbeR123
ADMINPAGE_IP: 127.0.0.1
SPEEDHACK_LIMIT_COUNT: 300
SPEEDHACK_LIMIT_BONUS: 80
PK_PROTECT_LEVEL: 15
MALL_URL: youritemshopurl.com
TRAFFIC_PROFILE: 
TEST_SERVER: 0
MAX_LEVEL: 105

 
note: you can find map number in map index file
index: /usr/home/trunk/share/locale/turkey/map
 
if you can't make it, contact me i can make it for you
Link to comment
Share on other sites

  • 0

1. go in putty and write

mysql -u root [enter]

2. go in winscp or fillezila in /usr/home/game/channel1 and open config

123.jpg

go back to putty and write

grant all on *.* to [email protected]"localhost" identified by " you'r passwrd";

exit;

/usr/local/etc/rc.d/mysql-server restart

 

sorry for my eng im romanian..

 

 

Edited by Metin2 Dev
Core X - External 2 Internal
  • Love 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Activity

    1. 5
    2. 5

      Zodiac Roulette (Aeldra event concept)

    3. 0

      I am looking for a team for PVP Server!

    4. 0

      How about get quest flag from binary??

    5. 5

      Zodiac Roulette (Aeldra event concept)

    6. 5

      Zodiac Roulette (Aeldra event concept)

    7. 5

      Zodiac Roulette (Aeldra event concept)

    8. 12

      REAL_TIME_FIRST_USE items not being expired in the safe-box

  • Recently Browsing

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

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.