[SQL]: Access denied for user 'ragnarok'@'localhost' (using password: NO) [Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok'

[Haruka-404]

Hello Everyone,

I hope someone can help me?

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 every post or rAthena wiki.
Nothing I do will change the response of my attempt to start athena.
I am attempting to run Ragnarok from a GCE Linux based server, not locally.

Please help. 

Please find below a copy of my exact setup/files, please advise if you require any other details that will help benefit troubleshooting this issue.

Many thanks!

- Haruka

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: NO)
[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: NO)
[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: NO)
[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: NO)
[Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok'

Edited May 23 by Haruka-404
Code block for read friendly post

[shatowolf]

Hi mate!

 

Use txtbox next time you post that long xD! 

the error is there. : 

Couldn't connect with uname='ragnarok'

double check your sql details, and also try google how to set this to YES. via mysql server. (using password: NO)

lastly check the port.

anything you need check, ---> double check it.