biohazard0134 Posted November 2, 2012 Group: Members Topic Count: 14 Topics Per Day: 0.00 Content Count: 25 Reputation: 0 Joined: 10/06/12 Last Seen: November 6, 2012 Share Posted November 2, 2012 i already checked the inter_athena // Global SQL settings // overriden by local settings when the hostname is defined there // (currently only the login-server reads/obeys these settings) sql.db_hostname: 127.0.0.1 sql.db_port: 3306 sql.db_username: root sql.db_password: xxxx sql.db_database: rathena sql.codepage: // MySQL Character SQL server char_server_ip: 127.0.0.1 char_server_port: 3306 char_server_id: root char_server_pw: xxxx char_server_db: rathena // MySQL Map SQL Server map_server_ip: 127.0.0.1 map_server_port: 3306 map_server_id: root map_server_pw: xxxx map_server_db: rathena // MySQL Log SQL Database log_db_ip: 127.0.0.1 log_db_port: 3306 log_db_id: root log_db_pw: xxxx log_db_db: logs log_codepage: log_login_db: loginlog and still when i run the server.. it says access denied for user 'root'@'localhost' anyone plss help thx Quote Link to comment Share on other sites More sharing options...
David Posted November 2, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 195 Reputation: 23 Joined: 01/05/12 Last Seen: October 5, 2013 Share Posted November 2, 2012 Check your password if its exactly same with your MySQL password, is your mysql same machine with server? Quote Link to comment Share on other sites More sharing options...
Petey Pablo Posted November 2, 2012 Group: Members Topic Count: 152 Topics Per Day: 0.03 Content Count: 569 Reputation: 11 Joined: 11/24/11 Last Seen: March 7, 2022 Share Posted November 2, 2012 change your 127.0.0.1 to localhost. Quote Link to comment Share on other sites More sharing options...
biohazard0134 Posted November 2, 2012 Group: Members Topic Count: 14 Topics Per Day: 0.00 Content Count: 25 Reputation: 0 Joined: 10/06/12 Last Seen: November 6, 2012 Author Share Posted November 2, 2012 (edited) @suranol local host?? my lan ip?? @david what is mysql same machine with server?? my passwords are correct and thx for the reply bump bump me up plss ^^ Edited November 2, 2012 by biohazard0134 Quote Link to comment Share on other sites More sharing options...
Jazz Posted November 2, 2012 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 90 Reputation: 0 Joined: 09/29/12 Last Seen: July 10, 2020 Share Posted November 2, 2012 you have to grant privileges. Quote Link to comment Share on other sites More sharing options...
biohazard0134 Posted November 2, 2012 Group: Members Topic Count: 14 Topics Per Day: 0.00 Content Count: 25 Reputation: 0 Joined: 10/06/12 Last Seen: November 6, 2012 Author Share Posted November 2, 2012 @jazz grant privileges?? what is that?? Quote Link to comment Share on other sites More sharing options...
Jazz Posted November 2, 2012 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 90 Reputation: 0 Joined: 09/29/12 Last Seen: July 10, 2020 Share Posted November 2, 2012 read this http://rathena.org/board/topic/59529-setting-up-a-centos-vps-w-rathena-vnc/ this part specially //Now this is where it gets a tad confusing. Just replace your VPS IP and name from mine. Also come up with a different password...//Keep in mind this is the same information you will be placing in "inter_athena.conf" & "subnet_athena.conf". Quote Link to comment Share on other sites More sharing options...
Question
biohazard0134
i already checked the inter_athena
// Global SQL settings
// overriden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: root
sql.db_password: xxxx
sql.db_database: rathena
sql.codepage:
// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: root
char_server_pw: xxxx
char_server_db: rathena
// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: root
map_server_pw: xxxx
map_server_db: rathena
// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: xxxx
log_db_db: logs
log_codepage:
log_login_db: loginlog
and still
when i run the server.. it says access denied for user 'root'@'localhost'
anyone plss help thx
Link to comment
Share on other sites
6 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.