Access denied for user Ragnarok@localhost

[Gouki]

I've setup quite a few servers now following different guides using older revs. Due to curiosity of the new features and what not. seems like the connections are hard coded already on the newer revs?



I have my inter_athena.conf setup correctly and it seems like something is overwriting my own database name to ragnarok, or previously I do use root as a username and now its like forced or being overwritten to use ragnarok.

Are the guides now outdated and must follow the guide on our wiki?
Install MySQL · rathena/rathena Wiki · GitHub

I found alot of suggestions saying this fix
 

  CREATE USER 'ragnarok'@'localhost' IDENTIFIED BY 'ragnarok';
  GRANT ALL PRIVILEGES ON ragnarok.* to 'ragnarok'@'%' IDENTIFIED BY 'ragnarok';

[Gouki]

Problem solved. inter_athena misconfiguration due to updates / sql incompatible with current mariadb. 

[Jayz]

44 minutes ago, RagnaTechDev said:

I've setup quite a few servers now following different guides using older revs. Due to curiosity of the new features and what not. seems like the connections are hard coded already on the newer revs?



I have my inter_athena.conf setup correctly and it seems like something is overwriting my own database name to ragnarok, or previously I do use root as a username and now its like forced or being overwritten to use ragnarok.

Are the guides now outdated and must follow the guide on our wiki?
Install MySQL · rathena/rathena Wiki · GitHub

I found alot of suggestions saying this fix
 

  CREATE USER 'ragnarok'@'localhost' IDENTIFIED BY 'ragnarok';
  GRANT ALL PRIVILEGES ON ragnarok.* to 'ragnarok'@'%' IDENTIFIED BY 'ragnarok';

You need to create password in your ragnarok user,

[Gouki]

7 hours ago, Jayz said:

You need to create password in your ragnarok user,

on your inter_athena do you use your local ip, or your vps' ip? and also, do you use root to login or ragnarok?