biohazard0134 Posted November 2, 2012 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
David Posted November 2, 2012 Posted November 2, 2012 Check your password if its exactly same with your MySQL password, is your mysql same machine with server? Quote
Petey Pablo Posted November 2, 2012 Posted November 2, 2012 change your 127.0.0.1 to localhost. Quote
biohazard0134 Posted November 2, 2012 Author 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
biohazard0134 Posted November 2, 2012 Author Posted November 2, 2012 @jazz grant privileges?? what is that?? Quote
Jazz Posted November 2, 2012 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
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
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.