Thread: MYSQL Connection Error

Results 1 to 9 of 9
  1. #1 MYSQL Connection Error 
    Banned
    Join Date
    Apr 2009
    Posts
    106
    Thanks given
    0
    Thanks received
    1
    Rep Power
    0
    Okay so I need to add MYSQL.createConnection(); to connect to my MYSQL database. The server startups fine but when someone logs in I get this error and it nulls. Help Please. It might be the wrong location of MYSQL.createConnection();

    Code:
    com.mysql.jdbc.CommunicationsException: Communications link failure due to under
    lying exception:
    
    ** BEGIN NESTED EXCEPTION **
    
    java.net.ConnectException
    MESSAGE: Connection refused: connect
    
    STACKTRACE:
    
    java.net.ConnectException: Connection refused: connect
            at java.net.PlainSocketImpl.socketConnect(Native Method)
            at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
            at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
            at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
            at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
            at java.net.Socket.connect(Socket.java:525)
            at java.net.Socket.connect(Socket.java:475)
            at java.net.Socket.<init>(Socket.java:372)
            at java.net.Socket.<init>(Socket.java:215)
            at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
    va:173)
            at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:267)
            at com.mysql.jdbc.Connection.createNewIO(Connection.java:2739)
            at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
    :266)
            at java.sql.DriverManager.getConnection(DriverManager.java:582)
            at java.sql.DriverManager.getConnection(DriverManager.java:185)
            at MYSQL.createConnection(MYSQL.java:12)
            at server.run(server.java:272)
            at java.lang.Thread.run(Thread.java:619)
    
    
    ** END NESTED EXCEPTION **
    
    
    
    Last packet sent to the server was 14 ms ago.
            at com.mysql.jdbc.Connection.createNewIO(Connection.java:2814)
            at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
    :266)
            at java.sql.DriverManager.getConnection(DriverManager.java:582)
            at java.sql.DriverManager.getConnection(DriverManager.java:185)
            at MYSQL.createConnection(MYSQL.java:12)
            at server.run(server.java:272)
            at java.lang.Thread.run(Thread.java:619)
    Reply With Quote  
     

  2. #2  
    Donator

    Ecstasy's Avatar
    Join Date
    Sep 2008
    Age
    29
    Posts
    5,031
    Thanks given
    324
    Thanks received
    596
    Rep Power
    843
    Who's tutorial did you use?

    Reply With Quote  
     

  3. #3  
    Banned
    Join Date
    Apr 2009
    Posts
    106
    Thanks given
    0
    Thanks received
    1
    Rep Power
    0
    Roguex
    Reply With Quote  
     

  4. #4  
    Donator

    Ecstasy's Avatar
    Join Date
    Sep 2008
    Age
    29
    Posts
    5,031
    Thanks given
    324
    Thanks received
    596
    Rep Power
    843
    Hmm. Basically what that's saying is that it can't connect to the IP that you're using. If you're connecting to your websites IP, your webhost most likely doesn't allow incoming connections.

    Reply With Quote  
     

  5. #5  
    Banned
    Join Date
    Apr 2009
    Posts
    106
    Thanks given
    0
    Thanks received
    1
    Rep Power
    0
    I have it set as the host as a localhost so that seems correct, the only thing I can see wrong is placing the MYSQL.createConnection(); in the wrong spot.
    Reply With Quote  
     

  6. #6  
    Donator

    Ecstasy's Avatar
    Join Date
    Sep 2008
    Age
    29
    Posts
    5,031
    Thanks given
    324
    Thanks received
    596
    Rep Power
    843
    No, that wouldn't change it. Hmm. Did you put the correct database in?

    Reply With Quote  
     

  7. #7  
    Banned
    Join Date
    Apr 2009
    Posts
    106
    Thanks given
    0
    Thanks received
    1
    Rep Power
    0
    Yes but the error given says the connection is refused so....
    Reply With Quote  
     

  8. #8  
    Banned
    Join Date
    Apr 2009
    Posts
    106
    Thanks given
    0
    Thanks received
    1
    Rep Power
    0
    B
    u
    m
    p
    Reply With Quote  
     

  9. #9  
    Banned

    Join Date
    Jul 2009
    Posts
    915
    Thanks given
    1
    Thanks received
    10
    Rep Power
    0
    told ya m8 you need to buy hosting
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •