1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Problem with accessing Plesk set up tables from Java

Discussion in 'Plesk for Linux - 8.x and Older' started by coglethorpe, Aug 1, 2005.

  1. coglethorpe

    coglethorpe Guest

    I'm trying to connect to a MySQL database I set up with Plesk from Java. I'm running the Java code on the same machine as the server, but I still get an exception. The sample code and exceptions are below. Is there a different URL I should use to connect to? I have verified the username and password from the command line.

    The exception occurs in the call to "DriverManager.getConnection".

    Any help is appreciated....
    The code below works with my development setup on my desktop, but not on the server...

    --------The Exception-------

    java.sql.SQLException: Invalid authorization specification, message from server : "Access denied for user: 'myuser@VirtualServerName' (Using password: YES)"
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1825)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1752)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:833)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:1734)
    at com.mysql.jdbc.Connection.<init>(Connection.java:562)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :361)
    at java.sql.DriverManager.getConnection(DriverManager.java:512)
    at java.sql.DriverManager.getConnection(DriverManager.java:171)
    at DBTester.main(DBTester.java:23)

    ---------The Code------------
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.Statement;

    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.Statement;

    public class DBTester

    public static void main(String[] args)
    String deals = null;


    // Load the JDBC

    // specify the data source's URL
    String url = "jdbc:mysql://localhost/test";

    // connect
    Connection con = DriverManager.getConnection(url, "myuser","mypass");

    // create and execute a SELECT
    Statement stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT * FROM mytable;");

    while (rs.next())

    String fieldValue = rs.getString(1);

    System.out.println("fieldValue: " + fieldValue);

    // close statement and connection
    catch (java.lang.Exception ex)


  2. Mohammed Mukhtar

    Mohammed Mukhtar New Pleskian

    Jun 6, 2017
    Likes Received:
    Jeddah, Saudi Arabia
    You have to give the connections URL as follows:

    String url = "jdbc:mysql://[IP Address]/test";

    where IP Address is the address of Website/Domain