error connecting to mysql using java

Question

i ran into a weird problem when connecting to mysql using java.

i'm running xampp with tomcat

i tried connecting to mysql from java. on my machine it works fine, but on a friends machine i get an error: access denied for user 'tomcat'@'localhost'

thing is - i managed to connect with the exact same info using php.

the java code for the connection is:

    String url = "jdbc:mysql://localhost:3306/";
    String dbName = "mta_db";
    String driver = "com.mysql.jdbc.Driver";
    String userName = "tomcat";
    String password = "tomcat";
    try {
        Class.forName(driver).newInstance();
        _conn = DriverManager.getConnection(url + dbName, userName, password);
    } catch (Exception e) {
        e.printStackTrace();
    }

port is fine

any idea what could be the cause?

premissions are fine. i can connect through php with no problem. SHOW GRANTS returns 2 rows with GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' WITH GRANT OPTION, GRANT PROXY ON "@" TO 'root'@'localhost' WITH GRANT OPTION. i tried user root also — galchen
– galchen, Commented Oct 21, 2011 at 15:01

Cody Caughlan · Accepted Answer · 2011-10-21 14:54:06Z

1

The error is probably on the MySQL side, that is, the tomcat user doesnt have privileges to connect from non-localhost.

For simplicities sake you can first create an account that is able to connect from anywhere, via the MySQL GRANT statement like so:

GRANT ALL ON mta_db.* to tomcat@'%' identified by 'yourpassword';

In this case the % is a wildcard for any host.

If you know the actual IPs of your connecting clients you can later crack it down, to be more security conscious.

answered Oct 21, 2011 at 14:54

Cody Caughlan

32.8k5 gold badges67 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

galchen Over a year ago

does not work. it connects fine from PHP btw, and i checked the privileges

Collectives™ on Stack Overflow

error connecting to mysql using java

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related