SQL, access denied for user 'ragnarok@localhost' help

[keoco]

i got the "

 access denied for user 'ragnarok@localhost' (using password: YES)" error? anyways its purple... how do i fix this?

[Lawliet]

Hello, I think it does not work without SQL password.

It is assumed that it seems only the server software has access.

sry for my bad english

LG.L

Edited January 24, 2012 by Lawliet

[keoco]

SQL password... i got one, but how do i fix it?

[Lawliet]

It indicatesthat yourSQL passwordis wrong oritdoes not have sufficientauthorization.

(Write, read permission)

LG.L

[bentheexo]

In the inter_athena.conf you edit all the instances of the password to match the password that choose. If you also setup a different user other than the "ragnarok" user that is already set in the inter_athena.conf file, then you should change that one as well.

[keoco]

thanks for the reply, i checked out inter_athena.conf, so which one do i change? x.x or do i change all of it?

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

[bentheexo]

This might be easier to explain with examples.

MySQL Username: ben

MySQL Password: ben123

MySQL Database: bendb

The username corresponds to the _id portions

The password corresponds to the _pw portions

The database corresponds to the _db portions

In short you need to change anything that is not what you setup to use in your MySQL.

[keoco]

haha thanks it works now... but now a new error popped up...

 db error - table "ragnarok.loginlog" doesnt exist

I checked and it did exist... why is SQL sooo annoying =="

[bentheexo]

You need to import the logs.sql into your mysql tables.

[keoco]

i already did that =/, and it still says it

[Amellia sizilia sembiring]

Import logs.sql to log database

[keoco]

I already imported logs.sql into the logs database, ive been following the wiki closely http://rathena.org/wiki/SQL_Installation#For_Windows

I took a screenshot of the error, hope it helps...

[Poseidon]

Edit your inter_athena.conf

find

log_db_db: ragnarok

change to

log_db_db: log

[ngek202]

try this change username/id to root.

sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: root
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: root
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: root
log_db_pw: ragnarok
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

im confused now so that error is it won't start with ragnarok@localhost access denied or some SQL isn't working?

[keoco]

Edit your inter_athena.conf

find

log_db_db: ragnarok

change to

log_db_db: log

hey! thanks, that seemed to work..

Edited January 24, 2012 by keoco

[black_knighthood]

Hi, plz if someone can help me, I have the same error acces denied for user ragnarok... Im using xampp on port 81 (http://localhost:81/phpmyadmin/) however mysql is using port 3306. I want to test it in local (127.0.0.1), I have an user ragnarok with same pass and all global privileges, and also all privileges for each database, ragnarok and log. My inter_athena.conf looks fine I guess:

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: log
log_codepage:

Thanks in advance.