help, Access denied for user 'ragnarok@localhost'

[black_knighthood]

Hi, plz if someone can help me, I have the same error of

<a href="http://rathena.org/board/topic/57888-sql-access-denied-for-user-ragnaroklocalhost-help/>this topic</a>

access denied for user 'ragnarok@localhost', but nobody seems to answer there, it says solved. 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.

Edited February 18, 2012 by black_knighthood

[Blazing Spear]

try to look at the map_eathena.conf and char_eathena.conf you need to edit that too

[black_knighthood]

Its ok?

char_eathena.conf

// Server Communication username and password.
userid: s11111
passwd: p11111
// Server name, use alternative character such as ASCII 160 for spaces.
// NOTE: Do not use spaces in the name, or guild emblems won't work client-side!
server_name: Server
// Wisp name for server: used to send wisp from server to players (between 4 to 23 characters)
wisp_server_name: Server
// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: 127.0.0.1
// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1
// Login Server Port
login_port: 6900
// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
char_ip: 127.0.0.1
// Character Server Port
char_port: 6121

map_eathena.conf

// Interserver communication passwords, set in account.txt (or equiv.)
userid: s11111
passwd: p11111
// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: 127.0.0.1
// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1
// Character Server Port
char_port: 6121
// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
map_ip: 127.0.0.1
// Map Server Port
map_port: 5121

Hi again, still the same error, someone can help me? plz

[Asura]

Hi black_knighthood,

Log into your phpMyAdmin, select the Privileges tab on the front page.

Then look at your users, do you have one labeled...

'ragnarok' under the User column and 'localhost' under the Host column?

[black_knighthood]

Hi black_knighthood,

Log into your phpMyAdmin, select the Privileges tab on the front page.

Then look at your users, do you have one labeled...

'ragnarok' under the User column and 'localhost' under the Host column?

yes, and if has all global privileges and also privileges for each database

[Asura]

Hi black_knighthood,

Try adding 'ragnarok' @ '127.0.0.1'.

[LCDTheOG]

what is the password and username of the account with the id of 1 in your login table?

[black_knighthood]

Hi black_knighthood,

Try adding 'ragnarok' @ '127.0.0.1'.

I tryed that, and didnt work.

what is the password and username of the account with the id of 1 in your login table?

Same as above:

user=s11111

pass=p11111

It can be a problem of my pc? Maybe some permissions of windows 7

[Asura]

Hi black_knighthood,

Can you check if your MySQL server has binded itself to a specific IP during the setup? When the MySQL server is binded to an IP; it will only listen to that specific IP. Try removing the bind host setting and then restarting your MySQL server.

Source: http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html

[black_knighthood]

I dont think so, I used mysql normally with root user, making php pages, and always connected has "localhost". Anyway thanks for the help. I had xampp and mysql working fine.

[simplemhan]

try to use this

username: root

password: ragnarok

i think thats the solution.

[Asura]

Hi black_knighthood,

Are you using a pre-compiled version of rAthena? Or did you compile this yourself? If you did get a pre-compiled, where did you get it from?

[black_knighthood]

try to use this

username: root

password: ragnarok

i think thats the solution.

I try, but now it says acces denied for user root@localhost (I put the correct pasword for root, isnt ragnarok)

Hi black_knighthood,

Are you using a pre-compiled version of rAthena? Or did you compile this yourself? If you did get a pre-compiled, where did you get it from?

I compiled it by myself using visual 2008, and recompiled after change the mmo.h

[simplemhan]

i think you did not use the sql files in your svn thats why there is no account called ragnarok.

[Asura]

Hi black_knighthood,

I'm out of ideas, at a desperate attempt... I would suggest trying:

inter_athena.conf

sql.db_hostname: localhost
char_server_ip: localhost
map_server_ip: localhost
log_db_ip: localhost

If that doesn't work, I don't know what else you can do.

[black_knighthood]

That didnt work, but someting strange happened when I recompiled it again today. I recompiled again and first time when I run runserver-sql it started ok login and map server, but char had a problem, then I closed and run again, but again acces denied for ragnarok@localhost, thats very strange I guess. Was like a little light in a dark hole :S

[Asura]

Hi black_knighthood,

Do you have some sort of firewall? Try turning that off for a second and see if it works with it off. If not; then I'm out of ideas for you.

[LCDTheOG]

try to use

username: root

password: (the password you installed the sql server with)

Edited March 11, 2012 by lilcooldude69

[black_knighthood]

It didnt work when I turn off windows firewall (the only one I have), and I have already tried to connect with root instead of ragnarok but didnt work anyway.

Thx guys, if someone have another idea I would be glad. I will try to run the server in another pc to see if it is the problem.

[Neo-Mind]

I had a similar issue with my server setup . you need to ensure that whichever user name you provide in the conf files is also registered in your mysql instance as a valid user with proper privileges. You can right click the instance and see the options (I'm at office right now. will update with more details when I get home)