Web Analytics Made Easy -
StatCounter MySQL - CodingForum


No announcement yet.


  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL

    Ok, I'm a new member and I need some help, I'm not very experienced in MySQL. I got all the right info in my server and all but when ever I run the server I get access is denied. I don't know why and YES MY HOST DOES ALLOW MYSQL CONNECTIONS/ALL PRIVILEGES ARE SET!.


    java.sql.SQLException: Access denied for user 'Axed'@'MYIPADRESS' (using password: YES)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:868)
            at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3340)
            at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1238)
            at com.mysql.jdbc.Connection.createNewIO(Connection.java:2743)
            at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
            at java.sql.DriverManager.getConnection(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at vBulletin_Integration.mysqlConnect(vBulletin_Integration.java:46)
            at vBulletin_Integration.<init>(vBulletin_Integration.java:40)
            at server.main(server.java:134)
    Updating shouts...
            at vBulletin_Integration.getResultSetData(vBulletin_Integration.java:56)
            at Inferno.updateShouts(Inferno.java:72)
            at Inferno.<init>(Inferno.java:30)
            at server.main(server.java:135)

  • #2
    Looks like a question for the Java forum, unless you can provide some actual troubleshooting you've done connecting to the MySQL server some other way, e.g. via phpMyAdmin, the 'mysql' command line client, etc.

    Is MYIPADDRESS a constant in your Java class, or something you threw in the post to mask your actual IP?

    Check the MySQL Manual's tutorial for some cursory advice. Otherwise, ask in the Java forum.

    Great title, BTW.


    • #3
      Almost inevitiably that error indeed means that the privileges are *not* set up right, despite what you may think. Used to get that all the time with JDBC and MySQL whenever I'd set up a new DB and forget to do all the right "GRANT PRIVILEGE" commands. It may not be something you can fix; your web host may need to change something for you, depending on what admin rights to the DB that they have given you. It's not really Java-specific; it just manifests with that error message because of the way the JDBC driver handles the MySQL error.
      Be yourself. No one else is as qualified.


      • #4
        Thanks for all you help, I contacted my host and told them of this error, and yes they are trying to set me more permissions for MySQL, so thanks for all your help.