• Announcements

    • Emistry

      Rules and Regulations - General/Script/Database/Source Support   11/17/16

      In all sub-forums of this section , you are still bound to follow the rAthena Board Rules. Topic Author: Do not release scripts that are not of your own creation unless you can provide evidence of explicit permission from the original author to do so. Attempt to post your script in the proper section. If you're not certain as to where to post it, feel free to ask one of the Moderators. Do provide an informative title.  Do provide at the very least a 3-4 sentences description or summary that clearly states what your script does.  Attempt to have multiple hosts for your scripts as to prevent dead links. 3 or more links are ideal. Links to your issue should directly provide the relevant items without the need for registration.  Make use of BBCode for respective contents.  Mark the reply as "Best Answer" in case it solved your issue. You may as well consider give them a reputation for the help. Vote Up relevant replies, and Vote Down for irrelevant replies. You're not allowed to bump your topics if you're not providing any new updates prior to your previous post.   Member: You're not allowed to bump your topics if you're not providing any new updates prior to your previous post. Do not post anything irrelevant contents in the topic. Vote Up relevant replies, and Vote Down for irrelevant replies. You may only post into this area if you are willing to either write new or make changes to scripting code yourself.  Do not criticize others reply being too general or without concrete scripting code.    Everyone: Violate these rules may result in immediate deletion of the topic/post, warning increase, and restriction of posting abilities for a certain period of time. On future offenses, member is to receive an increase in the warn level and have their posting abilities restricted for a certain period of time to be determined by the Moderators handling the case.
      * rAthena Staff reserves the right to add to and change the rules at any time. It is your duty to keep up with any changes and follow them to the best of your ability.   Your cooperation in this regard will be highly appreciated. Thank you.
  • 0
Sign in to follow this  
Followers 0
keoco

SQL, access denied for user '[email protected]' help

Question

i got the "

 access denied for user [email protected]' (using password: YES)" error? anyways its purple... how do i fix this?
0

Share this post


Link to post
Share on other sites

15 answers to this question

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
0

Share this post


Link to post
Share on other sites

It indicatesthat yourSQL passwordis wrong oritdoes not have sufficientauthorization.

(Write, read permission)

LG.L

0

Share this post


Link to post
Share on other sites

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.

1

Share this post


Link to post
Share on other sites

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

0

Share this post


Link to post
Share on other sites

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.

1

Share this post


Link to post
Share on other sites

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 =="

0

Share this post


Link to post
Share on other sites

Edit your inter_athena.conf

find

log_db_db: ragnarok

change to

log_db_db: log

1

Share this post


Link to post
Share on other sites

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 [email protected] access denied or some SQL isn't working?

0

Share this post


Link to post
Share on other sites

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
0

Share this post


Link to post
Share on other sites

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.

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0