Access denied for user Ragnarok@localhost

[Gouki]

I've setup quite a few servers now following different guides using older revs. Due to curiosity of the new features and what not. seems like the connections are hard coded already on the newer revs?



I have my inter_athena.conf setup correctly and it seems like something is overwriting my own database name to ragnarok, or previously I do use root as a username and now its like forced or being overwritten to use ragnarok.

Are the guides now outdated and must follow the guide on our wiki?
Install MySQL · rathena/rathena Wiki · GitHub

I found alot of suggestions saying this fix
 

  CREATE USER 'ragnarok'@'localhost' IDENTIFIED BY 'ragnarok';
  GRANT ALL PRIVILEGES ON ragnarok.* to 'ragnarok'@'%' IDENTIFIED BY 'ragnarok';

[Gouki]

Problem solved. inter_athena misconfiguration due to updates / sql incompatible with current mariadb. 

[Jayz]

44 minutes ago, RagnaTechDev said:

I've setup quite a few servers now following different guides using older revs. Due to curiosity of the new features and what not. seems like the connections are hard coded already on the newer revs?



I have my inter_athena.conf setup correctly and it seems like something is overwriting my own database name to ragnarok, or previously I do use root as a username and now its like forced or being overwritten to use ragnarok.

Are the guides now outdated and must follow the guide on our wiki?
Install MySQL · rathena/rathena Wiki · GitHub

I found alot of suggestions saying this fix
 

  CREATE USER 'ragnarok'@'localhost' IDENTIFIED BY 'ragnarok';
  GRANT ALL PRIVILEGES ON ragnarok.* to 'ragnarok'@'%' IDENTIFIED BY 'ragnarok';

You need to create password in your ragnarok user,

[Gouki]

7 hours ago, Jayz said:

You need to create password in your ragnarok user,

on your inter_athena do you use your local ip, or your vps' ip? and also, do you use root to login or ragnarok?

[Haruka-404]

On 4/24/2023 at 8:57 PM, Gouki said:

Problem solved. inter_athena misconfiguration due to updates / sql incompatible with current mariadb. 

I'm new to this, what does it mean exactly? I have this same issue  Does it mean all these guides are out of date and we can no longer do this with rAthena?

Despite my configurations, rAthena is not recognizing the database credentials specified in conf/import/inter_conf.txt

I have set up everything EXACTLY as it was explained in literally either every post or rAthena wiki. Nothing I do fixes this....
 

inter_conf.txt file:
---------
use_sql_db: yes
userid: ragnarok
passwd: ragnarokpass
hostname: 127.0.0.1
char_db: ragnarok
log_db: log
map_db: ragnarok


inter_athena.conf file:
---------
// 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

// Amount of status points a new character will start with
start_status_points: 48

// Do we allow to change guild emblem during woe_time?
emblem_woe_change: yes

// How many transparent pixel can be found in emblem before detected as invalid? (Note 2)
emblem_transparency_limit: 80

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

// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: ragnarok
ipban_db_pw: ragnarok
ipban_db_db: ragnarok
ipban_codepage:

// MySQL Character 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 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 Web Server
web_server_ip: 127.0.0.1
web_server_port: 3306
web_server_id: ragnarok
web_server_pw: ragnarok
web_server_db: ragnarok

// MySQL Log 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

// Login Database Tables
login_server_account_db: login
ipban_table: ipbanlist
global_acc_reg_num_table: global_acc_reg_num
global_acc_reg_str_table: global_acc_reg_str

// Char Database Tables
char_db: char
hotkey_db: hotkey
scdata_db: sc_data
cart_db: cart_inventory
inventory_db: inventory
charlog_db: charlog
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
mail_attachment_db: mail_attachments
auction_db: auction
quest_db: quest
homunculus_db: homunculus
skill_homunculus_db: skill_homunculus
skillcooldown_homunculus_db: skillcooldown_homunculus
mercenary_db: mercenary
mercenary_owner_db: mercenary_owner
skillcooldown_mercenary_db: skillcooldown_mercenary
elemental_db: elemental
skillcooldown_db: skillcooldown
bonus_script_db: bonus_script
acc_reg_num_table: acc_reg_num
acc_reg_str_table: acc_reg_str
char_reg_str_table: char_reg_str
char_reg_num_table: char_reg_num
clan_table: clan
clan_alliance_table: clan_alliance

// Map Database Tables
barter_table: barter
buyingstore_table: buyingstores
buyingstore_items_table: buyingstore_items
item_table: item_db
renewal-item_table: item_db_re
item2_table: item_db2
renewal-item2_table: item_db2_re
mob_table: mob_db
renewal-mob_table: mob_db_re
mob2_table: mob_db2
renewal-mob2_table: mob_db2_re
mob_skill_table: mob_skill_db
renewal-mob_skill_table: mob_skill_db_re
mob_skill2_table: mob_skill_db2
renewal-mob_skill2_table: mob_skill_db2_re
mapreg_table: mapreg
partybookings_table: party_bookings
sales_table: sales
vending_table: vendings
vending_items_table: vending_items
market_table: market
roulette_table: db_roulette
guild_storage_log: guild_storage_log

// Web Database Tables
// NOTE: The web server reads the login (login) and char (party,guild) tables and map (party_bookings), so it needs
//       the ability to connect to those databases.
guild_emblems: guild_emblems
user_configs: user_configs
char_configs: char_configs
merchant_configs: merchant_configs

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

inter_server_conf: inter_server.yml

import: conf/import/inter_conf.txt


My DB:
---------
MariaDB [ragnarok]> SHOW TABLES;
+--------------------------+
| Tables_in_ragnarok       |
+--------------------------+
| acc_reg_num              |
| acc_reg_str              |
| achievement              |
| atcommandlog             |
| auction                  |
| barter                   |
| bonus_script             |
| branchlog                |
| buyingstore_items        |
| buyingstores             |
| cart_inventory           |
| cashlog                  |
| char                     |
| char_configs             |
| char_reg_num             |
| char_reg_str             |
| charlog                  |
| chatlog                  |
| clan                     |
| clan_alliance            |
| db_roulette              |
| elemental                |
| feedinglog               |
| friends                  |
| global_acc_reg_num       |
| global_acc_reg_str       |
| guild                    |
| guild_alliance           |
| guild_castle             |
| guild_emblems            |
| guild_expulsion          |
| guild_member             |
| guild_position           |
| guild_skill              |
| guild_storage            |
| guild_storage_log        |
| homunculus               |
| hotkey                   |
| interlog                 |
| inventory                |
| ipbanlist                |
| login                    |
| loginlog                 |
| mail                     |
| mail_attachments         |
| mapreg                   |
| market                   |
| memo                     |
| mercenary                |
| mercenary_owner          |
| merchant_configs         |
| mob_db_re                |
| mvplog                   |
| npclog                   |
| party                    |
| party_bookings           |
| pet                      |
| picklog                  |
| quest                    |
| sales                    |
| sc_data                  |
| skill                    |
| skill_homunculus         |
| skillcooldown            |
| skillcooldown_homunculus |
| skillcooldown_mercenary  |
| storage                  |
| user_configs             |
| vending_items            |
| vendings                 |
| zenylog                  |
+--------------------------+

And still all these errors:
Info]: Connecting to the Login DB server.....
[SQL]: Access denied for user 'ragnarok'@'localhost' (using password: YES)
[Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok'

[Info]: Done reading conf/inter_athena.conf.
[SQL]: Access denied for user 'ragnarok'@'localhost' (using password: YES)
[Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok'

[Info]: Connect Character DB server.... (Character Server)
[SQL]: Access denied for user 'ragnarok'@'localhost' (using password: YES)
[Error]: Couldn't connect with username = 'ragnarok', host = '127.0.0.1', port = '3306', database = 'ragnarok'

Info]: Connecting to the Map DB Server....
[SQL]: Access denied for user 'ragnarok'@'localhost' (using password: YES)
[Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok'

Edited May 23 by Haruka-404