Problem/Bug Help needed ASAP with MySQL

Discussion in 'Bukkit Help' started by IanSzot, Jan 28, 2015.

Thread Status:
Not open for further replies.
  1. Offline

    IanSzot

    Hello!
    I have two minecraft servers, and in both of them I use the plugin Ban Management to spread the bans between the two servers.
    A few days ago, in both servers the plugin didnt enable and it was giving me an error saying that I had to execute "mysqladmin flush-hosts". I searched on Google and tried to execute "FLUSH HOSTS" on phpMyAdmin and the "mysqladmin flush-hosts" with SSH, both said that I had no permission to execute that command.
    I've contacted my host and they say that they can't do anything (which is obviously a lie), so I want to know if there's anything that I can do to try to execute that command or a really good free mysql host.

    PS: I've been using "db4free.net" as a temporary solution to the problem, but it's too damn slow!
     
  2. Offline

    Lolmewn Retired Staff

    Is there a stacktrace? Never even heard of 'flush-hosts'.
     
  3. Offline

    IanSzot


    [​IMG]
     
  4. Offline

    loslobos1234

    Flushing your mysql wont solve a thing its basically like windows return to factory settings

    If its a hosted server it depends on the host willing to use your mysql database trough an external connection,
    If its Home Hosted it can be because the login data are incorrect.
     
  5. Offline

    Boomer

    Alternately, from your query browser (such as phpMyAdmin), the SQL statement you're looking for is simply this:


    FLUSH HOSTS;


    It doesn't reset to factory default (data), it purges the list of ip-hosts that have been stored in the system, for example, the one of yours that it decides has generated too many connection errors, and has blocked from accessing it. It will re-enable access to it from that ip again, until it happens again..

    So as pointed out, there is an underlying problem caused by your database accessing program
     
Thread Status:
Not open for further replies.

Share This Page