The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help with JDBC (may not be available)

Discussion in 'General Discussion' started by PPNSteve, Jul 17, 2005.

  1. PPNSteve

    PPNSteve Well-Known Member

    Joined:
    Mar 13, 2003
    Messages:
    393
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Somewhere in Ilex Forest
    cPanel Access Level:
    Root Administrator
    Twitter:
    Have a client wanting to use .jsp

    we have tomcat installed and have set this client to use it. now he's trying to connect to the MySQL database using JDBC and is recieving a permission denied error.

    anyone have any ideas on whats wrong and better yet, how to fix this??

    Code:
    Connection string:
    <%@ page import="java.sql.*" %> 
                   Connection connection = null;
                   Class.forName("org.gjt.mm.mysql.Driver").newInstance();
                   connection = DriverManager.getConnection(
                      "jdbc:mysql://localhost/gmandmor_crm?user=gmandmor_mis&password=*******");
    with error message:
    Code:
    java.sql.SQLException: Invalid authorization
    specification message from
    server: "Access denied for user 'gmandmor_mis'@'61.247.254.85'
    (using password: YES)"
    
    complete erro message recieved:
    Code:
    The Error which i got is:
    
    java.sql.SQLException: Syntax error or access violation message from 
    server: "Access denied for user 'gmandmor_mis'@'' to 
    database 'gmandmor_crm'"
    
     
    #1 PPNSteve, Jul 17, 2005
    Last edited: Jul 17, 2005
  2. PPNSteve

    PPNSteve Well-Known Member

    Joined:
    Mar 13, 2003
    Messages:
    393
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Somewhere in Ilex Forest
    cPanel Access Level:
    Root Administrator
    Twitter:
    :(

    Help a jsp-less n00b help his client.... anyone have any ideas here?

    do any of you running tomcat have any suggestions / help on this MySQL connection problem?

    sorry to double post... but i do need some help here.. and i'm not sure if it's the client or tomcat thats broken
    (his javatest page DIDN'T work after i set him up for java)
     
Loading...

Share This Page