Accessing the database for the first time

[RabbitRun 0]

Hi all,

 

As I am a very newb when it comes to creating servers, I so far reached every step successful using THIS tutorial and I'd like to thank the authors. 

 

However..

The last step is giving me headache, I can't get into the database. When connecting MYSQL to the db it says error code 1129 (blablabla is blocked due to too many connection errors- I'm sure you're familiar with that). Now I've searched many times and I did find a somewhat solution (even on this forum). But I'm a very newb to this so I'd like to ask someone who can explain me step to step on how to resolve this problem. This includes using the commands and where exactly. 

 

If you need more info, you may just ask it. You may also reply in French, Google knows alot

 

Thanks in advance,

RabbitRun

 

[Gurgarath 280]

Hello!

 

This is actually pretty weird that you got blocked but now we have another problem. Don't hesitate to ask again if you get blocked, it should not happen because the tutorial is pretty straight-forward and you should not end up like that.

First things first, you need to connect to MySQL from your Virtual Machine, just type the following command in the shell (hard part: you need to know your login informations):

mysqladmin -u root -ppassword flush-hosts

It should get the job done and reset the thing. Also if you are working on a local machine (I STRONGLY advise you not to do it on a live server) you can increase the number of failures allowed before locking you out by editing the "my.cnf" file located somewhere on your machine (grep the file, because it happened quite a lot to me to have the file installed in different directories for some reasons so I can't point you the exact directory).

Search for the line "max_connect_errors" which is by default set to ten (if I recall correctly) and upgrade it to whatever you want. It will lock you out after for example 200 bad credentials if you put the value to 200.

 

Have a great night and keep us updated!

 

Best regards,

[RabbitRun 0]

Hey Gurgarath,

 

Thank you for answering. The tutorial was indeed very easy to read and follow. Perfect for new members who want to create their own local. I appreciate your effort. 

 

I used the command and the problem was solved. I also increased limit a bit to avoid future problems. But ofcourse, knowing me, one problem after another

 

This time the error message below showed up. I already mastered the account so it should have full access, and I'm 100% sure the inserted password is correct. I did read something like changing that password by command, could you (or someone else) explain if that really is a solution, and if yes, what am I supposed to do? And if no, what other options I may have? Looking forward answers.

 

Thanks in advance,

RabbitRun

 

Edited October 9, 2019 by RabbitRun (see edit history)

[Gurgarath 280]

Hey, with pleasure!

 

You probably changed the default password which is "mcncc.com". Otherwise you can change it by command as you pointed out.

You need to type this in your shell: mysql -u root -p (and connect to MySQL) then type the following command:

GRANT ALL PRIVILEGES ON *.* TO 'USER'@'%' IDENTIFIED BY 'PASSWORD';

flush privileges;

 

Have a nice day

[RabbitRun 0]

Problem solved. Thanks once again.

 

Now just some silly beginner questions:

What actually happens if I use the /shutdown command ingame? I know it is used for maintenance mode, but how do I put it back on?

How do I make my translations being saved? (I found the item_names etc it just needs to safe)

How can I manually add an ingame account?

 

Thanks in advance 

[Gurgarath 280]

Il y a 13 heures, RabbitRun a dit :

Problem solved. Thanks once again.

 

Now just some silly beginner questions:

What actually happens if I use the /shutdown command ingame? I know it is used for maintenance mode, but how do I put it back on?

How do I make my translations being saved? (I found the item_names etc it just needs to safe)

How can I manually add an ingame account? 

 

Thanks in advance 

Hello!

 

1) If you shutdown it, you need to run the command "sh close.sh" then "sh start.sh" in the shell to restart your server.

2) You save the file item_names. Then if you want them to appear clientside, you need to use the tool "dump_proto". The tutorial is there in french, I will translate it soon.

 But serverfiles and client in english also exists.

3) You go to the database account, table account and fill the blanks (not all of them). For the password, it need to be hashed in MySQL5, in uppercase with an asterisk before (*)

 

Have a nice day

[Gurgarath 280]

Solved - The topic is solved and hence moved to the sub-forum: Résolu ou sans réponse...