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

    0
     
    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;

    try
    {

    // Load the JDBC
    Class.forName("com.mysql.jdbc.Driver");

    // 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
    stmt.close();
    con.close();
    }
    catch (java.lang.Exception ex)
    {

    ex.printStackTrace();
    }

    }
    }
     
  2. Mohammed Mukhtar

    Mohammed Mukhtar New Pleskian

    1
     
    Joined:
    Jun 6, 2017
    Messages:
    1
    Likes Received:
    0
    Location:
    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
     
Loading...