...

View Full Version : MySQL



Axed
04-14-2009, 10:05 AM
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:


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)

bdl
04-14-2009, 02:44 PM
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 (http://dev.mysql.com/doc/refman/5.1/en/tutorial.html) for some cursory advice. Otherwise, ask in the Java forum.

Great title, BTW. :p

Old Pedant
04-14-2009, 09:17 PM
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.

Axed
04-15-2009, 03:57 AM
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum