• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

connecting JSP(resin) to MYSQL with out root

 
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
my redhat server runs mysql and resin

I have been able to connect my jsp pages to MYSQL with root login and passwork. I created another mysql account (mrdata) to with less priviledges for security reasons.

Now with the new user account mrdata I can not connect to the data base with JSP.

I get the error:

Client does not support authentication protocol requested by server; consider upgrading MySQL client (this does not make sense to me because I was getting the same error when I would try to login to phpmyadmin admin with this login. Then I changed the password to the old password format, and I was able to get into Phpmyadmin, however, I still could not get this login to connect the JSP.)


With the jsp code, I only needed the username and password changed. right? Here is the code:

<%@ page language="java" import="java.sql.*" %>
<%
String db = "dial";

String url="jdbc:mysql-caucho://localhost:3306/" + db;

Class.forName("com.caucho.jdbc.mysql.Driver");

Connection myConn = DriverManager.getConnection(url,"mrdata","rinkerton");
%>

Alex
 
Ranch Hand
Posts: 405
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I would verify that user'@'host and user'@'localhost%

has access to the database "dial". Are you using the MySQLClient application or the MySQLAdmin application?
 
Alex Hank
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am able to use this login to access the table "dial" through PHPMyAdmin.

I manage my accounts with PHPMyAdmin, and MySQL Administrator.

thanks
 
reply
    Bookmark Topic Watch Topic
  • New Topic