Help with JDBC (may not be available)

PPNSteve

Well-Known Member
Mar 13, 2003
413
3
168
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'"
 
Last edited:

PPNSteve

Well-Known Member
Mar 13, 2003
413
3
168
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)