Jump to content
  • 0

access denied for user 'ragnarok'@'localhost' using password: yes


AlandSamuel

Question


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  5
  • Reputation:   0
  • Joined:  09/07/14
  • Last Seen:  

i have set my server, from sql, i have allowed all of server application, but when i start my server, it's always like that

 

here is some pictures from my computer.

 

*sorry if i spelled wrong, i'm little bad in english*

 

yPWBEfS.png

 

thanks before all :)

Link to comment
Share on other sites

9 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  48
  • Reputation:   3
  • Joined:  03/30/12
  • Last Seen:  

Hello, do you have create user ragnarok with mdp ragnarok for your localhost in your sql ?

Edited by Idolo
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  5
  • Reputation:   0
  • Joined:  09/07/14
  • Last Seen:  

Hello, do you have create user ragnarok with mdp ragnarok for your localhost in your sql ?

yes i have create user ragnarok, 

 

here my screeny

 

lbMWuul.png

 

*for info, i didn't use mysql for SQL programs, i use Xampp*

Edited by AlandSamuel
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  48
  • Reputation:   3
  • Joined:  03/30/12
  • Last Seen:  

User ragnarok have password ragnarok ?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  5
  • Reputation:   0
  • Joined:  09/07/14
  • Last Seen:  

User ragnarok have password ragnarok ?

yup, but nothing changed :(

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  48
  • Reputation:   3
  • Joined:  03/30/12
  • Last Seen:  

Can you show your inter_athena.conf please ?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  5
  • Reputation:   0
  • Joined:  09/07/14
  • Last Seen:  


// Athena InterServer configuration.

// Contains settings shared/used by more than 1 server.

// Options for both versions

// Log Inter Connections, etc.?

log_inter: 1

// Inter Log Filename

inter_log_filename: log/inter.log

// Level range for sharing within a party

party_share_level: 15

// SQL version options only

// You can specify the codepage to use in your mySQL tables here.

// (Note that this feature requires MySQL 4.1+)

//default_codepage:

// For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1

// Under windows, you want to use 127.0.0.1. If you see a message like

// "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

// and you have localhost, switch it to 127.0.0.1

// Global SQL settings

// overridden by local settings when the hostname is defined there

// (currently only the login-server reads/obeys these settings)

sql.db_hostname: 127.0.0.1

sql.db_port: 3306

sql.db_username: ragnarok

sql.db_password: ragnarok

sql.db_database: ragnarok

sql.codepage:

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: ragnarok

char_server_pw: ragnarok

char_server_db: ragnarok

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: ragnarok

map_server_pw: ragnarok

map_server_db: ragnarok

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog

// MySQL Reconnect Settings

// - mysql_reconnect_type:

// 1: When MySQL disconnects during runtime, the server tries to reconnect

// mysql_reconnect_count times and shuts down if unsuccessful.

// 2: When mysql disconnects during runtime, it tries to reconnect indefinitely.

mysql_reconnect_type: 2

mysql_reconnect_count: 1

// DO NOT CHANGE ANYTHING BEYOND THIS LINE UNLESS YOU KNOW YOUR DATABASE DAMN WELL

// this is meant for people who KNOW their stuff, and for some reason want to change their

// database layout. [CLOWNISIUS]

// ALL MySQL Database Table names

// Char Database Tables

char_db: char

hotkey_db: hotkey

scdata_db: sc_data

cart_db: cart_inventory

inventory_db: inventory

charlog_db: charlog

storage_db: storage

reg_db: global_reg_value

skill_db: skill

interlog_db: interlog

memo_db: memo

guild_db: guild

guild_alliance_db: guild_alliance

guild_castle_db: guild_castle

guild_expulsion_db: guild_expulsion

guild_member_db: guild_member

guild_skill_db: guild_skill

guild_position_db: guild_position

guild_storage_db: guild_storage

party_db: party

pet_db: pet

friend_db: friends

mail_db: mail

auction_db: auction

quest_db: quest

homunculus_db: homunculus

skill_homunculus_db: skill_homunculus

mercenary_db: mercenary

mercenary_owner_db: mercenary_owner

elemental_db: elemental

ragsrvinfo_db: ragsrvinfo

skillcooldown_db: skillcooldown

bonus_script_db: bonus_script

// Map Database Tables

buyingstore_db: buyingstores

buyingstore_items_db: buyingstore_items

item_db_db: item_db

item_db_re_db: item_db_re

item_db2_db: item_db2

//item_db2_db: item_db2_re

item_cash_db_db: item_cash_db

item_cash_db2_db: item_cash_db2

mob_db_db: mob_db

mob_db_re_db: mob_db_re

mob_db2_db: mob_db2

//mob_db2_db: mob_db2_re

mob_skill_db_db: mob_skill_db

mob_skill_db_re_db: mob_skill_db_re

mob_skill_db2_db: mob_skill_db2

//mob_skill_db2_db: mob_skill_db2_re

mapreg_db: mapreg

vending_db: vendings

vending_items_db: vending_items

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)

use_sql_db: no

import: conf/import/inter_conf.txt

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  48
  • Reputation:   3
  • Joined:  03/30/12
  • Last Seen:  

I don't see an error... can you show your databases ragnarok ?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  5
  • Reputation:   0
  • Joined:  09/07/14
  • Last Seen:  

pic 1 :

 

wYOX4tD.png

 

pic 2 :

 

XK0RiUs.png

 

pic 3 :

 

GoY3Z9L.png

 

screeny 4 :

 

3GxXhB8.png

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  48
  • Reputation:   3
  • Joined:  03/30/12
  • Last Seen:  

I'm really sorry I don't know... tried to set all privileges for your ragnarok user...

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