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

Problem with mysql access set up through Plesk/phpMyAdmin

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

    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();
    }

    }
    }
     
Loading...