Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: MySQL

  1. #1
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    2
    Thanks
    2
    Thanked 0 Times in 0 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!.

    Error:

    Code:
    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
    :266)
            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...
    java.lang.NullPointerException
            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
    bdl
    bdl is offline
    Regular Coder
    Join Date
    Apr 2007
    Location
    Camarillo, CA US
    Posts
    590
    Thanks
    4
    Thanked 83 Times in 82 Posts
    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.

  • Users who have thanked bdl for this post:

    Axed (04-15-2009)

  • #3
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,103
    Thanks
    80
    Thanked 4,554 Times in 4,518 Posts
    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.

  • Users who have thanked Old Pedant for this post:

    Axed (04-15-2009)

  • #4
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    2
    Thanks
    2
    Thanked 0 Times in 0 Posts
    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.


  •  

    Posting Permissions

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