rovinrambo Posted May 1, 2017 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 20 Reputation: 0 Joined: 01/10/14 Last Seen: May 19, 2017 Share Posted May 1, 2017 Hi guys, I was 100% sure that i made all the userid and passwd the same but i've been getting these errors. I couldn't find where it comes from. Need ya help! Thanks! Quote Link to comment Share on other sites More sharing options...
0 sikiro Posted May 1, 2017 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 171 Reputation: 16 Joined: 01/26/12 Last Seen: January 1, 2024 Share Posted May 1, 2017 Check for typo or spaces as well as your ip if you are running a server locally sometimes using 127.0.0.1 may not work and might need to use your actual local ip on the machine. Quote Link to comment Share on other sites More sharing options...
0 Cyro Posted May 1, 2017 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 1138 Reputation: 290 Joined: 04/29/13 Last Seen: July 20, 2024 Share Posted May 1, 2017 Error says cannot connect with server with given id password on port 3306 That means it is unable to Connect mysql server 1.You either given wrong id password in confi 2. Or the given mysql user do not have privileges to connect the database Quote Link to comment Share on other sites More sharing options...
0 Felten Posted May 1, 2017 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 104 Reputation: 15 Joined: 01/18/16 Last Seen: July 15, 2024 Share Posted May 1, 2017 make sure your mysql is active. Quote Link to comment Share on other sites More sharing options...
0 Freya Posted May 1, 2017 Group: Members Topic Count: 16 Topics Per Day: 0.01 Content Count: 120 Reputation: 54 Joined: 02/12/17 Last Seen: June 2, 2023 Share Posted May 1, 2017 Hello, the username and password you've placed in your MySQL must be the id and password in your inter_athena.conf. Please try again. Quote Link to comment Share on other sites More sharing options...
0 rovinrambo Posted May 1, 2017 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 20 Reputation: 0 Joined: 01/10/14 Last Seen: May 19, 2017 Author Share Posted May 1, 2017 7 hours ago, Felten said: make sure your mysql is active. Hi how would i know if the mysql is active or nah? 7 hours ago, Freya said: Hello, the username and password you've placed in your MySQL must be the id and password in your inter_athena.conf. Please try again. I did but still giving me save problems That's what i have in my inter_athena.conf right Quote Link to comment Share on other sites More sharing options...
0 Felten Posted May 1, 2017 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 104 Reputation: 15 Joined: 01/18/16 Last Seen: July 15, 2024 Share Posted May 1, 2017 Just now, rovinrambo said: Hi how would i know if the mysql is active or nah? What's your OS? Debian, Centos, Ubuntu...? Quote Link to comment Share on other sites More sharing options...
0 rovinrambo Posted May 1, 2017 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 20 Reputation: 0 Joined: 01/10/14 Last Seen: May 19, 2017 Author Share Posted May 1, 2017 I'm running it with centOS Quote Link to comment Share on other sites More sharing options...
0 Freya Posted May 1, 2017 Group: Members Topic Count: 16 Topics Per Day: 0.01 Content Count: 120 Reputation: 54 Joined: 02/12/17 Last Seen: June 2, 2023 Share Posted May 1, 2017 Just now, rovinrambo said: I did but still giving me save problems Hello, okay, now check your userid and your passwd in two of the conf and make sure they are the same with your ragnarok login tables. Also, check if you MySQL username is not ragnarok instead it is root. Quote Link to comment Share on other sites More sharing options...
0 rovinrambo Posted May 1, 2017 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 20 Reputation: 0 Joined: 01/10/14 Last Seen: May 19, 2017 Author Share Posted May 1, 2017 2 minutes ago, Freya said: Hello, okay, now check your userid and your passwd in two of the conf and make sure they are the same with your ragnarok login tables. Also, check if you MySQL username is not ragnarok instead it is root. isn't the userid is the one the i've created on the command line? cause i remembered i've created a username along the mysql installation Quote Link to comment Share on other sites More sharing options...
0 Freya Posted May 1, 2017 Group: Members Topic Count: 16 Topics Per Day: 0.01 Content Count: 120 Reputation: 54 Joined: 02/12/17 Last Seen: June 2, 2023 Share Posted May 1, 2017 (edited) 4 minutes ago, rovinrambo said: isn't the userid is the one the i've created on the command line? cause i remembered i've created a username along the mysql installation Hello, okay, here. In your inter_athena that is where your MySQL username and password lies. You place them in there, however in char_athena and map_athena( or login_athena, I forgot) userid and passwd, that is your server's userid and passwd, your MySQL username and password is not the same with the userid and passwd of your server. Place your MySQL username and password in your inter_athena.conf. Place your userid and passwd in your ragnarok->login table if you do not remember something like this it should be account_id = 1 userid = userid of char_athena and login_athena (again, I forgot) passwd = passwd of char_athena and login_athena Your username in your MySQL Installation that would be your inter_athena ID. Edited May 1, 2017 by Freya 1 Quote Link to comment Share on other sites More sharing options...
0 rovinrambo Posted May 1, 2017 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 20 Reputation: 0 Joined: 01/10/14 Last Seen: May 19, 2017 Author Share Posted May 1, 2017 7 hours ago, Freya said: Hello, okay, here. In your login_athena that is where your MySQL username and password lies. You place them in there, however in char_athena and map_athena( or login_athena, I forgot) userid and passwd, that is your server's userid and passwd, your MySQL username and password is not the same with the userid and passwd of your server. Place your MySQL username and password in your inter_athena.conf. Place your userid and passwd in your ragnarok->login table if you do not remember something like this it should be account_id = 1 userid = userid of char_athena and login_athena (again, I forgot) passwd = passwd of char_athena and login_athena I did this and it gave me error. The one the i was editing is from conf/import . Should i also change the conf outside of this folder? 7 hours ago, rovinrambo said: I did this and it gave me error. The one the i was editing is from conf/import . Should i also change the conf outside of this folder? hey bro , nevermind. it is up and running . what u said was right, i just forgot to save my works . Thanks! Quote Link to comment Share on other sites More sharing options...
0 ragexe Posted June 16, 2017 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 20 Reputation: 0 Joined: 05/30/17 Last Seen: January 13, 2023 Share Posted June 16, 2017 Hello i got same problem, how to fix it? Quote Link to comment Share on other sites More sharing options...
Question
rovinrambo
Hi guys, I was 100% sure that i made all the userid and passwd the same but i've been getting these errors. I couldn't find where it comes from. Need ya help!
Thanks!
Link to comment
Share on other sites
12 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.