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