Jump to content

  •  

Photo

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


This topic has been archived. This means that you cannot reply to this topic.
15 replies to this topic

#1 keoco

keoco

    Poporing

  • Members
  • PipPipPipPip
  • 129 posts

Posted 24 January 2012 - 07:01 AM

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

#2 Lawliet

Lawliet

    Poring

  • Members
  • Pip
  • 20 posts

Posted 24 January 2012 - 07:04 AM

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 by Lawliet, 24 January 2012 - 07:09 AM.


#3 keoco

keoco

    Poporing

  • Members
  • PipPipPipPip
  • 129 posts

Posted 24 January 2012 - 07:10 AM

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

#4 Lawliet

Lawliet

    Poring

  • Members
  • Pip
  • 20 posts

Posted 24 January 2012 - 07:18 AM

It indicatesthat yourSQL passwordis wrong oritdoes not have sufficientauthorization.
(Write, read permission)

LG.L

#5 bentheexo

bentheexo

    Poring

  • Members
  • Pip
  • 23 posts

Posted 24 January 2012 - 07:19 AM

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.

#6 keoco

keoco

    Poporing

  • Members
  • PipPipPipPip
  • 129 posts

Posted 24 January 2012 - 07:36 AM

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

#7 bentheexo

bentheexo

    Poring

  • Members
  • Pip
  • 23 posts

Posted 24 January 2012 - 07:57 AM

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.

#8 keoco

keoco

    Poporing

  • Members
  • PipPipPipPip
  • 129 posts

Posted 24 January 2012 - 08:15 AM

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

[SQL] db error - table "ragnarok.loginlog" doesnt exist

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

#9 bentheexo

bentheexo

    Poring

  • Members
  • Pip
  • 23 posts

Posted 24 January 2012 - 08:19 AM

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

#10 keoco

keoco

    Poporing

  • Members
  • PipPipPipPip
  • 129 posts

Posted 24 January 2012 - 08:29 AM

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

#11 Amellia sizilia sembiring

Amellia sizilia sembiring

    Santa Poring

  • Members
  • PipPipPip
  • 68 posts

Posted 24 January 2012 - 10:22 AM

Import logs.sql to log database

#12 keoco

keoco

    Poporing

  • Members
  • PipPipPipPip
  • 129 posts

Posted 24 January 2012 - 10:27 AM

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

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

Attached Files



#13 Poseidon

Poseidon

    Santa Poring

  • Members
  • PipPipPip
  • 86 posts

Posted 24 January 2012 - 10:31 AM

Edit your inter_athena.conf

find

log_db_db: ragnarok

change to

log_db_db: log

#14 ngek202

ngek202

    Angeling

  • Members
  • PipPipPipPipPipPipPip
  • 542 posts

Posted 24 January 2012 - 10:37 AM

try this change username/id to root.
[CODEbox]
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
[/CODEbox]

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

#15 keoco

keoco

    Poporing

  • Members
  • PipPipPipPip
  • 129 posts

Posted 24 January 2012 - 10:44 AM

Edit your inter_athena.conf

find

log_db_db: ragnarok

change to

log_db_db: log


hey! thanks, that seemed to work..

Edited by keoco, 24 January 2012 - 10:48 AM.


#16 black_knighthood

black_knighthood

    Poring

  • Members
  • Pip
  • 12 posts

Posted 16 February 2012 - 11:59 PM

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.