keoco Posted January 24, 2012 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 2012 Share Posted January 24, 2012 i got the " access denied for user 'ragnarok@localhost' (using password: YES)" error? anyways its purple... how do i fix this? Quote Link to comment Share on other sites More sharing options...
Lawliet Posted January 24, 2012 Group: Members Topic Count: 6 Topics Per Day: 0.00 Content Count: 21 Reputation: 2 Joined: 01/04/12 Last Seen: March 8, 2014 Share Posted January 24, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
keoco Posted January 24, 2012 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 2012 Author Share Posted January 24, 2012 SQL password... i got one, but how do i fix it? Quote Link to comment Share on other sites More sharing options...
Lawliet Posted January 24, 2012 Group: Members Topic Count: 6 Topics Per Day: 0.00 Content Count: 21 Reputation: 2 Joined: 01/04/12 Last Seen: March 8, 2014 Share Posted January 24, 2012 It indicatesthat yourSQL passwordis wrong oritdoes not have sufficientauthorization. (Write, read permission) LG.L Quote Link to comment Share on other sites More sharing options...
bentheexo Posted January 24, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 24 Reputation: 19 Joined: 01/14/12 Last Seen: June 21, 2018 Share Posted January 24, 2012 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 Quote Link to comment Share on other sites More sharing options...
keoco Posted January 24, 2012 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 2012 Author Share Posted January 24, 2012 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 Quote Link to comment Share on other sites More sharing options...
bentheexo Posted January 24, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 24 Reputation: 19 Joined: 01/14/12 Last Seen: June 21, 2018 Share Posted January 24, 2012 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 Quote Link to comment Share on other sites More sharing options...
keoco Posted January 24, 2012 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 2012 Author Share Posted January 24, 2012 haha thanks it works now... but now a new error popped up... db error - table "ragnarok.loginlog" doesnt existI checked and it did exist... why is SQL sooo annoying ==" Quote Link to comment Share on other sites More sharing options...
bentheexo Posted January 24, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 24 Reputation: 19 Joined: 01/14/12 Last Seen: June 21, 2018 Share Posted January 24, 2012 You need to import the logs.sql into your mysql tables. 1 Quote Link to comment Share on other sites More sharing options...
keoco Posted January 24, 2012 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 2012 Author Share Posted January 24, 2012 i already did that =/, and it still says it Quote Link to comment Share on other sites More sharing options...
Amellia sizilia sembiring Posted January 24, 2012 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 108 Reputation: 4 Joined: 01/04/12 Last Seen: August 30, 2016 Share Posted January 24, 2012 Import logs.sql to log database Quote Link to comment Share on other sites More sharing options...
keoco Posted January 24, 2012 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 2012 Author Share Posted January 24, 2012 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... Quote Link to comment Share on other sites More sharing options...
Poseidon Posted January 24, 2012 Group: Members Topic Count: 25 Topics Per Day: 0.01 Content Count: 107 Reputation: 6 Joined: 12/09/11 Last Seen: May 9, 2017 Share Posted January 24, 2012 Edit your inter_athena.conf find log_db_db: ragnarok change to log_db_db: log 1 Quote Link to comment Share on other sites More sharing options...
ngek202 Posted January 24, 2012 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 530 Reputation: 33 Joined: 01/17/12 Last Seen: August 16, 2017 Share Posted January 24, 2012 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? Quote Link to comment Share on other sites More sharing options...
keoco Posted January 24, 2012 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 2012 Author Share Posted January 24, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
black_knighthood Posted February 17, 2012 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 12 Reputation: 0 Joined: 02/17/12 Last Seen: January 14, 2013 Share Posted February 17, 2012 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. Quote Link to comment Share on other sites More sharing options...
Question
keoco
i got the "
Link to comment
Share on other sites
15 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.