sql help

Discussion in 'Plugin Development' started by callum.thepro, Sep 16, 2013.

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

    callum.thepro

    Okay, i am messing around with sql trying to learn how to use it. I have come across a problem though which some of you are probably familiar with too!

    java.sql.SQLException: null, message from server: "Host '<snip>' is not allowed to connect to this MySQL server"
     
  2. Offline

    RainoBoy97

    Well, the user you are using does not have access to the database?
     
  3. Offline

    callum.thepro

    I can login on the site which is hosting it but i just cant manually get to it through code in eclipse.
     
  4. Offline

    EdenCampo

    callum.thepro

    The problem ins't the eclipse, something is wrong with your SQL user permissions probably, contact your host.
     
  5. Offline

    callum.thepro

  6. Offline

    metalhedd


    Most hosts don't allow remote connections to mysql. when you connect through the web interface, the web interface is making a local connection to the database, that's why it's allowed. you'll need to configure your database to allow remote connections from your server. That's well out of the scope of bukkit support, you'll need to contact your host.
     
    CubieX likes this.
  7. Offline

    callum.thepro

    Does anyone know any hosts which allow remote access?
     
  8. Offline

    metalhedd


    I should have clarified, what I meant to say was:

    Most hosts don't allow remote connections to mysql by default. you should be able to configure it to allow certain users to connect only from certain hosts, and your host should be able to help you figure out how to do that.
     
  9. Offline

    callum.thepro

    The host insists that it remains disabled due to security reasons. Any hosts which I can test MySQL on remotely?
     
  10. Offline

    EdenCampo

    callum.thepro

    I'll try making my MySQL publicly connectable, wait a few minutes.
     
Thread Status:
Not open for further replies.

Share This Page